PENDING Component Status Message Viewer Blank

[Eden Nelson]

At some point my Component Status message viewer started always blank. It does not matter what component I try to view or for what time period. It's always blank and I can't find the solution.

Here is an example:
SMS_AD_USER_DISCOVERY_AGENT shows Status of Critical. I select properties and see I have 1 warning and 5 error critical messages.

I right click and select Show Messages > All, and click OK on the date/time selection box (1 day ago)

The Status Message Viewer appars with no entries!


What log should I look at to find out what is going on?

Currently running SCCM 1511, but problem was present in SCCM 2012 R2 SP1.

 

[Prajwal Desai]

check statmgr.log file & smsprov.log file. Let me know if you find any errors in those log files. Also try rebooting the server and see if that fixes the issue.

 

[Eden Nelson]

Prajwal,

Thank you so much. You nailed it. Any insight on how to resolve the issue?

inboxes\statmgr.box\retry is empty

SMSPROV.LOG

ERROR>: CSspQueryForObject::ConvertWBEMTimeToDBTime invalid wbemtime [2016/03/17 15:43:47.000]    SMS Provider    3/18/2016 8:43:46 AM    4904 (0x1328)

Execute SQL =select  all stat.Component,stat.MachineName,stat.MessageID,stat.MessageType,stat.ModuleName,stat.PerClient,stat.ProcessID,stat.RecordID,stat.ReportFunction,stat.Severity,stat.SiteCode,stat.SuccessfulTransaction,stat.ThreadID,stat.Time,stat.TopLevelSiteCode,stat.PartOfTransaction,stat.Win32Error,att.AttributeID,att.AttributeTime,att.AttributeValue,att.RecordID,ins.InsStrIndex,ins.InsStrValue,ins.RecordID from vStatusMessages AS stat LEFT OUTER JOIN vStatusMessageAttributes AS att ON stat.RecordID = att.RecordID  LEFT OUTER JOIN vStatusMessageInsStrs AS ins ON stat.RecordID = ins.RecordID   where (((stat.Component = N'SMS_HIERARCHY_MANAGER' AND stat.Time >= '2016/03/17 15:43:47.000') AND stat.SiteCode = N'MSC') AND stat.MachineName = N'SERVER') order by stat.Time desc    SMS Provider    3/18/2016 8:43:46 AM    4904 (0x1328)

 

[Prajwal Desai]

Try restarting SMS_EXECUTIVE service and start it back. If not do server reboot and let me know.

 

[Eden Nelson]

This problem has been going on for some time so we have rebooted but I went ahead and tried again.

Restart SMS_EXECUTIVE with no effect.
Rebooted with no effect.

I found that if I try to view messages on the server is get 3 error dialog boxes. "An unexpected error has occurred processing status messages [query not open]. Future processing for this query has been stopped."

Googled that message and found this article.
http://scug.be/tim/2013/08/22/unable-to-retrieve-configuration-manager-2012-status-messages/
Set SMS_EXECUTIVE and SMS_SITE_COMPONENT_MANAGER to Automatic (delayed) with no effect.

So I'm still stumped!

 

[Harshit Pandey]

I encountered same issue today and restarting sms_exec service and sms_site_comp_mganager fixed the issue.

 

[Eden Nelson]

Unfortunately my issue has been going on for some years now. We have had many reboots in that time and have seen no change. I just end up using CMTrace. I'm sure at some point I will get this resolved as my understanding of ConfigMgr grows.