Microsoft KB Archive/925060

From BetaArchive Wiki
Knowledge Base


Error message when you try to upgrade a database to Microsoft Dynamics CRM 3.0: "String or binary data would be truncated"

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