Owner SQL Server


Author
Message
Luiz Carneiro Lima
Luiz Carneiro Lima
StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)
Group: Forum Members
Posts: 25, Visits: 87
Boa tarde,

Criei um profiler no Database Deployment Toolkit... Na base de dados uso um owner (dbaxxx), mas quando eu importo as tabelas o owner volta para o defauld (dbo).

Criei um projeto, fiz toda configuração do Business Object Mapper, criei o form e configurei os campos do business object nos textbox mas quando eu mando executar aparece uma mensagem de erro que segue em anexo.

Isso acontece por que ele tenta buscar na tabela dbaxxx.nometabela mas pelo strataframe ele procura por dbo.nometabela??

Fico no aguardo de um retorno.

Attachments
ErroOwner.jpg (99 views, 161.00 KB)
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi guys.

A quick translation here so you can help as well.

Basically they are saying they have a different owner in their SQL Server database, which is dbaxxx. And when they import the tables with the DDT, the owner goes to dbo.

Then, at run time, they are getting the error above, and wonder if this is the reason.

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Bottom line is that this will just have to be added to the list.  Thinking on it, I do not think that the owner is being respected on the import.  You can fix this yourself once the import is complete by right-clicking the table, clicking Table Properties, and then manually fixing the schema.  Once set here it will work properly when deployed.  Also, you may need to rebuild the partial class of the BOs as well once the change has been made to update the schema on the BO.

I have added this to the list of items that need to be updated.  Thanks for the info.

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Oi Ângela.

Caso você não tenha entendido a explicação do Trent, eu vou repetir para você.

Eles estão adicionando isto à lista do que precisa ser alterado, e agradecem pelo alerta.

Enquanto isto, para arrumar aí no seu lado, uma vez que a importação foi feita, click com o botão da direita na tabela, e click Table Properties, e manualmente corriga o Schema, como na figura acima que ele anexou para você. Uma vez corrigido neste ponto, irá funcionar corretamente no deploy. Além disto, você pode ter que fazer o Rebuild Partial para as classes dos BOs uma vez que tenha feito as mudanças, para alterar o schema no BO.

Veja se vai bem deste jeito.

Abraços.

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
It has bee a DDT day BigGrin  I went ahead and fixed the import to properly set the Schema.  Just copy the attached EXE once extracted to the Program Files\MicroFOur\StrataFrame folder and overwrite the existing EXE.  This should get you going though.
Attachments
DDT.zip (88 views, 755.00 KB)
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Trent L. Taylor (07/17/2007)
It has bee a DDT day BigGrin  I went ahead and fixed the import to properly set the Schema.  Just copy the attached EXE once extracted to the Program Files\MicroFOur\StrataFrame folder and overwrite the existing EXE.  This should get you going though.

Oi de novo.

Acho que você entendeu, mas só pra confirmar, copie o EXE após extrair deste arquivo anexado, a sua pasta Program Files\MicroFOur\StrataFrame por cima do já existente lá. Isto já arruma o problema que você encontrou com a importação.

Eles fazem correções mais rápido do que eu consigo traduzir aqui para você!

"They fix things faster than I can translate the solutions for you!" w00t

Luiz Carneiro Lima
Luiz Carneiro Lima
StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)StrataFrame Beginner (25 reputation)
Group: Forum Members
Posts: 25, Visits: 87
Ah, muito obrigada!

Já fiz a alteração do owner manualmente, mas vou fazer a extração do arquivo aqui pra arrumar já!

O atendimento de vocês é muito eficiente!

Abraços

Angela

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search