You are browsing the archive for CM12.

Avatar of timdk

by timdk

Unable to retrieve Configuration Manager 2012 Status Messages

7:13 pm in Configuration Manager by timdk

Recently I bumped into an interesting issue with status messages on a Configuration Manager SP1 site.

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”. When closing the initial dialog box 2 more errors are shown and in the end no status message are displayed at all.

The following screenshots show the exact errors:

clip_image002

clip_image004

clip_image006

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. Set the startup type to Delayed Start and then reboot the system after the change.

image 

We tried to get more information from Microsoft Support to better understand the root cause.  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. By implementing the delayed start of these services on the site server we ensure all required elements are starting in timely and sequential manner. Bottom line: all other services (eg. SQL) are starting up before the Configuration Manager services.

I hope this saves you some troubleshooting time when facing a similar issue.

Tim

Avatar of timdk

by timdk

How to retrieve the list of SMS Providers

5:32 pm in Configuration Manager by timdk

During a recent rollout of a Configuration Manager 2012 update I also had to target all systems hosting the SMS Provider. In smaller environments it is pretty common the SMS provider is installed locally on the site server, but in larger environments there can be multiple SMS providers spread across different remote systems. This blog post is a step-by-step guide on how to retrieve the list of SMS Providers in just a few minutes.

On the site server run WBEMTest and click Connect.

image

Fill in the namespace SMS\Root and click Connect.

image

Next hit the Query button.

image

Type in the query “Select * from SMS_Providerlocation” and click Apply.

image

The query result returns all SMS Providers.

image

As you can see, in my lab environment there is currently only one SMS Provider installed.

Hat tip to @theWMIGuy for teaching me this trick..

Until next time.

Tim