During the weekend, our SQL server ran a SP1 feature pack installation and all of a sudden on monday morning, my OSD failed on all computers, nothing been changed on  anything.

The client reboot straight after network connection... the restart itself.

Log:

<![LOG[There are no task sequences available to this computer.. Please ensure you have at least one task sequence advertised to this computer.

 

I have tried everywhere in the end I found this on WindowsNoob.

http://www.windows-noob.com/forums/index.php?/topic/7595-sccm-2012-ts-failedthere-no-task-sequences-available-to-this-computer/

 

SO I ran a sql query against SCCM db

SELECT * FROM ResPolicyMap WHERE machineid = 0 and PADBID IN (SELECT PADBID FROM PolicyAssignment WHERE BodyHash IS NULL)

and I got 2 rows. Which means no good, those two broken policies prevent the client to access other Task sequences assigned to it.

So another sql query to delete it:

Delete FROM ResPolicyMap WHERE machineid = 0 and PADBID IN (SELECT PADBID FROM PolicyAssignment WHERE BodyHash IS NULL)

and restarted the MP the server went back.

 

Apparently I am the only one on that post only spend 4 hours, apparently people spend days even weeks, guess I am lucky?

 

About Lei

I am an IT specialist with over 10 year experience - years on Automation, on-Premise or Azure.

I am happy to develop however never want be a full time developer. Only do what I have to do. If it has to be PowerShell,HTML, PHP, CSS, C#, VBS or JS, front end or backend, so be it, doesn't matter!

Spent years with Windows, SCCM, SharePoint, SQL and Exchange servers. For last several years, I have been actively working under On Premise > Azure environment.

THERE IS NO WAY BACK!!!

Current Certificates:
    Microsoft® Certified-
  • -Enterprise Administrator
  • -Database Administrator
  • -SharePoint Administrator
  • -Administering and Deploying SCCM 2012
Red Hat Certified Technician
ITIL V3 Foundation - Practitioner

Working on Azure Certificates now and hopefully they can stop upgrading their questions one day! GIVE ME A BREAK!

Contact Lei

Name *
Email *
Comments *

Traffic since 10/08/2016

Today13
Yesterday83
This week637
This month1933
Total416293

Visitor Info

  • IP: 54.221.73.186
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

1
Online

2017-12-17

Login