problem upgrading from 5.0sp4 to 5.1

[SEBEMISMNUSA]

Summary: Be very careful if you upgrade an existing HP SIM 5.0 sp # x system to HP SIM 5.1.

My recommendation (if you have this luxury)
Create a complete separate HP SIM system (yes, another Proliant computer). Install HP SIM 5.1 on it; migrate your data from the HP SIM 5.0 system to the HP SIM 5.1

Or you may have my experience of struggling to get to a HP SIM 5.1 monitoring system back online. I thought, as most, this would take several hours.

I am doing what I can to get the mxinitconfig -a to work. Hopefully others will benefit from my postings. I have spend hours in the struggle.

Second mx fix attempt
1/21/07 2:30 PM - 1/22/07 10:45 AM still running, the dot generator
HP Systems Insight Manager Initialization Starts at: Sunday, January 21, 2007 2:30:33 PM CST
- Start initialization ..Done
11. Agent Configuration
..Done
12. Management Services
..Done
13. Initialization and Database Population

HP Systems Insight Manager Initialization Starts at: Sunday, January 21, 2007 2:30:33 PM CST
- Start initialization


First mx fix attempt
Friday, January 19 6:30 PM
died or stopped at about Sunday, January 21 at about 1:00 PM
Computer has malfunctions (ex. notepad would not work, networks shares stopped working, ex. C$)

========== Begin Initial Configuration Record ==========
-------------- Operation = Configure
-------------- Upgrade From Version = C.05.00.02.00
-------------- To Version = C.05.01.00.00
-------------- Date = Friday, January 19, 2007 6:29:27 PM CST
-------------- User =
-------------- Host =
-------------- Locale = English (United States)
-------------- Operating System = Windows 2003
-------------- Database Type = MSSQL

End

[CA1499584]

I have done that too, I installed from scrach and the results are .... after finishing with no errors, I can't get to any page after login in, (Page not found) No working at all for me, going back to 5.0 , HP when we can have this solve ?

[NJK-Work]

I guess I am one of the lucky ones...sorry to hear about all the problems people are having.

The one piece of advice I can give, and its a bit pricey, is to image up the SIM server prior to the upgrade. I use Acronis TrueImage Server. I create an image of the server prior to the upgrade, which took about 1 hour because of the size, and then run the upgrade. If it blows up - restore the image. I actually had to do this for one of the pevious SPs - I think it was SP4. The upgrade blew up and I had to restore my image. I was back and running in about 1 hour.

But I understand not everyone has the luxury of throwing $700.00 at a server. There may be cheaper imaging products out there.

Nelson

[SEBEMISMNUSA]

I gave up with the struggling.
I removed HP SIM 5.1. I re-installed HP SIM 5.0 sp # 5. It is operational again. The database was not destroyed in my upgrade attempt. With some database work, sp_detach and sp_attach commands, I was able to connect the HP SIM database back.

This is where I am at now.
Central management server:
Hostname:
Operating system: Windows 2003
Version: Systems Insight Manager 5.0 with SP5 - Windows
Build version: C.05.00.02.00
Build date: 2006-05-23 11:07
Hotfixes:
User name:

I only wished HP never put this update at their web site.

End

[SEBEMISMNUSA]

An example (from the HPSIM.log) of an update failure from the HP SIM 5.0 SP # 5 to HP SIM 5.1
Attached are screen shots of what you might see if you attempt this.

