Microsoft KB Archive/909456

= Error event 386 and other synchronization problems occur when you use the default WMSDE database configuration to deploy Windows Server Update Services =

Article ID: 909456

Article Last Modified on 5/29/2007

-

APPLIES TO


 * Microsoft Software Update Services 1.0

-





SYMPTOMS
When you use the default Microsoft SQL Server Desktop Engine (Windows) (WMSDE) database configuration to deploy Microsoft Windows Server Update Services (WSUS), one or more of the following problems occur:  Client computers stop reporting to the WSUS server. Therefore, no new client computers are added to the WSUS computer list. WSUS cannot synchronize with Microsoft Update. An administrator cannot approve new updates or cannot change settings. An Error event that is similar to the following may be logged in the Application log:

Event Type: Error

Event Source: Windows Server Update Services

Event Category: (2)

Event ID: 386

Date:

Time:

User: N/A

Computer:WSUS

Description:

The description for Event ID ( 386 ) in Source ( Windows Server Update Services ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details.

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

 The WSUSMSDESetup .txt file contains text that is similar to the following in the SetDisableThrottle section:

MSI (s) (9C:54) [10:16:11:056]: Skipping action: SetDisableThrottle (condition is false)





CAUSE
These problems may occur in a large-scale, non-English-language deployment in which the WSUS database grows to more than 2 gigabytes (GB). These problems occur because the DisableThrottle setting is not included in the installation parameters for some localized versions of WSUS. These localized versions include the following versions:
 * Japanese
 * Simplified Chinese
 * Traditional Chinese

Therefore, WMSDE is installed in Throttled mode. This configuration limits the size of the WSUS database to 2 GB.



RESOLUTION
To resolve this problem, use one of the following methods, as appropriate for your situation.

Method 1
<ol> Type the following command from the osql command prompt to back up the database:

Execute %programfiles%\update services\Tools\osql\osql.exe –S \WSUS –E -b –n –Q &quot;BACKUP DATABASE SUSDB TO DISK=' '&quot;

Note The  placeholder represents the name of the server where WSUS is installed. You do not have to add backward slashes (\\) in front of the server name. Also, the  placeholder represents a full path. This includes the drive name and the file name. For example, the backup location placeholder could represent &quot;BACKUP DATABASE SUSDB TO DISK=' '&quot; </li> Remove WSUS, and then delete the database. For more information about how to remove WSUS from SQL Server, visit the following Microsoft Web site:

http://technet2.microsoft.com/WindowsServer/f/?en/Library/9e205a3f-6459-40c5-9b52-bdfed707165e1033.mspx

</li> Download a new installation of WSUS, and then save it to the computer's hard disk. To do this, visit the following Microsoft Web site :

http://www.microsoft.com/windowsserversystem/updateservices/downloads/WSUS.mspx

</li> Type the following command to install WSUS:

WSUSSetup.exe /l:ENU

Note /I:ENU does not alter the display of the administration console. Also, it does not affect your local language setup.</li> Type the following commands to stop the WSUS service and Microsoft Internet Information Services (IIS):

net stop wsusservice

Iisreset /stop

</li> Type the following command to restore the database:

Execute %programfiles%\update services\Tools\osql\osql.exe –S \WSUS –E -b –n –Q &quot;RESTORE DATABASE SUSDB FROM DISK=' '&quot;

Note The  placeholder represents the name of the server where WSUS is installed. You do not have to add backward slashes (\\) in front of the server name. Also, the  placeholder represents a full path. This includes the drive name and the file name. For example, the backup location placeholder could represent &quot;BACKUP DATABASE SUSDB TO DISK=' '&quot; </li> Restart the computer.</li></ol>

Method 2
Upgrade the WSUS 2.0 installation to WSUS 2.0 Service Pack 1 (SP1). WSUS 2.0 SP1 upgrades WMSDE Service Pack 3 (SP3) to WMSDE Service Pack 4 (SP4) and fixes the 2-GB size limit.

To download WSUS 2.0 SP1, visit the following Web site:

http://download.microsoft.com/download/f/6/d/f6d9eb30-2612-47f7-b14a-41a47e8a9a8e/WSUS2-KB919004-x86.exe

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
WMSDE can be run in either Throttled or Unthrottled mode. In Throttled mode, WMSDE behaves similarly to a typical MSDE instance that has a 2-GB size limitation on the databases. In Unthrottled mode, this limitation is removed.

Keywords: kbexpertiseadvanced kbtshoot kberrmsg KB909456

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.