How do I install a SIM hotfix?

[Jim Miller_2]

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

[David Claypool]

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

[Leo Plewa]

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.

[Don Reese_3]

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.

[Joel Rubenstein]

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.

[David Claypool]

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.

[Mona Cheatham]

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