RMS keeps losing database connectivity
Keep getting the below event in the ops log on the RMS. The SQL backend is on same LAN as RMS and there is not network issue.
The management server lost database connectivity. Last database error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column
'BaseManagedEntityId'.
The statement has been terminated..
September 4th, 2012 8:35pm
Do you have the PKI Management pack? Exchange 2010 MP? There was a Key management MP (older version) that generated this I believe. I seem to remember us having this issue and I can't remember if updating the MP fixed it or if we had
to drop some tables from the ops db.Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/ If my response was helpful, please mark it as so, if it answered your question, then please also mark it accordingly. Thank you.
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2012 1:20am