Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

since Database migration, nothing is saved

Guillaule
Frequent Advisor

since Database migration, nothing is saved

Hi

 

i've a very strange behavior

I've migrate Systems Insight Manager 7.4.0 database from a local 2008R2 database to a 2012 remote SQL database 

Everything was running fine, i follow the procedure 

http://h20565.www2.hp.com/hpsc/doc/public/display?docId=emr_na-c03225518

 

I've added new clients and other things but yesterday after server restart, all my new servers/settings have disappear as if it did not save my change , or somewhare an update is not working

(i v removed the local SQL server. If i stop the remote SQL server, HP SIM connexion is not working so the right database is used) 

if i do a netstat i can see established connexion on remote server and port

 

there something i did not understand .. :)

 

thanks for your help

regards

4 REPLIES
Guillaule
Frequent Advisor

Re: since Database migration, nothing is saved

i don't know HP SIM SQL tables  but if i select le  1000Top row in IM_ComputerSystem i can't see the new servers i've added ... 

Andrew_Haak
Honored Contributor

Re: since Database migration, nothing is saved

Hello did you do the step three ? Some people tend to skip this setting because it's located in an other folder.

Create a backup of the hpsim-ds.xml file located in the <installation directory>\HP\Systems Insight Manager\jboss\server\hpsim\deploy
directory. Do not place the backup file in this directory.
Kind regards,

Andrew
Guillaule
Frequent Advisor

Re: since Database migration, nothing is saved

Hi

 

yes, hpsim-ds.xml file have been modified and it"s the only file, no copy/no backup

 

FYI i did not find how to run the command

 

Automated re-registration of a database by executing the mxreconfig command

mxreconfig -m sqlredirect -s dbserver -b dbname -a dbuserDomain\dbuser -p dbport

 

>mxreconfig -m sqlredirect -s SRV\Instance -b I

nsight_v50_0_165528150 -a DOMAIN\USer -p 1434
This command will update Insight Management to use a new MS SQL database. Before
continuing, be sure you have performed the following steps:
1) Stop the Insight Management services with the command 'partnerservice
-stop all'
2) Be sure the new database is up and running, and that you have adminis
trative access to it.
Continue? (Y/N): Y
Enter the password for the database account "DOMAIN\USer":
Error from MxReconfig: Incorrect DB User ID or Password. Modifying DB credential
s in sqlRedirect mode is not supported. Please provide the current DB credential
s of the Product and try again.

 

regards

 

Guillaule
Frequent Advisor

Re: since Database migration, nothing is saved

if i launch mxgetdbinfo

 

everything is fine and point to the new DB