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


The information in this article 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 "Applies To" 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

Modification Type:MajorLast Reviewed:12/7/2005
Keywords:kbContentMgtServ2002sp1fix kbHotfixServer kbBug kbfix kbQFE KB816978 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.