Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Upgrade Failure Error ...
Microsoft Dynamics CRM (Archived)

Upgrade Failure Error CRM 2015 to CRM 2016

(0) ShareShare
ReportReport
Posted on by Community Member

We successfully upgraded CRM 2011 RU 18 to CRM 2013 SP1 had a few errors but successfully addressed all; then upgraded CRM 2013 SP1 to CRM 2015 Update 0.3 without any errors.  Both upgrades used Deployment Manager Organization Import for the previous CRM DB version backup.  Now, performing CRM 2015 Update 0.3 to CRM 2016 base upgrade using new CRM 2016 application and database servers via 2016 Deployment Manager Organization Import for 2015 DB.  This 2015 to 2016 is getting the error pasted below.  We've compared fields for max_length matching by table; evaluated "DBUpdate_" scripts but only to dead ends.  Any thoughts/next steps are much appreciated?  Is there a way to capture more detail in a log output?  Thanks.

13:26:25|   Info| Updating IsOneNoteIntegrationEnabled Attribute based on IsDocumentManagementEnabled
13:26:25|   Info| Did not detect single user -- not clearing pool
13:26:25|Verbose| DatabaseAction execution time; Scripts\DBUpdate_EnableOneNoteIntegration.sql; 00:00:00
13:26:25|   Info| Updating LocationType Attribute for existing SharePointDocument Location records
13:26:25|   Info| Did not detect single user -- not clearing pool
13:26:25|Verbose| DatabaseAction execution time; Scripts\DBUpdate_LocationTypeInSharepointDocumentLocation.sql; 00:00:00
13:26:25|   Info| Updating Decrement Entitlement Term for existing Case records
13:26:25|   Info| CrmAction execution time; UpgradeDatabaseAction; 00:18:25.7368547
13:26:25|  Error| Installer Complete: OrganizationUpgrader - Error encountered
13:26:26|  Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Error.ActionFailed Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction
InnerException:
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSqlCommands(String sql, IDbCommand cmd)
   at Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout, Boolean disablePool)
   at Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
   at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
   at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
   at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
   at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
   at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
ClientConnectionId:10b6f4f2-e3e0-47b3-9a22-31043ed6d574
Error Number:8152,State:5,Class:16

13:26:26|   Info| Setting organization state.  New state = Failed
13:26:26|  Error| Upgrade Organization with Id=cc9ce9b6-7b7c-df11-b0cd-005056c00008 failed with Exception:
System.Exception: Error.ActionFailed Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction ---> System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSqlCommands(String sql, IDbCommand cmd)
   at Microsoft.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout, Boolean disablePool)
   at Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility dbUtility)
   at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
   at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
   at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase)
   at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
   at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
   --- End of inner exception stack trace ---
   at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
   at Microsoft.Crm.Setup.Shared.Installer.Install(IDictionary stateSaver)
   at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
   at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
   at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
   at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Upgrade Failure Error CRM 2015 to CRM 2016

    Hi Jagmohan, thank you for the reply, and we've looked through these links most of which we have seen and used during our environment setups and initial test upgrades as we moved from 2011 to 2013 to 2015 all successfully.

    However, we are on 2015 Update 0.3 and are now trying to upgrade to 2016 Update 0.1 through the Deployment Manager Import (new application server and database server), we are now seeing the error posted above.  We need help on the error and how to find cause and address.

    Have you heard of anyone experiencing this type of error?  Any ideas as to how to determine which table/field is causing the string truncation error?  Or, how we could get more detail in an error log to isolate the issue?

    Thanks.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Upgrade Failure Error CRM 2015 to CRM 2016

    Hello,

    Please use below link:-

    community.dynamics.com/.../191582

    community.dynamics.com/.../234673

    Hope these links will be useful for you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans