Microsoft KB Archive/925060

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

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:

| 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 | Info| Microsoft CRM 3.0 Server Setup Failed. | 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:

http://support.microsoft.com/default.aspx?scid=fh;[LN;CNTACTMS]

Additional query words: crm3 crm30 crm3.0

Keywords: kbtshoot kberrmsg kbsetup kbmbsupgrade kbmbsmigrate kbprb KB925060

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.