Upgrade to BE 2012 fails with the error "Cannot insert duplicate key row in object 'dbo.Configuration' with unique index 'uidx_Configuration_Parameter'"

Article:TECH206739  |  Created: 2013-05-30  |  Updated: 2013-05-30  |  Article URL http://www.symantec.com/docs/TECH206739
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

Product(s)

Issue



Upgrade from Backup Exec 2010 R3 to Backup Exec 2012 fails with the error “Cannot insert duplicate key row in object 'dbo.Configuration' with unique index 'uidx_Configuration_Parameter'”


Error



Following error is logged in the BKUPINST2012.HTM file:
 

05-08-2013,21:11:57 : upgradeViaSQLScript m_JobMigInternal=0
05-08-2013,21:11:57 : upgradeViaSQLScript2 using CDBOperation SQLInstance=(null) SQLScriptFile=DBUpgrade13.5-3.sql
05-08-2013,21:11:57 : dbutil RunSQLScript: DBUpgrade13.5-3.sql SQLServer:MEDIA SERVERNAME SQLInstance:BkupExec DatabaseName:BEDB
05-08-2013,21:11:57 : OpenFromInitializationString Connection String = Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=BEDB;Data Source=MEDIA SERVERNAME\BkupExec;Locale Identifier=1033;Application Name=BEWS DBUTIL hr=0x0
05-08-2013,21:11:57 : The statement has been terminated.

05-08-2013,21:11:57 : Cannot insert duplicate key row in object 'dbo.Configuration' with unique index 'uidx_Configuration_Parameter'.
05-08-2013,21:11:57 : dbutil RunSQLScript: execute sql cmd failed. sql statement: INSERT INTO dbo.[Configuration]( Parameter, Class, Value,
Timestamp ) VALUES ( 'VirtualAgentSPLoginAcctID', 'BEC', '5c227ca3a96ae9419aa5d483b2b6971e', DEFAULT ) update dbo.[Configuration] set Value=1 where
Parameter='ChangeJournalBackup' update dbo.[Configuration] set Value=90 where Parameter='UserAccountTimeoutSecs' update dbo.[AlertMapping] set
EventName='Storage Information' where EventID=58055 update dbo.[AlertMapping]set EventN
05-08-2013,21:11:57 : dbutil RunSQLScript:Stop execution sql script
05-08-2013,21:11:57 : dbutil RunSQLScript: failed: 0x80040e2f
05-08-2013,21:11:57 : OS ERROR: 0x80040e2f (-2147217873)
05-08-2013,21:11:57 : Starting schedule upgrades.
05-08-2013,21:11:57 : Not doing schedule upgrades due to previous errors. rc=0x1
05-08-2013,21:11:57 : Done with schedule upgrades.
05-08-2013,21:11:57 : upgrade135x ends rc=1
05-08-2013,21:11:57 : Job Migration Failed

+ 05-08-2013,21:11:57 : Failure 1 running migration library 1

05-08-2013,21:11:57 : Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\pvlupgrade.dll
05-08-2013,21:11:57 : Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\jobmigration.dll
05-08-2013,21:11:57 : Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\catupgrade.dll
05-08-2013,21:11:57 : Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\postmigrationprocessing.dll

+ 05-08-2013,21:11:57 : BE Migration Tool execution failed


Environment



BE 2012 with SP1


Solution



Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned at the end of this article. Symantec Corporation is committed to product quality and satisfied customers.

This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release.  If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns.  For information on how to contact Symantec Sales, please see http://www.symantec.com

Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.


Supplemental Materials

SourceETrack
Value3213540
Description

CORE: Upgrade to BE 2012 fails with the error “Cannot insert duplicate key row in object 'dbo.Configuration' with unique index 'uidx_Configuration_Parameter'”



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


Terms of use for this information are found in Legal Notices