Re: Database migration and Connectivity to new database Server failed. (546 Views)
Reply
Advisor
ManojKarki
Posts: 15
Registered: ‎12-02-2013
Message 1 of 13 (578 Views)
Accepted Solution

Database migration and Connectivity to new database Server failed.

[ Edited ]

Hi All,

 

we have migrated BSM database from local drive(GW) to centralized Database, the migration is successful, but we are failed to connect the BSM application to the new Database server.

 

details:

BSM ------>9.23

database--> oracle 11g 64 bit

 

i had followed the Steps of KM00378713 for migration and connectivity of the application.

 

Suggest me for some workaround.

 

Thanks

Manoj Karki

 

 

P.S. This thread has been moved from Software>Events, News & Break Room>News to Application Perf Mgmt (BAC / BSM) Support and News Forum. -HP Forum Moderator

Regular Advisor
AshishGupta
Posts: 125
Registered: ‎12-06-2010
Message 2 of 13 (546 Views)

Re: Database migration and Connectivity to new database Server failed.

Manoj,

 

Are you able to connect to your database using Native client without any issues?

 

I guess still some entries are not cleared well, just check Port, SID , Database name , Hostname is correct in the Sessions table, if you have any old entry replace it  with the new one.

 

 

And what exact error you are getting in log , can you please paste that...

 

 

Regards,

Ashish

Advisor
ManojKarki
Posts: 15
Registered: ‎12-02-2013
Message 3 of 13 (536 Views)

Re: Database migration and Connectivity to new database Server failed.

Hello ashish,

 

Yes, we are able to connect to native client. we hace checked SESSIONS table of new database and all entry are fine.

 

the error is while we are running the configuration wizard on Gateway server it is showing the attached error, but configuration wizard on DPS server is working fine and Successful.

 

Thanks

Manoj Karki

HP Expert
PatWest
Posts: 832
Registered: ‎03-06-2008
Message 4 of 13 (519 Views)

Re: Database migration and Connectivity to new database Server failed.

Try to run this from the command line, does it return a value?

Example:

..:\HPBSM\bin>getservermem
16381
Advisor
ManojKarki
Posts: 15
Registered: ‎12-02-2013
Message 5 of 13 (506 Views)

Re: Database migration and Connectivity to new database Server failed.

hi ashish,

 

i have run it through cmd the output is 8180 and the time it takes is 2.27 min.

 

 

thanks

Manoj Karki.

HP Expert
PatWest
Posts: 832
Registered: ‎03-06-2008
Message 6 of 13 (502 Views)

Re: Database migration and Connectivity to new database Server failed.

What is your BSM deployment (single system or GW + DPS, or...)

 

Is It basic or advanced, do you use Omi?

Advisor
ManojKarki
Posts: 15
Registered: ‎12-02-2013
Message 7 of 13 (494 Views)

Re: Database migration and Connectivity to new database Server failed.

Hi Pat,

 

BSM deployment in not single server.

 

We have GW and DPS on different server.

 We have tried to integrate BSM with OM to use OMi, but fail to do so.

the OM agent we were using doesnt have some packages. we will fix that once database migration happens.

 

The error i can see in conf. wizard is time out error for getservermem.bat while configuring the database.

 

thanks

Manoj

 

HP Expert
PatWest
Posts: 832
Registered: ‎03-06-2008
Message 8 of 13 (491 Views)

Re: Database migration and Connectivity to new database Server failed.

Have a look at the memory-swapfile reqs fro BSM 9.23. You may need to add/change settings on your systems.

 

BSM-mem-swap-sysreqs.jpg

Advisor
ManojKarki
Posts: 15
Registered: ‎12-02-2013
Message 9 of 13 (480 Views)

Re: Database migration and Connectivity to new database Server failed.

Hi,

 

Where can i find this memory-swapfile.

 

 

Thanks,

Manoj Karki.

HP Expert
Siggi Gladitsch
Posts: 412
Registered: ‎03-11-2010
Message 10 of 13 (478 Views)

Re: Database migration and Connectivity to new database Server failed.

Manoij,

 

