Cannot View Software Update Compliance Status
Here’s one problem I’ve been wrestling with for a bit and I think this is good information to share.
You view under the Update Repository of the SCCM console and find under any update classes that the number of computers requires/installed/not required are all showing up as 0. Viewing the Software Update compliance report for a specific computer shows no information. Further investigation reveals that all the clients ran the scan successfully and reported back to the MP. Now, what could be the problem? That led me to investigate further on the server side which brought me to this error in the statmgr.log.
Thread "State Message Processing Thread #0" id:12708 was unable to process file "D:Program FilesMicrosoft Configuration Managerinboxesauthstatesys.boxprocessNEJWADWJ.SMX", moving to corrupt directory. SMS_STATE_SYSTEM 1/1/1601 12:00:00 AM 12708 (0x31A4)
SQL MESSAGE: spProcessStateReport – Error: Message processing encountered a SQL error 9802 at record 1 for TopicType 501: "The locale identifier (LCID) 17417 is not supported by SQL Server.", Line 0 in procedure "" SMS_STATE_SYSTEM 1/1/1601 12:00:00 AM 12708 (0x31A4)
Browsing to the path above showed me thousands of files in the corrupt folder. Now that’s why I’m not getting any compliance scan results showing up on the console. The solution I am gonna take may seem outrageous to folks in different parts of the world. The way to do it is to change the Regional Settings on the server. Here are the steps taken:-
- Go to Regional and Language Options in control panel and set everything to US-English.
- Click in the Administrative tab.
- Click Copy settings to Reserved Accounts…
- Selected Check box System account (Local System, Local Service, and network service)
- Restart the Database Machine as well as the SCCM server.
Apparently, if you are using other Regional Settings, SQL has a problem writing in that format. Many thanks to Winds and Chris that helped me look into this together though this is extremely rare. Who knew something so small made something seem so big.