Messages Deployment.


Author
Message
Marcio Valerio Silva
Marcio Valerio Silva
StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)
Group: Forum Members
Posts: 55, Visits: 929
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 

at,

Marcio Valerio da Silva
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search