During upgrade to Backup Exec 2012 the Database Migration fails with error Arithmetic overflow error converting expression to data type int.

Article:TECH185928  |  Created: 2012-04-05  |  Updated: 2013-12-10  |  Article URL http://www.symantec.com/docs/TECH185928
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



During a upgrade to Backup 2012 the Database Migration fails and the option is presented to continue or roll back. Reviewing the Backup Exec 2012 installation log (BKUPEXEC2012.HTM) the migration fails with error Arithmetic overflow error converting expression to data type int.


Error



Failure 1 running migration library
BE Migration Tool execution failed

 

 


 


Environment



Backup Exec 2012

Upgrade from previous version of Backup Exec.


 


Cause



Database migration fails with:

Arithmetic overflow error converting expression to data type int.
dbutil RunSQLScript: execute sql cmd failed. sql statement: exec dbo.mig_ConsolidateJobOptions]
dbutil RunSQLScript:Stop execution sql script
dbutil RunSQLScript: failed: 0x80040e57
OS ERROR: 0x80040e57 (-2147217833)

 


Solution



A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.

Backup Exec 2012 Rev 1798 Service Pack 2 (TECH203155)
 

Please select the option to Roll back the Installation to previous version, and then retry the upgrade using the Backup Exec 2012 SP2 or later embedded installation media to resolve the issue.  The latest media can be downloaded via http://fileconnect.symantec.com.


Supplemental Materials

SourceETrack
Value2754711
Description

Upgrades fail with "Arithmetic overflow error converting expression to data type int"




Article URL http://www.symantec.com/docs/TECH185928


Terms of use for this information are found in Legal Notices