Manually Upgrade 4.2 Database to 5.0

[Tim McGue]

All,

I was hit by the problem mentioned in this group of trying to perform the uprade with a domain account with or without special characters in the password. (Hint: HP this needs to be fixed).

So now I am in a situation where I have a 4.2 database, but where when trying to install 5.0 it is only doing a new install, not an upgrade. So is there a way to manually upgrade the 4.2 database to 5.0?

Thanks,
Tim

[Aravindh Rajaram]

That is not possible. There is a lot of schema changes that went into the HPSIM 5.0 database and those changes are not fully known. As it stands now, there is no way to manually upgrade the 4.2 db to 5.0 :(

[Joel Rubenstein · Accepted solution]

Tim,

If your database was not converted you can rerun the install by modifying the following registry entry changing the "version string back to C.04.02.00

HKEY_LOCAL_MACHINE\SOFTWARE\Hewlett-Packard\Systems Insight Manager\Settings

[Tim McGue]

Thanks Joel. I tried just adding that registry value, and when I attempted the reinstall the inshell.exe was launched but never completed. This is the process I wound up taking:

1) Uninstalled 5.0.
2) Reinstalled 4.2.
3) Changed the ODBC for 4.2 to point to the orginal 4.2 database.
4) Deleted the 5.0 and new 4.2 databases.
5) Installed 5.0 using the local administrator account with no special characters in the password.
6) Changed the "run as" information for the HP SIM services to the domain account I wanted to use (and had used previously in 4.2).

Tim

[Aravindh Rajaram]

You'll have to edit the files "database.props", "database.admin" and "globalsettings.props" appropriately. These files do carry the database settings.