You receive an "Unhandled Exception: System.Data.SqlClient.SqlException: Timeout expired" error message when you try to delete many portal areas (827393)
The information in this article applies to:
- Microsoft Office SharePoint Portal Server 2003
SYMPTOMSWhen 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.
CAUSEThis 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.WORKAROUNDTo 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.
| Modification Type: | Minor | Last Reviewed: | 1/9/2006 |
|---|
| Keywords: | kbDatabase kberrmsg kbBug KB827393 kbAudITPRO |
|---|
|