Article ID: 925060
Article Last Modified on 8/15/2007
APPLIES TO
- Microsoft Dynamics CRM 3.0
SYMPTOMS
When you try to upgrade a database from an earlier version of Microsoft Dynamics CRM to Microsoft Dynamics CRM 3.0, the database is not upgraded. Additionally, you receive the following Microsoft SQL Server error message:
time
| Error| Install exception.System.Exception: Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.Setup.DatabaseInstaller.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout)
at Microsoft.Crm.Setup.DatabaseInstaller.SqlScriptAction.Execute()
at Microsoft.Crm.Setup.DatabaseInstaller.DatabaseInstaller.Install(Int32 languageCode, String file, Boolean upgrade)
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 ---
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
at Microsoft.Crm.Setup.Server.DatabaseInstaller.Install(IDictionary stateSaver)
at Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary stateSaver)
at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary stateSaver)
at Microsoft.Crm.Setup.Server.ServerSetup.Upgrade(IDictionary data) at Microsoft.Crm.Setup.Server.ServerSetup.Run() time
| Info| Microsoft CRM 3.0 Server Setup Failed. time
| Info| Microsoft CRM 3.0 Server Setup Setup did not complete successfully. Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. String or binary data would be truncated. The statement has been terminated.
CAUSE
This problem may occur when the length of the AddressUsed column in the ActivityPartyBase table exceeds 200 characters.
RESOLUTION
To resolve this problem immediately, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
Additional query words: crm3 crm30 crm3.0
Keywords: kbtshoot kberrmsg kbsetup kbmbsupgrade kbmbsmigrate kbprb KB925060