Solved

Windows Server Update Services Error - Webpage Dialog

Posted on 2008-10-28
13
1,716 Views
Last Modified: 2013-11-16
I have received this error when I try to approve any more updates....
Windows Server Update Services encounted an error.
Could not allocate space for object 'tbDeadDeployment' in database 'SUSDB' because the 'PRIMARY' filegroup is full.

There is plenty of room on this server.  I do not have the full version of SQL on this server, other than the included version with WSUS.  Any ideas?
(I have attached the screen shot of the error.)
WSUSError.jpg
0
Comment
Question by:shrimpfork
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 14

Accepted Solution

by:
Hedley Phillips earned 500 total points
ID: 22821477
Has your database reached the 2gb limit?
0
 
LVL 14

Expert Comment

by:Hedley Phillips
ID: 22821505
Also,

what are the event ID's you are receiving?


0
 

Author Comment

by:shrimpfork
ID: 22821513
I'm not sure where to look for that.  Where does the WSUS store the database?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:shrimpfork
ID: 22821547
When the error occurs, it logs Event ID 386.  Here is what the description states....

Synchronization failed. Reason: System.Data.SqlClient.SqlException: Could not allocate space for object 'tbXml' in database 'SUSDB' because the 'PRIMARY' filegroup is full.
   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
   at Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPImportUpdate(Int32 upstreamServerLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, Int32& localRevisionId)
   at Microsoft.UpdateServices.Internal.DataAccess.ImportUpdate(Int32 ussRevLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, Int32& localRevisionId)
   at Microsoft.UpdateServices.Internal.DataAccess.ImportUpdateForCatalogSync(String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, ServerSyncUrlData[] fileUrls)
   at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ProcessNewUpdate(ServerSyncUpdateData updateData)
   at Microsoft.UpdateServices.ServerSync.CatalogS.
0
 

Author Comment

by:shrimpfork
ID: 22821569
I found what I think is the database location....the file "SUSDB.mdf" is at the 2 GB limit.  Now how do I clean this up.  My ultimate goal is to install WSUS 3.0.
0
 
LVL 14

Expert Comment

by:Hedley Phillips
ID: 22821612
Somewhere there are some steps to backup your database, reinstall WSUS using some switches to force it to use the english unthrottled WMSDE instance and then restore the database.

How to backup and restore:
http://technet.microsoft.com/en-us/library/cc708546.aspx

Read here for making space by managing WSUS DB from the command line:
http://technet.microsoft.com/en-us/library/cc720466.aspx
0
 
LVL 14

Expert Comment

by:Hedley Phillips
ID: 22821644
Here is some more info:

"The downloadable MSDE only supports a database up to 2GB in size. You need to maintain it to keep it under that limit. Your HOME page in the WSUS administration console should instruct you to run the following command:"

WSUSutil.exe deleteunneededrevisions

So, if you run that command and then you should be able to upgrade from 2.0 to 3.0
0
 

Author Comment

by:shrimpfork
ID: 22821669
I am running the WSUSUTIL.EXE utility to delete unneeded revisions to see if this reduces the size at all.
0
 
LVL 14

Expert Comment

by:Hedley Phillips
ID: 22821704
I am not sure if you can upgrade over the top of 2.0 with a db that has reached the 2gb limit. You might be able to, I just don't know.

Try reducing the size first and then if that doesn't work try updating anyway. I am sure it will moan if it can't manage it. It is Microsoft after all.
0
 

Author Comment

by:shrimpfork
ID: 22822136
While running the WSUSutil.exe deleteunneededrevisions, it encountered the same error:

Database cleanup encountered an error, please check your server and try again
Fatal Error: Could not allocate space for object 'tbDeadDeployment' in database
'SUSDB' because the 'PRIMARY' filegroup is full.

The size was not reduced.  I would like to fix this before I upgrade to 3.0.
0
 

Author Comment

by:shrimpfork
ID: 22825529
I am at a loss here.  I'm thinking about removing WSUS 2.0 and installing 3.0.  Your thoughts?
0
 
LVL 14

Assisted Solution

by:Hedley Phillips
Hedley Phillips earned 500 total points
ID: 22865677
Hi,

sorry for the delay in replying.

Uninstalling 2.0 is certainly an option. It won't take too long for 3.0 to download all the updates either. Esp if you make BITS run in the foreground.

WsusDebugTool /Tool:SetForegroundDownload
0
 

Author Comment

by:shrimpfork
ID: 22867295
I have already proceeded on this and have installed 3.0.  Thanks for your help.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Learn about cloud computing and its benefits for small business owners.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question