[Mon Jan 22 18:34:03 CST 2007]Install Shell:Load: res://E:\Data\SOFTWARE\hpsim\hpsim51\SIM51-win\hpsim\win_ia32\setup.exe/content\custom-status.htm
[Mon Jan 22 18:34:03 CST 2007]Install Shell:window_onload()
[Mon Jan 22 18:34:03 CST 2007]Install Shell:InstallComponent()
[Mon Jan 22 18:34:03 CST 2007]Install Shell:RunComponentInstall(fnInstall[function] nIndex[3])
[Mon Jan 22 18:34:03 CST 2007]Install Shell:launchAndMonitor dwRet == 0
[Mon Jan 22 18:34:03 CST 2007]Install Shell:component install Initial Start return code == 0
[Mon Jan 22 18:34:03 CST 2007]Install Shell:window_onload()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:ValidPrerequisites()
[01-22-2007][18:34:10][HP Systems Insight Manager]Startup.
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:ValidTCPIP()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:ValidSNMP()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:ValidScreenRes()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:IsIM7Installed()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:IsTopToolsInstalled()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:ValidMDAC()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:InitializeSetup - valid pre-reqs
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:gsFullDNS = COMPUTER-NAME
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:GetInstallType()
[01-22-2007][18:34:10][HP Systems Insight Manager]install upgrade
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:GetDBHost()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:InitializeWizard()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:CreateEdit()
[01-22-2007][18:34:10][HP Systems Insight Manager]DEBUG:LoadSQLValues()
[01-22-2007][18:34:37][HP Systems Insight Manager]DEBUG:NextButtonClick(1)
[01-22-2007][18:34:37][HP Systems Insight Manager]DEBUG:welcome page
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(100)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(101)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(6)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(8)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:UpdateReadyMemo()
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(10)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(8)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(6)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(101)
[01-22-2007][18:34:40][HP Systems Insight Manager]DEBUG:ShouldSkipPage(100)
[01-22-2007][18:35:24][HP Systems Insight Manager]DEBUG:NextButtonClick(10)
[01-22-2007][18:35:24][HP Systems Insight Manager]DEBUG:CurStepChanged()
[01-22-2007][18:40:15][HP Systems Insight Manager]DEBUG:CurStepChanged()
[01-22-2007][18:40:15][HP Systems Insight Manager]DEBUG:CreateInitForm()
[01-22-2007][18:40:18][HP Systems Insight Manager]DEBUG:InitFrmOnShow
[01-22-2007][18:40:18][HP Systems Insight Manager]DEBUG:InitFrmBtnNotifyOnClick()
[01-22-2007][18:40:18][HP Systems Insight Manager]HP Systems Insight Manager installation completed.
[01-22-2007][18:40:18][HP Systems Insight Manager]DEBUG:fixFiles
[01-22-2007][18:40:19][HP Systems Insight Manager]DEBUG:SetDefaultUsers()
[01-22-2007][18:40:19][HP Systems Insight Manager]DEBUG:ReplaceValue()
[01-22-2007][18:40:19][HP Systems Insight Manager]DEBUG:ReplaceValue()
[01-22-2007][18:40:19][HP Systems Insight Manager]DEBUG:ReplaceValue()
[01-22-2007][18:40:19][HP Systems Insight Manager]DEBUG:SetOpenSSHUsers()
[01-22-2007][18:40:19][HP Systems Insight Manager]DEBUG:UpdateDatabaseTemplates()
[01-22-2007][18:40:19][HP Systems Insight Manager]DEBUG:ReplaceValue()
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Database initialization failed for URL: jdbc:jtds:sqlserver://COMPUTER-NAME:1433/Insight_v50_0_173855153;domain=AD-domain;instance=HPSIM1;prepareSQL=3 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
HP Systems Insight Manager shutting down: com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database
Password Key "MxDBUserPassword" added


Please close this command window immediately to prevent any clear text passwords from being exposed to unintended eyes.
[01-22-2007][18:40:39][HP Systems Insight Manager]update HPSIM service
[01-22-2007][18:40:39][HP Systems Insight Manager]DEBUG:SetSNMPAccept()
[01-22-2007][18:40:39][HP Systems Insight Manager]DEBUG:AddSNMPHost()
[01-22-2007][18:40:39][HP Systems Insight Manager]DEBUG:AddSNMPHost()
[01-22-2007][18:40:39][HP Systems Insight Manager]DEBUG:mxinitconfig -a -F, C:\PROGRA~1\HP\SYSTEM~1, C:\hpsim.log, ,$, CMD_WAIT + CMD_CAPTURE, 590402

Configuring Server Components (13):
1. Server Property File ..Done
2. Server Authentication Keys ..Done
3. SSH Keys ..Done
4. Status Property File ..Done
5. Task Results Output Cleanup ..Done
6. Database Configuration ..Failed
Completed with error.

Details can be found in the log files at: C:\Program Files\HP\Systems Insight Manager\logs
Configuration failed to complete due to the following exception:
Connection to the repository server failed.
[01-22-2007][18:40:55][HP Systems Insight Manager]DEBUG:InitFrmBtnNotifyOnClick()
[01-22-2007][18:40:55][HP Systems Insight Manager]DEBUG:nProgress = 123
[01-22-2007][18:41:26][HP Systems Insight Manager]Error:Database initialization failed. Setup cannot continue.

