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|
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.
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.
Backup Exec 2012
Upgrade from existing installation of Backup Exec
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.
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
This issue is now resovled in Backup Exec 2012 Service Pack 1a (TECH186717).
Perform the upgrade using Backup Exec 2012 SP1 installation media.
Upgrade Migration fails with Failure 1 running migration library 1. RunSQLScript: execute sql cmd failed. sql statement: exec [mig_FixDBAgentBackupOptions]
The Backup Exec database migration did not complete successfully.
Article URL http://www.symantec.com/docs/TECH183112