Article ID: 946590 - Last Review: April 22, 2008 - Revision: 2.0

Error message when you try to upgrade Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0: "Action Microsoft.Crm.Setup.Server.InstallDatbaseAction failed"

When you try to upgrade Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0, you receive the following error message:

Action Microsoft.Crm.Setup.Server.InstallDatbaseAction failed. Cannot alter the table 'Table_name' because it is being published for replication. Could not drop constraint. See previous errors.

Additionally, the following error messages are logged in the Setup.log file:

System.Exception: Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Data.SqlClient.SqlException: There is already an object named 'AttributeTypes' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout)
at Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection releases, Int32 currentProgress)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal() at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---, Error, RetryCancel, Option1

Back to the top

CAUSE

This problem occurs because the Microsoft SQL Server Replication is enabled.

Back to the top

RESOLUTION

To resolve this problem, disable SQL Server Replication, and then try to upgrade Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0 again.

For more information about how to disable SQL Server Replication, visit the following MIcrosoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms151759.aspx (http://msdn2.microsoft.com/en-us/library/ms151759.aspx)

Back to the top