Error:
1) Connection to the repository server failed.


Please refer to the initconfig.log file in the
"C:\PROGRA~1\HP\SYSTEM~1\config"
directory for more information.
[01-22-2007][18:41:30][HP Systems Insight Manager]DEBUG:ShouldSkipPage(14)
[01-22-2007][18:41:52][HP Systems Insight Manager]DEBUG:NextButtonClick(14)
[01-22-2007][18:41:52][HP Systems Insight Manager]DEBUG:CurStepChanged()
[01-22-2007][18:41:52][HP Systems Insight Manager]DEBUG:DeInitializeSetup()
[01-22-2007][18:41:52][HP Systems Insight Manager]Shutdown.
[Mon Jan 22 18:41:52 CST 2007]Install Shell:InstallComplete()
[Mon Jan 22 18:41:52 CST 2007]Install Shell:process exit code = 0
[Mon Jan 22 18:41:52 CST 2007]Install Shell:sStatus = Setup failed. Please refer to the C:\hpsim.log and C:\Program Files\HP\Systems Insight Manager\logs\initconfig.logfiles for details.
[Mon Jan 22 18:41:52 CST 2007]Install Shell:nStatus = 4
[01-22-2007][18:41:52][Install Shell]HP Systems Insight Manager
[01-22-2007][18:41:52][Install Shell]return code: 4
[01-22-2007][18:41:52][Install Shell]return msg: Setup failed. Please refer to the C:\hpsim.log and C:\Program Files\HP\Systems Insight Manager\logs\initconfig.logfiles for details.
[Mon Jan 22 18:41:52 CST 2007]Install Shell:InstallComplete(sStatus[Setup failed. Please refer to the C:\hpsim.log and C:\Program Files\HP\Systems Insight Manager\logs\initconfig.logfiles for details.] nStatus[4])
[Mon Jan 22 18:41:52 CST 2007]Install Shell:installComplete: sStatus = Setup failed. Please refer to the C:\hpsim.log and C:\Program Files\HP\Systems Insight Manager\logs\initconfig.logfiles for details. nStatus = 4
[Mon Jan 22 18:41:52 CST 2007]Install Shell:updateComponentStatus(sStatus[Setup failed. Please refer to the C:\hpsim.log and C:\Program Files\HP\Systems Insight Manager\logs\initconfig.logfiles for details.])
[Mon Jan 22 18:41:52 CST 2007]Install Shell:checkIfFailedInstallIsHPSIM()
[01-22-2007][18:41:55][Install Shell]HP Systems Insight Manager failed to install successfully. Setup cannot continue. Click "OK" to exit the installation.
[Mon Jan 22 18:41:55 CST 2007]Install Shell:HtmlFrame_QueryExit()
[Mon Jan 22 18:41:55 CST 2007]Install Shell:Cleanup()
[01-22-2007][18:41:55][Install Shell]Shutdown
[Mon Jan 22 18:41:55 CST 2007]Install Shell:window_onunload()

[James Kennedy_5]

I had the same issue during my upgrade and its toast. I can't seem to get anywhere, so i'm rebuilding the server from scratch.

Anyone know if there's a way to use the old SIM 5.0 SP5 database when installing SIM 5.1 brand new on a fresh server?

[CA1499584]

I don't beleive you can do or use old 5.0 #5 DB with 5.1 since the new one have new views and tables to it. You have to do like we did go back to 5.0#5 and wait for HP to fix the upgrade to 5.1,

[SEBEMISMNUSA]

Yes, I agree. The update to HP SIM 5.1 from 5.0 sp # 5, at least with Microsoft Windows 2003 using Microsoft SQL server 2000
*DOES NOT WORK*.

Details for HP or your review.
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\>mxgetdbinfo
host=
port=1433
dbname=Insight_v50_0_173855153
user= dbtype=SQLServer

C:\>

