Sccm state messages not updating
The following screenshots show the exact errors: We spent quite some time troubleshooting this issue but nothing on the server or any of the logs was pointing into a direction of a possible cause.
Turns out that to resolve this issue you need to modify the startup type of the SMS Executive and Component Manager Services.
If you can explain the cause of the problem, please do post a comment.
Recently I bumped into an interesting issue with status messages on a Configuration Manager SP1 site.
Apparently what is part of the issue is the way how the Configuration Manager infrastructure was implemented.
In this particular case the site server and SQL are installed on one system and the SMS Provider is installed on another remote system.
So, unfortunately, I seem to have fixed the problem by going straight to the nuclear option, and missed out on any opportunity for finding the root cause.
While I don’t have an explanation about why the stored procedure errored out, I’m posting this description of my experience in hopes of helping others.
Each file contained a stored procedure named “sp_Ins Content Distribution Status”, and each of these stored procedures involved the source path to a Microsoft update in one of my Software Update Deployment Packages.The following occurs when trying to run a status message query: an error message is displayed indicating “the status viewer was unable to retrieve the stored queries list from the database”.