After upgrading from SCCM 2012 R2 SP1 to SCCM 1610, we have begun experiencing issues when running status message queries both on the site and components. When attempting to view the status messages, the status message viewer appears and reports three errors in a row:
Error #1: The status viewer was unable to retrieve the stored queries list from the database.
Error #2: Configuration Manager could not provide the data that you requested. Please refer to the Configuration Manager documentation for troubleshooting information.
Error #3: An unexpected error has occurred processing status messages [Query not open]. Further processing for this query has been stopped.
Research indicates we should change the SMS Executive and SMS Component Manager to delayed start, which we have done. However, this does not resolve the issue. We have to reboot the server and then wait up to an hour before we can begin retrieving status messages. This has occurred daily since the upgrade a couple of weeks ago.
I found this website, which has screenshots of the same exact errors and provided the potential solution of delaying services: http://scug.be/tim/2013/08/22/unable-to-retrieve-configuration-manager-2012-status-messages/
If anyone has any ideas, I would be very appreciative!