Solved

Windows Server Update Services Error - Webpage Dialog

Posted on 2008-10-28
13
1,711 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
  • 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
 

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
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…

867 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now