Management Server Health Service State not updating
Adrian_Salone
Partner IT Monkey ✭
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?
Best Answer
-
Adrian_Salone
Partner IT Monkey ✭
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 IMMEDIATEALTER DATABASE ServiceManager SET ENABLE_BROKER
ALTER DATABASE ServiceManager SET MULTI_USER
7
Answers
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