Failed initializing the BMR database

[rizwan84tx]

Hi All,

I'm trying to enable BMR is our masterserver and it failed for one master, all other masters has no issues. Reading many post about this problem it appears that issue was resolved after reinstalling NBU, which i would not prefer.

Environment - NBU 7.1.0.2 on Windows 2008 R2 Enterprise (Master)

Error:

[Info] V-127-41 Setting up BMR Database ...
[Info] V-127-38 Initializing BMR database ...
[Error] V-127-52 Failed initializing the BMR database.
[Info] V-127-67 Failed to setup BMR master server.

bmrsetup log

$Header 65543,51216,127,1323325273,-19800,MASTERSERVER
0,51216,127,127,1,1323325273385,6360,6564,0:,17:Entering, line=62,26:setupMaster.cpp:SetupSig(),1
0,51216,127,127,2,1323325273385,6360,6564,0:,18:Entering, line=127,29:setupMaster.cpp:SetupServer(),1
2,51216,127,127,3,1323325273416,6360,6564,0:,0:,0:,0,(41|)
0,51216,128,127,1,1323325273510,6360,6564,0:,43:Failed to obtain a Connection String value.,26:DbInterface::DbInterface(),1
2,51216,127,127,4,1323325273525,6360,6564,0:,0:,0:,0,(38|)
0,51216,127,127,5,1323325273619,6360,6564,0:,169:Failed SQL, start database 'E:\Program Files\VERITAS\\NetBackupDB\data\BMRDB.db' as BMRDB autostop offMSG=[Sybase][ODBC Driver][SQL Anywhere]Specified database not found,25:CBmrSetupDb::startBmrDb(),1
0,51216,127,127,6,1323325273619,6360,6564,0:,114:Failed SQL, stop database BMRDB unconditionallyMSG=[Sybase][ODBC Driver][SQL Anywhere]Specified database not found,24:CBmrSetupDb::stopBmrDb(),1
0,51216,127,127,7,1323325273619,6360,6564,0:,169:Failed SQL, start database 'E:\Program Files\VERITAS\\NetBackupDB\data\BMRDB.db' as BMRDB autostop offMSG=[Sybase][ODBC Driver][SQL Anywhere]Specified database not found,25:CBmrSetupDb::startBmrDb(),1
0,51216,127,127,8,1323325273635,6360,6564,0:,221:Exiting, line=660, rc=3, Failed to connect to DRIVER=NB SQL Anywhere;CS=utf8;UID=dba;PWD=sql;LINKS=shmem,tcpip{PORT=13785};ENG=NB_MASTERSERVER;DBN=BMRDB. Msg=[Sybase][ODBC Driver][SQL Anywhere]Specified database not found,39:CBmrSetupDb::openInitialBmrConnection(),1
0,51216,127,127,9,1323325273635,6360,6564,0:,59:Exiting, line=564, rc=3, Failed getting initial m_OdbcView.,43:CBmrSetupDb.cpp:CBmrSetupDb::initializeDb(),1
2,51216,127,127,10,1323325273635,6360,6564,0:,0:,0:,2,(52|)

Also its weird that i dont get any DBs listed on running nbdb_admin -list.

X:\Program Files\Veritas\NetBackup\bin\admincmd>nbdb_admin -list

X:\Program Files\Veritas\NetBackup\bin\admincmd>nbdb_ping
Database [NBDB] is alive and well on server [NB_MASTERSERVER].

Has anyone encountered this issue, managed to resolve without reinstalling NBU.

Regards,

Rizwan.

[Zahid_Haseeb]

1.) Are all the NBU Master server related services running while you do the BMR Master Server setup using the wizard?

2.) Check if the binaries required for the database service are available on your master server.

(The main binary would be: dbsrv9.exe and should be present typically in c:\program files\veritas\netbackupdb\bin or c:\program files\veritas\netbackupdb\win32)

See the below post too which may help you.

https://www-secure.symantec.com/connect/forums/master-server-setup-failure

https://www-secure.symantec.com/connect/forums/can-i-installed-bmr-nbu7

[mandar_khanolka]

>> 0,51216,128,127,1,1323325273510,6360,6564,0:,43:Failed to obtain a Connection String

