Cannot clear any events in HPSIM 5.2

[Bart VI]

Hi,

I'm having a problem with HPSIM 5.2 SP2, being that I cannot clear any events anymore.

SIM is installed on a Proliant DL380 with SQL database on a shared SQL2005 cluster, all running Win2K3 enterprise SP2.
NIC teaming is set to NFT.

As for the errors I am seeing (with some stuff replaced by X's) ->
- From mx.log I get:
@!@,2009-01-13 08:44:10 CET,CONFIG,FAILURE,START,TASK,Clear Events,ERROR,XXX\ZIxxxxxx,581xx,87235xxxx,Bart VI
The target collection is empty.
@!@,2009-01-13 08:44:10 CET,CONFIG,FAILURE,RUN,TASK,Clear Events,ERROR,XXX\ZIxxxxxx,581xx,87235xxxx,Bart VI
The target collection is empty.

- HP SIM has also logged this in the windows apllication eventlog just before the events wouldnt clear anymore:

ERROR: TABLE hpmxTargetStatus KEY NodeID may contain 181 entrie(s) not in table devices KEY MxGUID

and

ERROR: TABLE SecurityNoticesData KEY noticeId may contain 2 entrie(s) not in table notices KEY noticeId

Anyone got any suggestions? Unfortunately the solution is not as simple as restarting SIM :-)

I'll post here if I find it out myself :-)

Cheers
Bart

[Bart VI]

Strangly, the problem went away after the third reboot of the SIM server.