hp sim 7.3 not working

[christian_derek]

Hi,

I completed the upgrade of HP SIM 7.3 and since then I am not able to access the sim interface via port 50000,  the listener is present, but nothing happen.

how can I debug this?

Thanks,

[Andrew_Haak]

Hello Christian,

Please have a look in the System Insight Manager under the folder logs and find the mxdomainmgr.log file to see if there are errors, most of the time problems are database related. You can also log for the mxdomainmgr exe file in the task manager. If the process keeps growing and then restarts you might have a database problem. But as i said you'll see that in the logfile. Look at the top part, the first 2 pages should give enough info. If needed you can post that part of the log if you need more hints.

Kind regards,

Andrew

[Jon_151]

What OS are you running? 

[christian_derek]

Hi Andrew,

I really don't know what to look for, I have attached the log file.  The mxdomainmgr is using 30% of the cpu and 1.3gb of ram, look excessif.

Thanks,

[christian_derek]

Hi,

Running Windows Server 2008 R2 Standard Service Pack 1 64-bit.

Thanks,

[Andrew_Haak]

Hello Christian,

The SQL connection works but perhaps it's corrupt, not that i can see a DBa error. You could run the following command on the SIm server : MXCONFIGREPO -c

This checks the database consistency. If you see errors you can use the fix command :

To correct HP SIM database corruption, perform the following steps:

1. Stop the HP SIM service.
2. Run the Central Management Server (CMS) command MXCONFIGREPO -f.
3. Restart the HP SIM service.

Was this a clean install or an upgrade over a 7.2 or earlier version ?

Kind regards,

Andrew

[christian_derek]

Hi,

This is an upgraded version from 7.2, there is corruption at the db level, here is the output ...

Thanks,

C:\Users\hpsim>mxconfigrepo -c
Performing repository corruption checking.
31 Jan 2014 08:32:16,275 INFO [HPSIM_DEBUG] Maximum retry delay to database server : 5000
31 Jan 2014 08:32:16,282 INFO [HPSIM_DEBUG] Trying connection to database using property file: database.props
31 Jan 2014 08:32:16,289 INFO [HPSIM_DEBUG] Trying connection to database retry = 0
31 Jan 2014 08:32:16,496 INFO [HPSIM_DEBUG] Database connection test successful
              for URL: jdbc:jtds:sqlserver://ICE-      

              CNX:1433/Insight_v50_0_121354207;loginTimeout=20;domain=SOFTVOYAGE;instance=

31 Jan 2014 08:32:16,504 INFO [HPSIM_DEBUG] Database Machine:ICE-CNX
31 Jan 2014 08:32:16,508 INFO [HPSIM_DEBUG] Database Version:
31 Jan 2014 08:32:16,510 INFO [HPSIM_DEBUG]
            Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (Intel X86)
            Jun 28 2012 08:42:37
            Copyright (c) Microsoft Corporation
            Express Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WO
            W64) (Hypervisor)

31 Jan 2014 08:32:16,521 INFO [HPSIM_DEBUG]
            Database Product Name:
            Microsoft SQL Server Product Version 10.50.4000

31 Jan 2014 08:32:16,523 INFO [HPSIM_DEBUG]
             Database Driver:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.2

31 Jan 2014 08:32:16,681 INFO [HPSIM_DEBUG] Checking for possible database corruption...
31 Jan 2014 08:32:16,711 INFO [HPSIM_DEBUG] Number of records in table 'devices': 91
31 Jan 2014 08:32:16,726 INFO [HPSIM_DEBUG] Number of records in table 'notices': 2887
31 Jan 2014 08:32:16,728 INFO [HPSIM_DEBUG] Number of records in table 'tasks': 66
31 Jan 2014 08:32:16,733 INFO [HPSIM_DEBUG] Number of records in table 'hpmxJob': 114
31 Jan 2014 08:32:16,760 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAutomationTaskResults': 33654
31 Jan 2014 08:32:16,762 INFO [HPSIM_DEBUG] Number of records in table 'hpmxQuery': 145
31 Jan 2014 08:32:16,765 INFO [HPSIM_DEBUG] Number of records in table 'collections': 72
31 Jan 2014 08:32:16,768 INFO [HPSIM_DEBUG] Number of records in table 'hpmxUser': 9
31 Jan 2014 08:32:16,770 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAuthorization': 43
31 Jan 2014 08:32:16,776 INFO [HPSIM_DEBUG] Number of records in table 'consolidatedNodeAuths': 910
31 Jan 2014 08:32:17,838 INFO [HPSIM_DEBUG] Completed database checking with noerrors.
Completed repository corruption checking.

