Help and Support
 

powered byLive Search

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"

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

SYMPTOMS

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


APPLIES TO
Microsoft Dynamics CRM 4.0

Back to the top

Keywords: 
kberrmsg kbmbsupgrade kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB946590

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.