In this post I am writing about a strange case that happened in my SCCM 2012 sp1 environment. I’m not sure if its related, but it all happened after installing CU3.
The case was resolved after an intervention of Microsoft Senior Support Engineer. Maybe this will help someone since there is no solution for this on the web.
It all began when my SCCM environment just stopped working…
1. All Packages deployment tasks are grayed out, and stuck on Unknown status.
2. You cannot distribute Microsoft security updates to clients.
3. Might be this as well – in smsts.log you see this error: Task Sequence fails with error: There is no task sequences available to this computer.
4. Check your Management Point server under <install Drive>\Program files\SMS_CCM\Logs\MP_Policy.log for the following lines:
Detected at least one row in the result set from PolicyAssignment table which does not have a Signature, rejecting all rows.
CalculateCRCFullAssignments cookie has changed, old cookie 2013-09-17 19:54:15.423, new cookie 2013-10-08 12:49:49.060
SCCM 2012 SP1 clients does not receive policy.
First step: using query analyzer, run the following query on your DB to check the SCCM database integrity:
SELECT * FROM ResPolicyMap WHERE machineid = 0 and PADBID IN (SELECT PADBID FROM PolicyAssignment WHERE BodyHash IS NULL)
If you get NULL values in TargetSourceID, proceed to next step:
Run the following procedure on your DB. This will delete the wrong values from the DB:
Delete FROM ResPolicyMap WHERE machineid = 0 and PADBID IN (SELECT PADBID FROM PolicyAssignment WHERE BodyHash IS NULL)
You should get something like this:
Now, Restart the SMS Agent Host service on your MP.
This should resolve the problem.
I hope this has been helpful for you,