C:\Users\hpsim>

[christian_derek]

Sorry Andrew, there is no corruption at the database level, see the previous post for the output.

thanks,

[Andrew_Haak]

Hello Christian,

Like i typed i don't see an error in the log but it can't hurt to run it any way. If that does not work you can reinstall Sim with a new database and then change the config files to point to the old database. If you search for the new database name and replace the name with the old one that should work. If your SIM server is a virtual i would first make a snapshot or if it's physical break the mirror that way you have a back-up in case things break. But then that is already the case.

Kind regards,

Andrew

[christian_derek]

Hi Andrew,

I'm trying to redo the update again.  I tried running before insight management advisor and is telling me that the port are busy, see below, but all the ports are used by mxdomain, see right after.

Thanks,

[Fri Jan 31 13:00:06][INFO ] Plugin filename  : c:\program files\hp\insight management\im advisor\plugins\simcheck.dll

[Fri Jan 31 13:00:06][INFO ] VersionInfo filename  : c:\program files\hp\insight management\im advisor\plugins\version-info.xml

[Fri Jan 31 13:00:06][INFO ] Plugin timestamp : Nov 20 2013 - 16:17:06

[Fri Jan 31 13:00:06][INFO ] Plugin version   : 7.3.0

[Fri Jan 31 13:00:06][INFO ] Plugin execution start...

[Fri Jan 31 13:00:06][INFO ] Base registry key: Software\Hewlett-Packard\Systems Insight Manager\Settings

[Fri Jan 31 13:00:06][INFO ] Registry read successful: InstallStatus

[Fri Jan 31 13:00:06][INFO ] InstallSuccess registry value is not 1

[Fri Jan 31 13:00:06][INFO ] Testing for ports conflicts...

[Fri Jan 31 13:00:06][INFO ] Loading test for port 22

[Fri Jan 31 13:00:06][INFO ] Loading test for port 280

[Fri Jan 31 13:00:06][INFO ] Loading test for port 50000

[Fri Jan 31 13:00:06][INFO ] Loading test for port 50001

[Fri Jan 31 13:00:06][INFO ] Loading test for port 50002

[Fri Jan 31 13:00:06][INFO ] Loading test for port 50003

[Fri Jan 31 13:00:06][INFO ] Loading test for port 50004

[Fri Jan 31 13:00:06][ERROR] Port 22 is in use

[Fri Jan 31 13:00:06][ERROR] Port 280 is in use

[Fri Jan 31 13:00:06][ERROR] Port 50000 is in use

[Fri Jan 31 13:00:06][ERROR] Port 50001 is in use

[Fri Jan 31 13:00:06][ERROR] Port 50002 is in use

[Fri Jan 31 13:00:06][ERROR] Port 50004 is in use

[Fri Jan 31 13:00:06][INFO ] Sim installpath : C:\Program Files\HP\Systems Insight Manager

[Fri Jan 31 13:00:06][INFO ] Database type: mssql

[Fri Jan 31 13:00:06][INFO ] Database name: insight_v50_0_121354207

[Fri Jan 31 13:00:06][INFO ] Database instance name: ice-cnx\\

[Fri Jan 31 13:00:06][INFO ] Hostname: ice-cnx

[Fri Jan 31 13:00:06][INFO ] Plugin execution end

[Fri Jan 31 13:00:06][INFO ] Test Suite Results...

[Fri Jan 31 13:00:06][INFO ]            Result code: 2

[Fri Jan 31 13:00:06][INFO ]         Result subcode: 0

[Fri Jan 31 13:00:06][INFO ]     Result description: HP Systems Insight Manager installation key indicates HP Systems Insight Manager not successfully installed

[Fri Jan 31 13:00:06][INFO ] ===========================================================================

[Fri Jan 31 13:00:06][INFO ] Test Results Summary

[Fri Jan 31 13:00:06][INFO ] Test Description -- Supported HP Systems Insight Manager Version

[Fri Jan 31 13:00:06][INFO ] Result Code -- 2

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- HP Systems Insight Manager installation key indicates HP Systems Insight Manager not successfully installed

[Fri Jan 31 13:00:06][INFO ] Test Description -- HP Systems Insight Manager TCP Port Conflicts

[Fri Jan 31 13:00:06][INFO ] Result Code -- 2

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- One or more TCP ports required by HP Systems Insight Manager are in use

[Fri Jan 31 13:00:06][INFO ] Test Description -- HP Systems Insight Manager Service

[Fri Jan 31 13:00:06][INFO ] Result Code -- 1004

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- Not Tested

[Fri Jan 31 13:00:06][INFO ] Test Description -- HP Systems Insight Manager SOAP Logon