C:\>mxinitconfig -l
Listing current status of server components (13):
1. Server Property File ..OK
Status : Configured
2. Server Authentication Keys ..OK
Status : Configured
3. SSH Keys ..OK
Status : Configured
4. Status Property File ..OK
Status : Configured
5. Task Results Output Cleanup ..OK
Status : Configured
6. Database Configuration ..OK
23 Jan 2007 09:53:04,783 INFO [HPSIM_DEBUG]
Database Version:
23 Jan 2007 09:53:04,798 INFO [HPSIM_DEBUG]
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

23 Jan 2007 09:53:04,955 INFO [HPSIM_DEBUG]
Database Driver:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.0.2

Status : Configured
7. Database Content ..OK
Status : Configured
8. Web Server ..OK
Status : Configured
9. Setup Property File ..OK
Status : Configured
10. JBoss Setup ..OK
Status : Unconfigured
11. Agent Configuration ..OK
Status : Unconfigured
12. Management Services ..OK
Status : Configured
13. Initialization and Database Population ..OK
Status : Unconfigured
Completed all tasks successfully.

Details can be found in the log files at: C:\Program Files\HP\Systems Insight Manager\logs

C:\>
C:\>mxconfigrepo -f
Performing repository corruption fix.
23 Jan 2007 09:55:51,501 INFO [HPSIM_DEBUG]
Database Version:
23 Jan 2007 09:55:51,517 INFO [HPSIM_DEBUG]
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
23 Jan 2007 09:55:51,517 INFO [HPSIM_DEBUG]
Database Driver:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.0.2
23 Jan 2007 09:55:51,595 INFO [HPSIM_DEBUG] Checking for possible database corruption...
23 Jan 2007 09:55:52,814 INFO [HPSIM_DEBUG] Completed database checking with no errors.
Completed repository corruption fix.

C:\>

C:\>mxconfigrepo -f
Performing repository corruption fix.
23 Jan 2007 09:55:51,501 INFO [HPSIM_DEBUG] Database Version:
23 Jan 2007 09:55:51,517 INFO [HPSIM_DEBUG] Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
23 Jan 2007 09:55:51,517 INFO [HPSIM_DEBUG]
Database Driver:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.0.2
23 Jan 2007 09:55:51,595 INFO [HPSIM_DEBUG] Checking for possible database corruption...
23 Jan 2007 09:55:52,814 INFO [HPSIM_DEBUG] Completed database checking with no errors. Completed repository corruption fix.

C:\>mxinitconfig -a
Checking Requisites (13):
1. Server Property File ..OK
2. Server Authentication Keys ..OK
3. SSH Keys ..OK
4. Status Property File ..OK
5. Task Results Output Cleanup ..OK
6. Database Configuration ..OK
7. Database Content ..OK
8. Web Server ..OK
9. Setup Property File ..OK
10. JBoss Setup ..OK
11. Agent Configuration ..OK
12. Management Services ..OK
13. Initialization and Database Population ..OK
Requisite scan completed successfully.
Configuring Server Components (13):
1. Server Property File ..Done
2. Server Authentication Keys ..Done
3. SSH Keys ..Done
4. Status Property File ..Done
5. Task Results Output Cleanup ..Done
6. Database Configuration ..23 Jan 2007 09:58:22,033 INFO [HPSIM_DEBUG]
Database Version:
23 Jan 2007 09:58:22,064 INFO [HPSIM_DEBUG]
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
23 Jan 2007 09:58:22,205 INFO [HPSIM_DEBUG]
Database Driver:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.0.2
23 Jan 2007 09:58:22,376 INFO [HPSIM_DEBUG]
Database Version:
23 Jan 2007 09:58:22,439 INFO [HPSIM_DEBUG]
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
23 Jan 2007 09:58:22,580 INFO [HPSIM_DEBUG]
Database Driver:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.0.2
Done
7. Database Content ..Done
8. Web Server ..Done
9. Setup Property File ..Done
10. JBoss Setup ..Done
11. Agent Configuration ..Done
12. Management Services ..Done
13. Initialization and Database Population ...
This step never ends.

The End

[Randy ...]

Just wanted to confirm that Ole Thompson's steps at the beginning of the thread resolved our issue. We have upgraded with our database from 5.0 sp5 to 5.1. Sure hope HP fixes this soon for everyone else. It was a real disappointment for us.

[CA1499584]

After various atemp, I install from scratch SIM5.0 SP5 and manually reconfigure it back, Then I try one more time and follow Ole Thomsen instruccions and that work for me...