FIX: DeleteRecursive Generates Error When Non-Administrator Deletes Item (810945)

SYMPTOMS

When you delete an item such as a posting or a page through Site Builder, you receive the following error message:

Offending SQL: {call DeleteRecursive(?, ?, ?, ?, ?, ?, ?)};Associated statement is not prepared.

The following warning messages appear in the application event logs on the CMS server:

Connection 00AA3118 <[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '22'.>{State=42000 NativeCode=170}..

Connection 00AA3118 <[Microsoft][ODBC SQL Server Driver]Associated statement is not prepared>{State=HY007 NativeCode=0}..

Offending SQL: {call DeleteRecursive(?, ?, ?, ?, ?, ?, ?)};Associated statement is not prepared. .

Forcing Rollback of Sandbox 168828432. Last action was DExtended error: [What='Offending SQL: {call DeleteRecursive(?, ?, ?, ?, ?, ?, ?)};Associated statement is not prepared. '] [LCID='1024'] [SourceFile=''] [SourceFileLine='-1'] [DebugInfo=''] [RecommendedAction='The ODBC data source may be incorrectly configured, the database may not be running, or there may be incorrect data in the database.'] [ExtraInfo=''] [UniqueErrorId='4005'] [Severity='5'] [Source=''] [CategoryId='0']-1.

CAUSE

A stored procedure that the CMS server uses has logic that determines whether a user is an administrator before deleting items. If the user is not an Administrator, the stored procedure determines if the current logged on user has the rights to delete the item.

The logic that the stored procedure uses takes all of the groups that a user is a member of on the domain. If the user is a member of too many groups, the SQL statement is not successful, and you receive the error messages that are described in the "Symptoms" section.

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it 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 (MCMS) 2001 service pack that contains this fix.

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 usual 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
   --------------------------------------
   30-Oct-2002  00:40  21,711  Qfe339.sql

   Date         Time   Size    File name
   -----------------------------------------------------
   16-Jan-2003  20:21  21,511  Res40_deleterecursive.sql

Note Because of file dependencies, this update requires MCMS 2001 Service Pack 1.

Note Separate fixes for MCMS 2001 and Resolution 4.0 are issued. The file dependency issue with MCMS 2001 SP1 does not apply to the Resolution 4.0 fix file.

FIX: DeleteRecursive Generates Error When Non-Administrator Deletes Item (810945)

SYMPTOMS

CAUSE

RESOLUTION

STATUS