Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 827393 - Last Review: May 31, 2007 - Revision: 1.7
You receive an "Unhandled Exception: System.Data.SqlClient.SqlException: Timeout expired" error message when you try to delete many portal areas
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.
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.
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.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
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:
APPLIES TO
- Microsoft Office SharePoint Portal Server 2003
| kbdatabase kberrmsg kbbug KB827393 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate