Microsoft KB Archive/919491

= FIX: Authors may receive authoring error messages after an author deletes a page that stored on a large MCMS 2001 database =

Article ID: 919491

Article Last Modified on 9/11/2007

-

APPLIES TO


 * Microsoft Content Management Server 2001 Enterprise Edition

-



SYMPTOMS
Consider the following scenario. An author deletes a page that is stored on a large Microsoft Content Management Server (MCMS) 2001 database. Other authors perform authoring actions. In this scenario, the other authors may receive authoring error messages. The error messages may resemble the following:

Error: Error in Page Creation using ROM

Description: Failures occurred during the multi-object commit…

Details: Extended error: [What='Transaction (Process ID XXX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.']



CAUSE
This problem occurs because temporary tables in Microsoft SQL Server are scanned repeatedly.



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

To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone 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 usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

File 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 item in Control Panel.



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



MORE INFORMATION
To apply this hotfix, follow these steps:
 * 1) Start SQL Query Analyzer on the instance of SQL Server that is hosting the MCMS 2001 database. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
 * 2) On the Query menu, click Change Database.
 * 3) In the Select Database dialog box, click the MCMS 2001 database, and then click OK.
 * 4) On the File menu, click Open, locate the Kb919491.sql script file, and then click Open.
 * 5) On the Query menu, click Execute.

For more information about this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:

919099 Description of Content Management Server 2002 post-Service Pack 1 hotfix package: May 19, 2006

Keywords: kbpubtypekc kbhotfixserver kbcontentmgtserv2001presp2fix kbfix kbqfe kbbug KB919491

-

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

© Microsoft Corporation. All rights reserved.