the swapspace BSM requires is an OS thing, and you either need to check your Linux or your Winows settings to find out the size. The table PatWest posted shows the minimum swapspace requirement to be configured on your system (OS-wise) depending on the BSM deployment type. The "bigger" BSM will be, the more swap space (or virtual memory or page file) the system requires.

While this might be one issue, I'm pretty sure that there is a bigger problem on that one server:

 

<HPBSM>\bin\getservermem.bat

is supposed to return the memory condifured on the server, it runs a VB script for this, and it is supposed to return the value in a matter of seconds (if it takes that long).

On my box it takes roungly 1 second, on your system it takes more than 2 minutes, causing the timeout.

 

The script <HPBSM>\bin\getservermem.bat does this (assuming that you are using Windows):

 

@ECHO OFF

SET PRODUCT_HOME_PATH=C:\HPBSM

set CSCRIPT_ENGINE=%SystemRoot%\System32\cscript.exe

%CSCRIPT_ENGINE% //nologo %PRODUCT_HOME_PATH%\bin\GetRAM.vbs

 

I guess your box needs to long to start the command executor vor VB.
You can try to change the script as follows (per your psot the result of running this script on your bix is 8180)

@ECHO OFF

rem SET PRODUCT_HOME_PATH=C:\HPBSM

rem set CSCRIPT_ENGINE=%SystemRoot%\System32\cscript.exe

rem %CSCRIPT_ENGINE% //nologo %PRODUCT_HOME_PATH%\bin\GetRAM.vbs

@echo 8180

 

Then the script will only output the value, without running any program.

This should work fast enough to avoid the timeout.

Greetings
Siggi

HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Advisor
ManojKarki
Posts: 15
Registered: ‎12-02-2013
Message 11 of 13 (466 Views)

Re: Database migration and Connectivity to new database Server failed.

Hi Siggi,

 

The workaroud you gave works great, my BSM application is running fine and services also started well.

Thanks for the suggestion.

 

1.How can i check that BSM got connected to new DB server..?

2. Do i have to Change the original script or leave it as it is.?

 

Thanks,

Manoj Karki.

HP Expert
Siggi Gladitsch
Posts: 412
Registered: ‎03-11-2010
Message 12 of 13 (462 Views)

Re: Database migration and Connectivity to new database Server failed.

Hi Manoj,

 

thanks for the good news!

 

> 1.How can i check that BSM got connected to new DB server..?

No idea what this question means, you can open a tool to access the DBMS, and check if BSM has sessions opened on a specific instance, for example

You can run <bsm>\tools\bsmbrowser and connect to the DB via File -> Topaz Connect

You then will get a list of databases you can connect to. Starting wioth BSM 9 it only shows the Management DB and all profile DBs, while it takes the profile DB information out of the SESSIONS table in the Mgmt DB.

So if you now what the new DB consists of, this would be a way to check it.

You also can run one of the myriads of BSM JMX methods showing the DB connections, for example

http://<bsm>:8080/jmx-console/HtmlAdaptor?action=invokeOpByName&name=Topaz%3Aservice%3DConnection+Po...

 

dbType=(SQL Server); hostName=swvm402.bgr.hp.com; dbName=VM402_BSM_PROFBPM; userName=sa; server=swvm402.bgr.hp.com; sid=; port=1433 ...
dbType=(SQL Server); hostName=swvm402.bgr.hp.com; dbName=VM402_BSM_RTSMHIST; userName=sa; server=swvm402.bgr.hp.com; sid=; port=1433 ...

 

2. Do i have to Change the original script or leave it as it is.?

Talking Support, you would need to change it back to the original script, as there is a certain purpose for BSM for executing the script.

You might want to open a case with support to find out why the script takes more than 2 minutes on your system

 

Greetings

Siggi

 

HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Advisor
ManojKarki
Posts: 15
Registered: ‎12-02-2013
Message 13 of 13 (445 Views)

Re: Database migration and Connectivity to new database Server failed.

Hi Siggi,

 

 In JMX ,i see the active connection showing 0 under connection pool information.

can you brief on this as well.

 

Manoj Karki,

 

 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.