Microsoft KB Archive/827393

= You receive an &quot;Unhandled Exception: System.Data.SqlClient.SqlException: Timeout expired&quot; error message when you try to delete many portal areas =

Article ID: 827393

Article Last Modified on 5/31/2007

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003

-





SYMPTOMS
When you try to delete a large number of portal areas, the operation may time out, and no portal areas are deleted. You receive an error message that is similar to the following:

Server Error in '/' Application.

Unhandled Exception: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Additionally, when you view the current locks in SQL Server Enterprise Manager (expand Management, expand Current Activity, and then expand Locks/Process ID), you may find that the sps_rCheckTreeForDelete object is blocking other connections.



CAUSE
This problem may occur if you delete a large number of portal areas at the same time. For example, you may experience this issue when you try to delete 500 or more portal areas at the same time. You are also more likely to experience this issue on a server that uses a slower processor.



WORKAROUND
To work around this problem, do not delete a large number of portal areas at the same time. Delete a smaller number of portal areas at any one time.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
For more information about how to configure and administer SharePoint Portal Server, see the Microsoft Office SharePoint Portal Server 2003 Administration Guide. The Microsoft Office SharePoint Portal Server 2003 Administration Guide (Administrator's Help.chm) is located in the Docs folder in the root of the SharePoint Portal Server 2003 CD.

For more information about SharePoint Portal Server, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/sharepointserver/FX101494611033.aspx

Keywords: kbdatabase kberrmsg kbbug KB827393

-

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

© Microsoft Corporation. All rights reserved.