During upgrade to Backup Exec 2012 the Database Migration fails with error "Cannot insert the value NULL into column 'ShareBackupMethod', table"

Article:TECH200274  |  Created: 2012-11-29  |  Updated: 2013-12-10  |  Article URL http://www.symantec.com/docs/TECH200274
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


Issue



During a upgrade to Backup 2012 the Database Migration fails and the option is presented to continue or roll back. Backup Exec 2012 installation log (BKUPEXEC2012.HTM) shows the following error:


Error



  Cannot insert the value NULL into column 'ShareBackupMethod', table 'BEDB.dbo.BackupJobDefinition'; column does not allow nulls. INSERT fails.
 enter mig-convertAdhocJob2
 dbutil RunSQLScript: execute sql cmd failed. sql statement: exec dbo.[mig-convertAdhocJobs2]
 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\pvlupgrade.dll
 Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\jobmigration.dll
 Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\catupgrade.dll
 Destructor BEMigrate Freeing library: C:\Program Files\Symantec\Backup Exec\postmigrationprocessing.dll
+  BE Migration Tool execution failed

 


Environment



Backup Exec 2012

Upgrade or Migration

 


Solution



A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.

Backup Exec 2012 Rev 1798 Service Pack 2 (TECH203155)
 

Please select the option to Roll back the Installation to previous version, and then retry the upgrade using the Backup Exec 2012 SP2 or later embedded installation media to resolve the issue.  The latest media can be downloaded via http://fileconnect.symantec.com.


Supplemental Materials

SourceETrack
Value3011636
Description

Migration Failure from Nicobar to Honshu. Cannot insert the value NULL into column 'ShareBackupMethod', table 'BEDB.dbo.BackupJobDefinition'; column does not allow nulls. INSERT fails.




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


Terms of use for this information are found in Legal Notices