Basically it could not get a DB connection string to form BMR DB instance. Try restarting NB services. If possilbe machine too.

Thanks.

mandar

[rizwan84tx]

Hello Zahid,

It appears NBU 7.1 uses ASA version 11 and file dbsrv11.exe is present in X:\Program Files\Veritas\NetBackupDB\win64\

It did tried the solution before posting as per https://www-secure.symantec.com/connect/forums/master-server-setup-failure and no dice.

Am i  is missing anything else? or doing something wrong?

[rizwan84tx]

Hello Mandar,

I tried restarting the NBU service and also ended up rebooting the server. I did notice the "NetBackup Bare Metal Restore Master Server"
 services starts initially and then changed to stop state.

Do you have any more advices?

[Mark_Solutions]

As you are running Windows 2008 have you done any of the following:

1. Turned off firewall in case it blocks communication

2. Turned of UAC in case it prevents the setup master from running correctly

3. If not 2. above the either run the Master Setup from the start Menu after right clicking and "Run as Administrator" or open a command prompt using "Run as Administrator" and run bmrsetupmaster.exe.

Hope this helps

[Zahid_Haseeb]

CHeck the License. It msut be the issue of License

[rizwan84tx]

License cannot be problem in our case here, as we have unique license applied to all master servers, which is featured with BMR. Tried removing and re-applying the license did not fix too.

[rizwan84tx]

Hello Mark,

I tried your suggestion. Disabled the firewall and Administrator command prompt , still the same issue.

[mandar_khanolka]

If you have not run "bmrsetupmaster" CLI successfully on your master server OR GUI setup bmr master on windows; then bmr master server will not come up. Also further as bmr master is down, bmr boot service will go down.

thanks

mandar

[Mark_Solutions]

OK

Take a look at X:\Program Files\VERITAS\NetBackupDB\conf\databases.conf to see what is in it - paste it on here if you wish.

It should look like this:

"X:\Program Files\Veritas\\NetBackupDB\data\NBDB.db" -n NBDB
"X:\Program Files\Veritas\\NetBackupDB\data\BMRDB.db" -n BMRDB
"X:\Program Files\Veritas\\NetBackupDB\data\NBAZDB.db" -n NBAZDB

If it doesn't (possibly why the nbdb_admin -list doesnt work) then paste these in and try again.
 

[Zahid_Haseeb]

Where is EMM database ?

Are you using Media Server on another machine ?

[rizwan84tx]

database file has below entries

"X:\Program Files\Veritas\\NetBackupDB\data\NBDB.db" -n NBDB
"X:\Program Files\Veritas\\NetBackupDB\data\NBAZDB.db" -n NBAZDB

[rizwan84tx]

EMM is in masterserver

[Mark_Solutions]

Add the line:

"X:\Program Files\Veritas\\NetBackupDB\data\BMRDB.db" -n BMRDB
 to the databases.conf file and try it again

[rizwan84tx]

Yes, i understand that now. Any clue on why Netbackup is failing to initialise BMRDB and DBs not getting listed when i run nbdb_admin.

[Mark_Solutions]

It may not initialise as the line is missing from the databases.conf file

If you add in the line and do a service restart you may be able to then be able to run the masterserver setup

Not sure about the nbdb_admin - perhaps run it again after you have BMR configured and see if it logs anything to the admin log

[rizwan84tx]

Mark,

If tried that by refering this post https://www-secure.symantec.com/connect/forums/master-server-setup-failure.

After adding that entry for BMRDB and when i opened admin console i can see BMR management GUI; but the BMR service is stopped, and bmrsetupmaster throws same error.

[Mark_Solutions]

Are you saying that before adding the line you could not see the BMR section in the Admin Console?

If that is the case then do make sure you are actually using V7.1 license keys on your system and have not upgraded from an earlier version without putting the new licese keys in.

Have you tried opening NbDbAdmin.EXE (in the NetBackup\bin\ directory)

It has its own interface and the login password is nbusql

This will show you what databases you have and their state.

[rizwan84tx]

BMR GUI is present all the time. I apologise for that confusing term, i can see BMR management GUI without adding the line in database file.

NbDbAdmin : Yes, it shows me the Database and its state.