WSUS Classification problems

[stgrdk]

Thanks Kevin for all your ideas.

 

I might have for the root cause for the problem.

 

As seen in this picture alle the Update Categories marked with yellow has AllowSubscription = 0

and line number 11 starts with 16777253.

 

 

And seen in this picture, line 1 is referring to 16777253 and none of the update classifications. So perhaps some ugly thing has happened in the database.

 

 

Think it's time for Supprt Ticket..

[oxyle]

Alright! Nice find, let me know what the results are.

[stgrdk]

I talked with Microsoft, and while the technician tried to recreate through virtual lab, I did the same, and found out if I altered the DB in my virtual lab I could recreate the problem, and also get it back.

So I asked the technician if I could just do the same, and his answer was yes, just try.

 

And now my system is working again, both of the problems I had.

[ajp]

I know this is an old post but if you read this and remember can you write up more details on how you fixed this please.

[wej]

Did the resolution involve having a Microsoft support ticket because I'm having the exact same problem and I found the tables pictured and they look exactly the same. what was the resolution needed to resolve? I have reinstalled SUP and WSUS  multiple times and I'm still getting only Upgrade classification but All Products.

Thanks

[stgrdk]

I did have A support ticket, but I managed to solve this problem myself. 

The issue  was that I somehow managed to delete some rows in the database, so I found another scan database and replicated the lost rows myself.

 

what do you get if you type these queries:

 

select * from v_UpdateCategoryInstances

and

select * from CI_UpdateCategorySubscription

 

[wej]

Almost the same as what you posted. The only difference is I don't have 16777253 on select * from CI_UpdateCategorySubscription

[wej]

I have this suspicion that we used to use Flexera for 3rd party patching and removing it from the config server did something to the database.

[stgrdk]

All right , try and alter the table and add those rows as you can see is missing from the other table, I vaguely remember that rowversion data is autogenerated.

just start with recreating 1 row and see in the console if it helped.

[wej]

That did it! Thanks so much.