HPSIM DataBase Rename

James D. Young — Tue, 26 Apr 2011 19:12:57 GMT

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.

Re: HPSIM DataBase Rename

James D. Young — Tue, 26 Apr 2011 21:13:15 GMT

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.

topic Re: HPSIM DataBase Rename in Server Management - Systems Insight Manager

HPSIM DataBase Rename

Re: HPSIM DataBase Rename