topic Re: Manually Upgrade 4.2 Database to 5.0 in Server Management - Systems Insight Manager

Manually Upgrade 4.2 Database to 5.0

Tim McGue — Fri, 23 Sep 2005 10:59:27 GMT

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

Re: Manually Upgrade 4.2 Database to 5.0

Aravindh Rajaram — Sun, 25 Sep 2005 23:51:04 GMT

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 :(

Re: Manually Upgrade 4.2 Database to 5.0

Joel Rubenstein — Mon, 26 Sep 2005 07:30:40 GMT

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

Re: Manually Upgrade 4.2 Database to 5.0

Tim McGue — Tue, 27 Sep 2005 09:05:07 GMT

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

Re: Manually Upgrade 4.2 Database to 5.0

Aravindh Rajaram — Tue, 27 Sep 2005 10:36:11 GMT

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