Error message when you try to upgrade a database to Microsoft Dynamics CRM 3.0: "String or binary data would be truncated" (925060)
The information in this article applies to:
SYMPTOMSWhen 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. CAUSEThis problem may occur when the length of the AddressUsed column in the ActivityPartyBase table exceeds 200 characters.RESOLUTIONTo 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:
Modification Type: | Major | Last Reviewed: | 9/22/2006 |
---|
Keywords: | kberrmsg kbsetup kbMBSupgrade kbMSCCSearch kbMBSMigrate kbprb KB925060 kbAudEndUser |
---|
|