Management Server Health Service State not updating

Adrian_Salone

Hi all,

I've been noticing in my Dev environment this morning that when I import an update to a sealed management pack, this change is not reflected in the console.  The changes in the MP do seem to be making it successfully to the database.

I'm aware of the 'Clear Health Cache' process (i.e. stop services, delete the Health Service State folder, restart services on primary and secondary management servers), and this process does provide temporary relief until I need to update another management pack.

Thankfully, I'm not yet seeing this issue on my Production server, but for a Development server, where I am applying relatively frequent management pack updates, having to remember to flush the cache is seriously annoying, especially considering that the Dev environment seemed to be operating fine without regular cache flushing until recently (this Dev enviroment was rebuilt from scratch no more than 30 days ago).

Adding to my annoyance is the apparent lack of entries in the Ops Manager log to indicate that SCSM is even aware of an issue.

Rant over - has anyone else experienced my pain?

 

Adrian_Salone

Scratch that - the SQL Broker Service was disabled.  Fix is as follows:

Check if the SQL Broker is enabled. A disabled SQL broker could cause this behaviour.

-          Check status by running this command:
SELECT is_broker_enabled FROM sys.databases WHERE name = 'ServiceManager‘

-          If disabled (0) enable it by running these commands:
ALTER DATABASE ServiceManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE ServiceManager SET ENABLE_BROKER

ALTER DATABASE ServiceManager SET MULTI_USER

Adrian_Salone

Scratch that - the SQL Broker Service was disabled.  Fix is as follows:

Check if the SQL Broker is enabled. A disabled SQL broker could cause this behaviour.

-          Check status by running this command:
SELECT is_broker_enabled FROM sys.databases WHERE name = 'ServiceManager‘

-          If disabled (0) enable it by running these commands:
ALTER DATABASE ServiceManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE ServiceManager SET ENABLE_BROKER

ALTER DATABASE ServiceManager SET MULTI_USER

Adrian_Salone

I should attribute the above answer to Anders Asp - I had also posed this question on the Technet Forums...