topic How do I install a SIM hotfix? in Server Management - Systems Insight Manager

How do I install a SIM hotfix?

Jim Miller_2 — Thu, 17 Nov 2005 11:35:14 GMT

I have SP31535 which has a CVA file and HOTFIX50_001 executable jar file, and would like to install/upgrade HP SIM 5.0 to SP2.
How do I install this file? When I try to run the JAR file it says it is corrupt.
Thanks in advance.
Jim

Re: How do I install a SIM hotfix?

David Claypool — Thu, 17 Nov 2005 12:06:28 GMT

From ftp://ftp.compaq.com/pub/softpaq/sp31501-32000/SP31535.txt :

1. Download the SoftPaq to a directory on your hard drive. The file downloaded is a self-extracting executable with a filename based on the SoftPaq Number above (SP31535.exe).

2. Execute the downloaded file (SP31535.exe) and follow the on-screen instructions.
Enter "Y" to confirm the unpacking of file: HOTFIX50_001.jar into this temporary directory.

3. Copy the HOTFIX50_001.jar from the above temporay directory into \patch directory, where is where HP SIM 5.0 is installed.

4. Restart HP System Insight Manager service

5. Empty the CIM_SoftwareIdentity table by executing the following SQL script command against the HP SIM 5.0 Database:

delete
from CIM_SoftwareIdentity

6. Re-run the Software Version Status Polling Task

Re: How do I install a SIM hotfix?

Leo Plewa — Fri, 18 Nov 2005 09:53:39 GMT

How can i do
"5. Empty the CIM_SoftwareIdentity table by executing the following SQL script command against the HP SIM 5.0 Database:
delete
from CIM_SoftwareIdentity"

I am not familar with MSDE and have not found anything within hpsim to execute these commands.
More details would be helpful.

Re: How do I install a SIM hotfix?

Don Reese_3 — Fri, 18 Nov 2005 14:53:52 GMT

If you have SQL Server, you can install Enterprise Manager and connect to the MSDE Database remotely to perform these commands, or you can lookup the command-line documentation for MSDE. There is some helpful info on this in a couple of recent (SEP-OCT) newsletters from Mark Minasi (http://www.minasi.com).
Otherwise, I would wait for the "upcoming SP3" release.

Re: How do I install a SIM hotfix?

Joel Rubenstein — Fri, 18 Nov 2005 16:19:02 GMT

You don't need to clear the database table unless you are experiencing the problem of missing entries when trying to create a collection that displays ILO FW versions. The other changes in the hotfix will become effective as soon as the hotfix is placed in the patch directory and the SIM service is restarted.

Re: How do I install a SIM hotfix?

David Claypool — Mon, 21 Nov 2005 10:55:25 GMT

For step 5 of the instructions:

For MSDE, locate the database name for the HP SIM database in %SystemDrive%\%ProgramFiles%\Microsoft SQL Server\MSSQL\Data. The format of the database will be Insight_v*.mdf where '*' represents version and unique date information.

Using OSQL (an executable that MSDE installs) issue the command:

osql -E -d Insight_vxxxxxxxxxxxxx -q "delete from CIM_SoftwareIdentity"

The system will respond with "(xxx lines affected)" and will leave you in the OSQL interpreter, designated by '1>' where you can
type quit [enter] to exit the mode.

Re: How do I install a SIM hotfix?

Mona Cheatham — Mon, 12 Dec 2005 11:51:20 GMT

HOW TO USE:

1. Download the SoftPaq to a directory on your hard drive. The file downloaded is a self-extracting executable with a filename based on the SoftPaq Number above (SP31535.exe).

2. Execute the downloaded file (SP31535.exe) and follow the on-screen instructions.
Enter "Y" to confirm the unpacking of file: HOTFIX50_001.jar into this temporary directory.

3. Copy the HOTFIX50_001.jar from the above temporary directory into \patch directory, where is where HP SIM 5.0 is installed.

4. Restart HP System Insight Manager Service.

5. Empty the CIM_SoftwareIdentity table by executing the following SQL script command against the HP SIM 5.0 Database:
delete from CIM_SoftwareIdentity

For MSDE, locate the database name for the HP SIM database in %SystemDrive%\%ProgramFiles%\Microsoft SQL Server\MSSQL\Data. The format of the database will be Insight_v*.mdf where '*' represents version and unique date information.

Using OSQL (an executable that MSDE installs) issue the command:

osql -E -d Insight_vxxxxxxxxxxxxx -q "Delete from CIM_SoftwareIdentity

the system will respond with "(xxx lines affected)" and will leave you in the OSQL interpreter, designated by '1>' where you can type quit [enter] to exit the mode.

6. Re-run the Software Version Status Polling Task