Jump to content


alim_long

[SCCM 2012] TS failed:There no task sequences available to this computer

Recommended Posts

Microsoft provided me with two SQL queries to run against the database.

 

This one will check for bad policies in the database. if no results are returned from this query then you don't have the same issue.

 

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

 

 

This one will remove any bad policies if there are any.

 

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

 

 

After that restart the management point and everything should be working normally.

 

 

 

I thought I'd register and post a thank you for this post because it managed to fix an issue I'd been having for a few days. Also for anyone else that cares this also fixed a few issues we had with deploying clients and the clients not communicating with the SCCM Server and installing SCEP.

Share this post


Link to post
Share on other sites

Microsoft provided me with two SQL queries to run against the database.

 

This one will check for bad policies in the database. if no results are returned from this query then you don't have the same issue.

 

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

 

 

This one will remove any bad policies if there are any.

 

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

 

 

After that restart the management point and everything should be working normally.

 

 

 

This query resolved my issue of my staging collections of OSD deployments were not seeing their assigned OSD task sequences. Thanks for the post it helped me out greatly!

Share this post


Link to post
Share on other sites

Microsoft provided me with two SQL queries to run against the database.

 

This one will check for bad policies in the database. if no results are returned from this query then you don't have the same issue.

 

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

 

 

This one will remove any bad policies if there are any.

 

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

 

 

After that restart the management point and everything should be working normally.

 

 

 

This solved our Problem, after we stuck for 2 Weeks trying to resolve it

 

we had the Error: no task sequences available for this computer error code 80004005

 

 

 

Thank you very much!

Share this post


Link to post
Share on other sites

Microsoft provided me with two SQL queries to run against the database.

 

This one will check for bad policies in the database. if no results are returned from this query then you don't have the same issue.

 

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

 

 

This one will remove any bad policies if there are any.

 

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

 

 

After that restart the management point and everything should be working normally.

 

 

 

Just checking in to thank you. This solved my problem as well!

Share this post


Link to post
Share on other sites

Microsoft provided me with two SQL queries to run against the database.

 

This one will check for bad policies in the database. if no results are returned from this query then you don't have the same issue.

 

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

 

 

This one will remove any bad policies if there are any.

 

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

 

 

After that restart the management point and everything should be working normally.

 

 

 

Works like a charm ! In my case it wasn't necessary to restart the management point service. Thank you for your solution.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.