[SIM 6.0] Web interface stop responding and logs database events

[Danilo B]

Hi,

sometimes HP SIM web interface stop responding and event log shows these events and I need to restart SIM service manually:

Warning
Source: HP Systems Insight Manager
Event: 2
Description: Restarting MxDomainManager

Information:
Source: HP Systems Insight Manager
Event: 3
Description: Restart was Successful

Information:
Source: MSSQL$SQLEXPRESS
Event: 17137
Description: Starting up database 'Insight_v50_0_17230308'.

Error
Source: HP Systems Insight Manager
Event: 3
Description: ERROR: TABLE SIM_NodeEntitlement KEY NodeId may contain 1 entrie(s) not in table devices KEY nodeLuid

Error
Source: HP Systems Insight Manager
Event: 3
Description: Pass 1

Error
Source: HP Systems Insight Manager
Event: 3
Description: 1 entries fixed in TABLE SIM_NodeEntitlement

Information
Source: HP Systems Insight Manager
Event: 3
Description: HP Systems Insight Manager started.

Operating System: Windows Server 2003 Standard Edition SP2
Database SQL Server 2008 Express Edition

Thank you all for help.

[Danilo B]

Nobody else is experiencing the same issue? Any help would be really appreciated.
HTTP 404 on SIM interface is really a noisy problem when you need access to SIM interface. I have to manually restart SIM service every time to make it working again.

Thank you all for help in advance.

[mysuleiman]

I have exactly the same problem.

Did you ever get a fix for this?

[Danilo B]

Hi,

not really. I am still having about one-two SIM crash per day but now it automatically restarts (no more 404 pages).
Just upgraded SIM to ver 6.1 and then 6.2 and limited SQL server memory usage to save server memory to SIM process.

Please also refer to this document at page 4 "Job cleanup for a large number of managed systems" and lower values to save some memory too. This also helped.

http://h20000.www2.hp.com/bc/docs/support/SupportManual/c01650324/c01650324.pdf

Hope this help!

Regards, Danilo

[mysuleiman]

It's a great help. Many Thanks