Upgrade to Backup Exec 2012 fails during database migration with Failure 1 running migration library 1.

Article:TECH183112  |  Created: 2012-03-06  |  Updated: 2012-06-18  |  Article URL http://www.symantec.com/docs/TECH183112
Article Type
Technical Solution


Issue



During an upgrade to Backup Exec 2012 the upgrade migration fails and the option to roll back or continue the installation is presented.  The migration fails with Failure 1 running migration library 1 error.

 

NOTE: It is recommended to roll back the installation.

 


Error



Failure 1 running migration library 1
BE Migration Tool execution failed

 

Upgrade to Backup Exec 2012 fails with error: The Backup Exec database migration did not complete successfully.
 


Environment



Backup Exec 2012

Upgrade from existing installation of Backup Exec


Cause



Backup Exec Installation Log (BKUPINST2012.HTM) reports the following errors:

NOTE: The Backup Exec Installation log is located in C:\Users\All Users\Symantec\Backup Exec\Logs or C:\Documents and Settings\All Users\Application Data\Backup Exec\Logs.

 

BKUPINST2012.HTM Log


OpenFromInitializationString Connection String = Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BEDB;Data Source=SERVER\BkupExec;Locale Identifier=1033;Application Name=BEWS DBUTIL hr=0x0
The statement has been terminated.
Violation of PRIMARY KEY constraint 'PK_DBAgentBackupOptions'. Cannot insert duplicate key in object 'dbo.DBAgentBackupOptions'.
dbutil RunSQLScript: execute sql cmd failed. sql statement: exec [mig_FixDBAgentBackupOptions]
dbutil RunSQLScript:Stop execution sql script
dbutil RunSQLScript: failed: 0x80040e2f
OS ERROR: 0x80040e2f (-2147217873)
Starting schedule upgrades.
Not doing schedule upgrades due to previous errors. rc=0x1
Done with schedule upgrades.
upgrade135x ends rc=1
Job Migration Failed
+ Failure 1 running migration library 1
Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\Migration\pvlupgrade.dll
Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\Migration\jobmigration.dll
Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\Migration\catupgrade.dll
Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\Migration\postmigrationprocessing.dll
+ BE Migration Tool execution failed
Migration returned value: 1

 


Solution



This issue is now resovled in Backup Exec 2012 Service Pack 1a (TECH186717).

Perform the upgrade using Backup Exec 2012 SP1 installation media.


Supplemental Materials

SourceETrack
Value2711866
Description

Upgrade Migration fails with Failure 1 running migration library 1. RunSQLScript: execute sql cmd failed. sql statement: exec [mig_FixDBAgentBackupOptions]


SourceUMI
ValueV-225-289
Description

The Backup Exec database migration did not complete successfully.




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


Terms of use for this information are found in Legal Notices