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

Article:TECH129132  |  Created: 2010-01-23  |  Updated: 2012-02-15  |  Article URL http://www.symantec.com/docs/TECH129132
Article Type
Technical Solution


Subject

Issue



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


Error



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 

 

 

 




Legacy ID



351357


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


Terms of use for this information are found in Legal Notices