CMS Server Generates 404 and 500 Errors During Background Processing (813513)


The information in this article applies to:

  • Microsoft Content Management Server 2001
  • Microsoft Content Management Server 2001 SP1

SYMPTOMS

When Microsoft Content Management Server (MCMS) is running background processing, you may receive 404 or 500 error messages when you view the site. You may also see the following information event in the MCMS server's application event log:There is currently a long running transaction in the server. Please try your request again.
The MCMS background process locks the database when it is running so that you cannot update the database and accidentally cause database inconsistency while background processing is trying to clean items.

RESOLUTION

A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that are experiencing this specific problem. This fix may receive additional testing. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next Microsoft Content Management Server 2001 service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix has the file attributes (or later) 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   Size  File name
   -------------------------------------------
   17-Sep-2002  06:35  233   Bp_processing.sql
Note Because of file dependencies, this update requires MCMS 2001 Service Pack 1.
Background processing performs three tasks:
  • Purges data that is no longer used or referenced by any page, posting, or template from the BLOB table in the MCMS database.
  • Scans all postings and purges all postings from the MCMS database if the postings have expired.
  • Scans all pages and performs one of the following actions if the pages have expired:
    • Purges the page from the MCMS database.
    • Moves the page to the Deleted Items folder.
    • Moves the page to a predefined folder.
The background processing SQL script that is included in this hotfix only purges data from the BLOB table in the MCMS database. Because the two other tasks are no longer performed automatically, you may have to update or clean the database manually. You can also run background processing on the MCMS server on a weekly or monthly basis to keep the expired postings and pages cleared out automatically.

Note that this suggestion is only for use until the background process SQL script is completed.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MinorLast Reviewed:10/10/2005
Keywords:kbHotfixServer kbQFE kbfix kbContentMgtServ2001preSP2fix kbbug KB813513
©2004 Microsoft Corporation. All rights reserved.