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 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.
Backup Exec 2012
Upgrade from existing installation of Backup Exec