cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade 10d to fresh install of 12.5 failed with invalid column name 'CommonFlags'

Robert_Cash
Level 3

I'm trying to upgrade from BE version 10d to version 12.5 with Bemig following the instructions here:

 

http://seer.entsupport.symantec.com/docs/287063.htm

 

The update fails with the following error: Invalid column name 'CommonFlags'

 

Here is the entire dump:

 

C:\Program Files\Symantec\Backup Exec>bemig
Executing migration of BEWS data.
SetRange: from=0 to=0
Status Message: DriverConnect:DRIVER=SQL Server;SERVER=myservername\BkupExec;DA
TABASE=BEDB;App=BEWS PVLUPGRADE
Status Message: Querying version data
Status Message: VersionName   = ADAMM,  VersionNumber = 10.0000010000
Status Message: AdammUpgradeView::Initialize() = 0
Status Message: DriverConnect:DRIVER=SQL Server;SERVER=myservername\BkupExec;DA
TABASE=BEDB;App=BEWS PVLUPGRADE
Status Message: VersionName   = ADAMM,  VersionNumber = 10.0000010000
Status Message: AdammUpgradeView::Initialize() = 0
Status Message: ADAMM upgrade started
Status Message: Querying version data
Status Message: VersionName   = ADAMM,  VersionNumber = 10.0000010000
Status Message: Backup Exec Device & Media Service Database, version 10.000001 w
as successfully upgraded.
Status Message: ADAMM upgrade ended
Status Message: UpgMachineName=myservername
Status Message: UpgVirtualName= UpgMachineName=myservername
Status Message: UpgSQLInstance=myservername\BkupExec
Status Message: UpgMajorVersion=10 UpgMinorVersion=1 UpgBuild=5582
Status Message: Before EstablishConnection m_sSQLInstance= sDatabase=
Status Message: After EstablishConnection m_sSQLInstance=myservername\BkupExec
sDatabase=BEDB
Status Message: Version.BEServer.VerionNumber=10.000001
Status Message: GetBEServerVersions rc=0 EXEVersion=12.5.2213.103 DBVersion=12.5
.2035.0
Status Message: IsDBUptoDate rc=0 Database ExeVersion:10.1.5582.0 Database DBVer
sion:10.1.5582.0 Registry ExeVersion:12.5.2213.103 Registry DBVersion:12.5.2035.
0
Status Message: UpgDBVersion=10.1.5582.0
Status Message: origial build number 5582
Status Message: Turn on xp_cmdshell
Status Message: upgrade10x start
Status Message: Initializing...

Status Message: BEGetComputerName = 'myservername'

Status Message: GetBeVirtualServerName = ''

Status Message: Using node name for media server

Status Message: runSQLScript SQLInstance=(null) VxDBMgr.GetMediaSQLInstanceName=
myservername\BkupExec, m_sSQLInstance=myservername\BkupExec
Status Message: Run SQl script locally: USE MASTER
EXEC xp_cmdshell '"C:\Program Files\Symantec\Backup Exec\RunSQLScript.cmd" myservername\BkupExec BEDB DBUpgrade10.0.sql'
Status Message: ExecSQL:: DBUtil.DoCommand
Status Message: Execute command: USE MASTER
EXEC xp_cmdshell '"C:\Program Files\Symantec\Backup Exec\RunSQLScript.cmd" myservername\BkupExec BEDB DBUpgrade10.0.sql'

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

Status Message: Changed database context to 'master'.

Status Message: Initializing...

Status Message: BEGetComputerName = 'myservername'

Status Message: GetBeVirtualServerName = ''

Status Message: Using node name for media server

Status Message: runSQLScript SQLInstance=(null) VxDBMgr.GetMediaSQLInstanceName=
myservername\BkupExec, m_sSQLInstance=myservername\BkupExec
Status Message: Run SQl script locally: USE MASTER
EXEC xp_cmdshell '"C:\Program Files\Symantec\Backup Exec\RunSQLScript.cmd" myservername\BkupExec BEDB DBUpgrade10.0-ViewAndSp.sql'
Status Message: ExecSQL:: DBUtil.DoCommand
Status Message: Execute command: USE MASTER
EXEC xp_cmdshell '"C:\Program Files\Symantec\Backup Exec\RunSQLScript.cmd" myservername\BkupExec BEDB DBUpgrade10.0-ViewAndSp.sql'

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

Status Message: Changed database context to 'master'.

Status Message: fixCRC4ScripDetail
Status Message: Before EstablishConnection m_sSQLInstance=myservername\BkupExec
 sDatabase=BEDB
Status Message: After EstablishConnection m_sSQLInstance=myservername\BkupExec
sDatabase=BEDB
Status Message: reset database connection ....
Status Message: Database Exception 0xcf, source:Microsoft OLE DB Provider for SQ
L Server, result:0x80040e14, Invalid column name 'CommonFlags'.

Status Message:
Status Message: Turn off xp_cmdshell
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 -268402206

 

 

Can someone tell me how to solve this?

 

Thanks

 

 

0 REPLIES 0