Solved

Windows Server Update Services Error - Webpage Dialog

Posted on 2008-10-28
13
1,709 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
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…

708 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

11 Experts available now in Live!

Get 1:1 Help Now