Server Management - Systems Insight Manager
1834168 Members
2213 Online
110064 Solutions
New Discussion

Re: HPSIM DataBase Rename

 
James D. Young
Frequent Advisor

HPSIM DataBase Rename

I have done this several times with previous versions of HPSIM but for some reason it is not working with 6.3. When i have to rebuild my HPSIM server and want to get it back to my origianl database i do the following

1. After fresh install is done, open application and make sure it logs in once.
2. Shut down the HPSIM Service
3. Open up the HPSim App Location directory and go inside the config folder.
4. Create a DSN set with the name I want
5. Modify the following inside the Database.admin file
-- hp.database.databaaseName= (DB Name)
6. Modify the following inside the Database.Props
-- hp.database.databaseName= (DB Name)
-- hp.database.dsn= (DSN Created in step 3)


I have done this many times and have had usually no problems.

This time it is connecting to both databases and if i rename the one created on fresh install i get jboss errors in mxdomainmgr0.log like
Cannot open database "Insight_v50_0_11208937". Which is the default one created on install.

Where is JAVA storing this information so that i can fix it? It is not using a DSN.
1 REPLY 1
James D. Young
Frequent Advisor

Re: HPSIM DataBase Rename

I found another file that it was in at jboss\server\hpsim\hpsim-ds.xml.

I made the change in that file and i was able to get into the database.