Upgrade to Backup Exec 2012 fails during database migration with Failure 1 running migration library 1.
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.
Backup Exec Install or Migraton Log reports:
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]
Failure 1 running migration library 1
BE Migration Tool execution failed
This issue has been addressed with a Hotfix