Microsoft KB Archive/816978

= BUG: Site Deployment Fails if Server Data Object (.sdo) File Is More Than 250 MB =

Article ID: 816978

Article Last Modified on 12/7/2005

-

APPLIES TO


 * Microsoft Content Management Server 2002

-



SYMPTOMS
If you create a Server Data Object (.sdo) file that is more than 250 MB by using Site Deployment Manager in Microsoft Content Management Server (MCMS), the file may be terminated abruptly with errors. The errors are logged in the application section of the Windows Event Viewer. These errors refer to an out-of-memory exception in SQL Server, but the errors may also indicate SQL Server client errors. The following error messages are examples of the type of errors that you may receive:  

MCMS Site Deployment - Error occurred System.Data.SqlClient.SqlError: A severe error occurred on the current command. The results, if any, should be discarded.

 

MCMS Site Deployment - Error occurred. System.OutOfMemoryException: Exception of type System.OutOfMemoryException was thrown.

 

MCMS Site Deployment - Error occurred. System.Data.SqlClient.SqlError: General network error. Check your network documentation.





CAUSE
This problem occurs because the .sdo file requires heavy use of the SQL Server memory resources. This heavy use contributes to the SQL Server memory failure. The SQL Server memory failure leads to the MCMS error in Site Deployment Manager.



Service pack information
To resolve this problem, obtain the latest service pack for Microsoft Content Management Server 2002. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

906142 How to obtain the latest Content Management Server 2002 service pack

Hotfix information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel. Date        Time   Version            Size    File name -- 10-Dec-2002 21:52  4.0.1381.4         65,600  Cmsupdate.exe 04-Apr-2003 00:35  5.0.1630.0      2,056,192  Nrsitedeployserver.dll 04-Apr-2003 17:11                      1,677  Update.inf



STATUS
Microsoft has confirmed that this Is a problem In the Microsoft products that are listed In the &quot;Applies To&quot; section. This problem was corrected in Content Management Server 2002 Service Pack 1.



MORE INFORMATION
If you experience this problem after you install this hotfix, you probably have fragmented memory in your computer running SQL Server. Restart your computer running SQL Server to free the memory. You do not have to restart your MCMS server. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

814774 HOW TO: Troubleshoot Site Deployment Issues in Microsoft Content Management Server 2002

Keywords: kbbug kbfix kbcontentmgtserv2002sp1fix kbqfe kbhotfixserver KB816978

-

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

© Microsoft Corporation. All rights reserved.