By Marcio Valerio Silva - 10/27/2010
When do I Try to Deployment Messages with DDT I Have the Error:
• 27/10/2010 11:11:57 -> Deploying meta-data for database 'm2enterprise'
• 27/10/2010 11:11:57 -> Ensuring Filegroups exist on database 'm2enterprise'
• 27/10/2010 11:11:57 -> Filegroup verification complete.
• 27/10/2010 11:11:57 -> Ensuring Tables exist on database 'm2enterprise'
• 27/10/2010 11:12:27 -> The table 'MessageItems' was created successfully.
• 27/10/2010 11:12:27 -> The table 'MessageLanguages' was created successfully.
• 27/10/2010 11:12:27 -> Table verification complete.
• 27/10/2010 11:12:27 -> Dropping unneeded filegroups for 'm2enterprise'
• 27/10/2010 11:12:27 -> Unneeded filegroups dropped on database 'm2enterprise'
• 27/10/2010 11:12:27 -> Ensuring Indexes exist on database 'm2enterprise'
• 27/10/2010 11:12:33 -> The index 'PK_MessageItems' was created successfully.
• 27/10/2010 11:12:33 -> The index 'PK_MessageLanguages' was created successfully.
• 27/10/2010 11:12:33 -> Index verification complete.
• 27/10/2010 11:12:33 -> Ensuring Foreign Keys exist on database 'm2enterprise'
• 27/10/2010 11:12:36 -> Foreign Key verification complete.
• 27/10/2010 11:12:36 -> Ensuring Triggers exist on database 'm2enterprise'
• 27/10/2010 11:12:36 -> Trigger verification complete.
• 27/10/2010 11:12:36 -> Ensuring Assemblies exist on database 'm2enterprise'
• 27/10/2010 11:12:36 -> Assembly verification complete.
• 27/10/2010 11:12:36 -> Ensuring Views, Stored Procedures, and UDFs exist on database 'm2enterprise'
• 27/10/2010 11:12:36 -> The view 'SFSUserPermissionInfo' was created successfully.
• 27/10/2010 11:12:36 -> The view 'SFSUserRolePermissionInfo' was created successfully.
X 27/10/2010 11:12:36 -> An error occurred while creating the stored procedure [dbo].[].
X 27/10/2010 11:12:36 -> SqlException
X 27/10/2010 11:12:36 -> Um nome de objeto ou coluna está ausente ou está vazio. Verifique se as colunas das instruções SELECT INTO têm nomes. Nas outras instruções, procure nomes de alias vazios. Aliases definidos como "" ou [] não são permitidos. Altere o alias para um nome válido.
X 27/10/2010 11:12:36 ->
X 27/10/2010 11:12:36 -> Source : .Net SqlClient Data Provider
X 27/10/2010 11:12:36 ->
X 27/10/2010 11:12:36 -> Stack Trace:
X 27/10/2010 11:12:36 -> em System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 27/10/2010 11:12:36 -> em System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 27/10/2010 11:12:36 -> em System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 27/10/2010 11:12:36 -> em System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 27/10/2010 11:12:36 -> em System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 27/10/2010 11:12:36 -> em System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 27/10/2010 11:12:36 -> em System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 27/10/2010 11:12:36 -> em MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)
X 27/10/2010 11:12:36 ->
• 27/10/2010 11:12:37 -> View, Stored Procedure, and UDF verification complete.
• 27/10/2010 11:12:37 -> Ensuring Indexes exist on database 'm2enterprise'
• 27/10/2010 11:12:37 -> Index verification complete.
• 27/10/2010 11:12:37 -> Finished verifying databases on server.
• 27/10/2010 11:12:37 -> The meta data conversion to the SQL Server has been completed.
• 27/10/2010 11:12:40 -> Deploying data for SFSRoles complete: 0 records
• 27/10/2010 11:12:40 -> Deploying data for SFSRolesXPermissions complete: 0 records
• 27/10/2010 11:12:40 -> Deploying data from SFSUsersXRoles...
• 27/10/2010 11:12:40 -> Deploying data for SFSUsersXRoles complete: 0 records
• 27/10/2010 11:12:40 -> Deploying data from SFSPermissions...
• 27/10/2010 11:12:41 -> Deploying data for SFSPermissions complete: 120 records
• 27/10/2010 11:12:41 -> Deploying data for SFSUsers complete: 0 records
• 27/10/2010 11:12:41 -> Deploying data for SFSUsersXPermissions complete: 0 records
• 27/10/2010 11:12:41 -> Deploying data for SFSPreferences complete: 0 records
• 27/10/2010 11:12:41 -> Deploying data from SFSRestrictions...
• 27/10/2010 11:12:41 -> Deploying data for SFSRestrictions complete: 0 records
• 27/10/2010 11:12:41 -> Deploying data from SFSRestrictionItems...
• 27/10/2010 11:12:41 -> Deploying data for SFSRestrictionItems complete: 0 records
• 27/10/2010 11:12:41 -> Deploying data from MessageItems...
• 27/10/2010 11:12:41 -> Deploying data for MessageItems complete: 0 records
• 27/10/2010 11:12:41 -> Deploying data from MessageLanguages...
• 27/10/2010 11:12:41 -> Deploying data for MessageLanguages complete: 2 records
• 27/10/2010 11:12:42 -> Data Deployment has been completed
My question is Why do I have this Error "X 27/10/2010 11:12:36 -> An error occurred while creating the stored procedure [dbo].[]." if it is generate automatic and I cant permission to delete it or edit it?
What I do to remove this error?
at,
Marcio Valerio
|
By Ivan George Borges - 10/27/2010
Hi Marcio.
According to the log you have just sent, the Messages were all deployed succesfully.
You are getting an exception when trying to deploy a view. Haven't you by any means created a new view with your DDT project? If so, check the contents of it, as the message is telling you there is something wrong with it:
X 27/10/2010 11:12:36 -> Um nome de objeto ou coluna está ausente ou está vazio. Verifique se as colunas das instruções SELECT INTO têm nomes. Nas outras instruções, procure nomes de alias vazios. Aliases definidos como "" ou [] não são permitidos. Altere o alias para um nome válido.
|
By Marcio Valerio Silva - 10/27/2010
Hi Ivan.
I dont understand this error. When I delete the deployment it disapear!
I create a new project DDT with a new BD an it has the same error:
• 27/10/2010 12:10:55 -> Ensuring Filegroups exist on database 'teste21'
• 27/10/2010 12:10:55 -> Filegroup verification complete.
• 27/10/2010 12:10:55 -> Ensuring Tables exist on database 'teste21'
• 27/10/2010 12:10:55 -> The table 'customer' was created successfully.
• 27/10/2010 12:10:55 -> The table 'MessageItems' was created successfully.
• 27/10/2010 12:10:55 -> The table 'MessageLanguages' was created successfully.
• 27/10/2010 12:10:55 -> Table verification complete.
• 27/10/2010 12:10:55 -> Dropping unneeded filegroups for 'teste21'
• 27/10/2010 12:10:56 -> Unneeded filegroups dropped on database 'teste21'
• 27/10/2010 12:10:56 -> Ensuring Indexes exist on database 'teste21'
• 27/10/2010 12:10:56 -> The index 'PK_customer' was created successfully.
• 27/10/2010 12:10:56 -> The index 'PK_MessageItems' was created successfully.
• 27/10/2010 12:10:56 -> The index 'PK_MessageLanguages' was created successfully.
• 27/10/2010 12:10:56 -> Index verification complete.
• 27/10/2010 12:10:56 -> Ensuring Foreign Keys exist on database 'teste21'
• 27/10/2010 12:10:56 -> Foreign Key verification complete.
• 27/10/2010 12:10:56 -> Ensuring Triggers exist on database 'teste21'
• 27/10/2010 12:10:56 -> Trigger verification complete.
• 27/10/2010 12:10:56 -> Ensuring Assemblies exist on database 'teste21'
• 27/10/2010 12:10:56 -> Assembly verification complete.
• 27/10/2010 12:10:57 -> Ensuring Views, Stored Procedures, and UDFs exist on database 'teste21'
X 27/10/2010 12:10:57 -> An error occurred while creating the stored procedure [dbo].[].
X 27/10/2010 12:10:57 -> SqlException
X 27/10/2010 12:10:57 -> Um nome de objeto ou coluna está ausente ou está vazio. Verifique se as colunas das instruções SELECT INTO têm nomes. Nas outras instruções, procure nomes de alias vazios. Aliases definidos como "" ou [] não são permitidos. Altere o alias para um nome válido.
X 27/10/2010 12:10:57 ->
X 27/10/2010 12:10:57 -> Source : .Net SqlClient Data Provider
X 27/10/2010 12:10:57 ->
X 27/10/2010 12:10:57 -> Stack Trace:
X 27/10/2010 12:10:57 -> em System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 27/10/2010 12:10:57 -> em System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 27/10/2010 12:10:57 -> em System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 27/10/2010 12:10:57 -> em System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 27/10/2010 12:10:57 -> em System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 27/10/2010 12:10:57 -> em System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 27/10/2010 12:10:57 -> em System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 27/10/2010 12:10:57 -> em MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)
X 27/10/2010 12:10:57 ->
• 27/10/2010 12:10:57 -> View, Stored Procedure, and UDF verification complete.
• 27/10/2010 12:10:57 -> Ensuring Indexes exist on database 'teste21'
• 27/10/2010 12:10:57 -> Index verification complete.
• 27/10/2010 12:10:57 -> Finished verifying databases on server.
• 27/10/2010 12:10:57 -> The meta data conversion to the SQL Server has been completed.
• 27/10/2010 12:10:59 -> Deploying data from MessageItems...
• 27/10/2010 12:10:59 -> Deploying data for MessageItems complete: 0 records
• 27/10/2010 12:11:00 -> Deploying data from MessageLanguages...
• 27/10/2010 12:11:00 -> Deploying data for MessageLanguages complete: 1 records
• 27/10/2010 12:11:00 -> Data Deployment has been completed
Seems it try to create a view without name.
What Can I do?
|
By Ivan George Borges - 10/27/2010
I have no idea at the moment, Marcio. I would have to check this a bit deeper and having some project sample at hand.
Despite of this, I would recommend you to use a different approach with your Messages & Localization files. Using Embedded XML files is the best practice for the Message Store. Have a look at the help file under: "Application Framework" / "Localizations & Messaging" / "Messaging" / "Configuring the Message Store" / "Using Embedded XML Files"
|
By Marcio Valerio Silva - 10/27/2010
it´s fine I´ll Try.
Thanks.
at,
Marcio valerio
|
By Ivan George Borges - 10/27/2010
You are welcome. 
|
|