[Fri Jan 31 13:00:06][INFO ] Result Code -- 1004

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- Not Tested

[Fri Jan 31 13:00:06][INFO ] Test Description -- HP Systems Insight Manager Proxy Configuration

[Fri Jan 31 13:00:06][INFO ] Result Code -- 1004

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- Not Tested

[Fri Jan 31 13:00:06][INFO ] Test Description -- HP Systems Insight Manager Database Connection

[Fri Jan 31 13:00:06][INFO ] Result Code -- 1004

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- Not Tested

[Fri Jan 31 13:00:06][INFO ] Test Description -- HP Systems Insight Manager Database Server Version

[Fri Jan 31 13:00:06][INFO ] Result Code -- 1004

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- Not Tested

[Fri Jan 31 13:00:06][INFO ] Test Description -- HP Systems Insight Manager Database Properties

[Fri Jan 31 13:00:06][INFO ] Result Code -- 0

[Fri Jan 31 13:00:06][INFO ] Result Subcode -- 0

[Fri Jan 31 13:00:06][INFO ] Result Description -- No problems found

[Fri Jan 31 13:00:06][INFO ] ===========================================================================

TCP    [::]:280               ICE-CNX:0              LISTENING       14264

[mxdomainmgr.exe]

TCP    [::]:50000             ICE-CNX:0              LISTENING       14264

[mxdomainmgr.exe]

  TCP    [::]:50001             ICE-CNX:0              LISTENING       14264

[mxdomainmgr.exe]

  TCP    [::]:50002             ICE-CNX:0              LISTENING       14264

[mxdomainmgr.exe]

  TCP    [::]:50004             ICE-CNX:0              LISTENING       14264

[mxdomainmgr.exe]

[Andrew_Haak]

Hello Christian,

You first have to uninstall the Hp System Insight Manager, the rest can be left on the server. When you reinstall the software, the setup will create a new database, this database is not needed when you edited your config files to point to your old database. Only problem could be that you have to recreatie your trusts. If you need the namens of the files you need to edit just reply to this post, but that info can easily found in this forum....
Did you look if the domainmgr.exe grows and then stays at a certain memorystick usage ? As a last resort did you try Firefox to try and connect the the https://simserver:50000

Good luck !

Kind regards,

Andrew

[christian_derek]

Hi Andrew,

The domainmgr just keep growing, I see a lot of attemp trying to connect to port 280. I tried with Chromo with no luck.

Thanks,

[Andrew_Haak]

You typed https right ?

Just beeing a bit pararoid....

[christian_derek]

yes I used https://localhost:50000

[Andrew_Haak]

Hello again,

Strange, i'dd think SIM is still running, but you just can't access it. I bet the mx log shows sheduled jobs are still running. If you tried with more than one browser and you still can't connect to the Sim webinterface i would make an export for the objects in Sim and start over. Just one more question, how big is your database?

If you use mxnode -ln > c:\nodes.txt you can backup the node in SIM. If that works you have proven that the database is still accessable.

Kind regards,

Andrew

[shocko]

Hi guys, here is the result of my support case:

• For a new installation see http://h20565.www2.hp.com/portal/site/hpsc/template.PAGE/public/psi/mostViewedDisplay/?javax.portlet.begCacheTok=com.vignette.cachetoken&javax.portlet.endCacheTok=com.vignette.cachetoken&javax.portlet.prp_efb5c0793523e51970c8fa22b053ce01=wsrp-navigationalState%3DdocId%253Dmmr_kc-0114705-6%257CdocLocale%253Den_US&javax.portlet.tpst=efb5c0793523e51970c8fa22b053ce01&sp4ts.oid=489496&ac.admitted=13929...
• For an upgrade see http://h20565.www2.hp.com/portal/site/hpsc/template.PAGE/public/psi/mostViewedDisplay/?sp4ts.oid=489496&spf_p.tpst=psiContentDisplay&spf_p.prp_psiContentDisplay=wsrp-navigationalState%3DdocId%253Dmmr_kc-0114700%257CdocLocale%253Den_US&javax.portlet.begCacheTok=com.vignette.cachetoken&javax.portlet.endCacheTok=com.vignette.cachetoken

This should solve the issue. As suspected, NTLM hardening as fault with use of new JTDS driver. 

Note: 2nd link might be dead but should be up soon ;)

[christian_derek]

Hi,

The upgrade link does not work.

Thanks,

[shocko]

I know, I stated it's dead! It should be up soon

[shocko]

See attached for resolution if performing an upgrade ;)

[shocko]

Tested successfully in my lab.