Skip to content

WSUS Classification problems

Featured Replies

  • Author

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.

 

post-18769-0-30773400-1403263858_thumb.png

 

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.

post-18769-0-41651900-1403263857_thumb.png

 

 

Think it's time for Supprt Ticket..

  • Replies 30
  • Views 24.8k
  • Created
  • Last Reply

Top Posters In This Topic

Posted Images

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

  • 2 weeks later...
  • Author

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.

  • 3 years later...

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.

  • 9 months later...

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

  • Author

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

 

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


image.png.fb07ff166f74a3aa8dc4a7674215ce25.png

image.png.509e902e61e9a07f47f50dbd13858138.png

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.

  • Author

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.

That did it! Thanks so much.

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...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.