Running BEMIG using "Upgrade version = 12.5.2213.0" in the registry, fails with "OS ERROR: 0x80040e37 (-2147217865)"

Problem

Running BEMIG using "Upgrade version = 12.5.2213.0" in the registry, fails with "OS ERROR: 0x80040e37 (-2147217865)"

Error Message

Status Message:
dbutil RunSQLScript: execute sql cmd failed. sql statement:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ReportF
ilterValue_ReportFilter]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
AL

Status Message: OS ERROR: 0x80040e37 (-2147217865)

Solution

Running the BEMIG using a previous version of Backup Exec for Windows database will fail with the following:
 

 
Status Message: dbutil RunSQLScript:Stop execution sql script
 
Status Message: dbutil RunSQLScript: failed: 0x80040e37
 
Status Message: OS ERROR: 0x80040e37 (-2147217865)
 

 
Reviewing the BEMIG output shows the following:
 

 
C:\Program Files\Symantec\Backup Exec>bemig
 
Executing migration of BEWS data.
 
SetRange: from=0 to=0
 
Status Message: DriverConnect:DRIVER=SQL Server;SERVER=titania\BkupExec;DATABASE
 
=BEDB;App=BEWS PVLUPGRADE
 
Status Message: Querying version data
 
Status Message: VersionName   = ADAMM 12.0,  VersionNumber = 12.0000000000
 
Status Message: AdammUpgradeView::Initialize() = 0
 
Status Message: JobMigration Internal Registry Key [Software\Symantec\Backup Exe
 
c For Windows\Backup Exec\Server\JobMigration Internal]=0
 
Status Message: DriverConnect:DRIVER=SQL Server;SERVER=backupserver\BkupExec;DATABASE
 
=BEDB;App=BEWS PVLUPGRADE
 
Status Message: VersionName   = ADAMM 12.0,  VersionNumber = 12.0000000000
 
Status Message: AdammUpgradeView::Initialize() = 0
 
Status Message: ADAMM upgrade started
 
Status Message: Querying version data
 
Status Message: VersionName   = ADAMM 12.0,  VersionNumber = 12.0000000000
 
Status Message: Backup Exec Device & Media Service Database, version 12.000000 w
 
as successfully upgraded.
 
Status Message: ADAMM upgrade ended
 
Status Message: UpgMachineName=BACKUPSERVER
 
Status Message: UpgVirtualName= UpgMachineName=BACKUPSERVER
 
Status Message: UpgSQLInstance=BACKUPSERVER\BkupExec
 
Status Message: From Registry UpgMajorVersion=12 UpgMinorVersion=5 UpgBuild=2213
 

 
Status Message: Before EstablishConnection m_sSQLInstance= sDatabase=
 
Status Message: After EstablishConnection m_sSQLInstance=BACKUPSERVER\BkupExec sDatab
 
ase=BEDB
 
Status Message: EstablishConnection()called within GetDBVersion()
 
Status Message: Version.BEServer.VerionNumber=12.000000
 
Status Message: GetBEServerVersions rc=0 EXEVersion=13.0.2896.108 DBVersion=13.0
 
.2740.0
 
Status Message: IsDBUptoDate rc=0 Database ExeVersion:12.0.1269.0 Database DBVer
 
sion:12.0.1269.0 Registry ExeVersion:13.0.2896.108 Registry DBVersion:13.0.2740.
 
0
 
Status Message: UpgDBVersion=12.0.1269.0
 
Status Message: origial build number 2213
 
Status Message: upgrade125 starts
 
Status Message: upgradeViaSQLScript m_JobMigInternal=0
 
Status Message: upgradeViaSQLScript2 using CDBOperation SQLInstance=(null) SQLSc
 
riptFile=DBUpgrade12.5-1.sql
 
Status Message:
 

 
dbutil RunSQLScript: DBUpgrade12.5-1.sql SQLServer:TITANIA SQLInstance:BkupExec
 
DatabaseName:BEDB
 

 
Status Message: OpenFromInitializationString Connection String = Provider=SQLOLE
 
DB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BEDB;D
 
ata Source=titania\BkupExec;Locale Identifier=1033;Application Name=BEWS DBUTIL
 
hr=0x0
 

 
Status Message: upgradeViaSQLScript m_JobMigInternal=0
 
Status Message: upgradeViaSQLScript2 using CDBOperation SQLInstance=(null) SQLSc
 
riptFile=DBUpgrade12.5-2.sql
 
Status Message:
 

 
dbutil RunSQLScript: DBUpgrade12.5-2.sql SQLServer:TITANIA SQLInstance:BkupExec
 
DatabaseName:BEDB
 

 
Status Message: OpenFromInitializationString Connection String = Provider=SQLOLE
 
DB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BEDB;D
 
ata Source=titania\BkupExec;Locale Identifier=1033;Application Name=BEWS DBUTIL
 
hr=0x0
 

 
Status Message:
 
       dbutil RunSQLScript: execute sql cmd failed.  sql statement:
 

 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ReportF
 
ilterValue_ReportFilter]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
 
ALTER TABLE [dbo].[ReportFiltersValue] DROP CONSTRAINT FK_ReportFilterValue_Repo
 
rtFilter
 

 
Status Message:
 
       dbutil RunSQLScript:Stop execution sql script
 
Status Message:
 
dbutil RunSQLScript: failed: 0x80040e37
 

 
Status Message: OS ERROR: 0x80040e37 (-2147217865)
 

 
Status Message: upgrade125 ends rc=1
 
Status Message: Job Migration Failed
 
Status Message: Job Migration Failed
 
Summary Entry: Type=UPGSUMERR
 
title=Job Migration
 
message=
 

 
Job Migration Failed
 
Upgrade state set to 805306369
 

 
As seen above BEMIG is finding "VersionName =ADAMM 12.0" and "Version.BEServer.VerionNumber=12.00000" in the database to be migrated, which is Backup Exec for Windows Servers v12.0.
 
However, "From Registry UpgMajorVersion=12 UpgMinorVersion=5 UpgBuild=2213" is indicating the "Upgrade Version" in the registry is set to version 12.5.2213.
 
This conflict is causing the BEMIG to fail with the above error.
 

 

 
RESOLUTION:
 

 

Follow the steps for setting and running BEMIG in the following document

http://www.symantec.com/docs/TECH50537 

 

 

 


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)