Microsoft KB Archive/888843

= &quot;Stack overflow dump not possible&quot; error messages are logged in the SQL Server error log on a computer that is running SharePoint Team Services and Microsoft SQL Server =

Article ID: 888843

Article Last Modified on 4/11/2005

-

APPLIES TO


 * Microsoft SharePoint Team Services

-





SYMPTOMS
SharePoint Team Services from Microsoft is configured to use Microsoft SQL Server as the database backend. When you perform a SharePoint Team Services operation that uses a DELETE statement to delete data from the UserInfo table, error messages that are similar to the following are logged in the SQL Server error log:

Stack Overflow Dump not possible - Exception c00000fd E at 0x00401BF2

spid56 Address=401bf2 Exception Code = c00000fd

spid56 eax=482f2030 ebx=0000065b ecx=0097f900 edx=0000000c

spid56 esi=4bde1d00 edi=00000100 eip=00401bf2 esp=26273000

spid56 ebp=26273004 efl=00010246

spid56 cs=1b ss=23 ds=23 es=23 fs=3b gs=0



CAUSE
This issue occurs if the UserInfo table in the database that is used by SharePoint Team Services is referenced by lots of foreign keys. SharePoint Team Services adds foreign keys to the UserInfo table when a Web site is created. Having lots of foreign keys in the UserInfo table exhausts the stack memory because the delete operation evaluates each foreign key.



RESOLUTION
To remove the existing foreign keys, use Microsoft SQL Query Analyzer on the computer that is running Microsoft SQL Server to run a query to remove the existing foreign keys from the UserInfo table, and then restart Microsoft Internet Information Services (IIS).

Note Microsoft Office XP Service Pack 3 (SP3) for SharePoint Team Services removes the foreign key limitation that is set for the UserInfo table in SharePoint Team Services. After you install Office XP SP3 for SharePoint Team Services on the server, the foreign key limitation does not apply to new Web sites that you create. For more information about Office XP Service Pack 3 for SharePoint Team Services, click the following article number to view the article in the Microsoft Knowledge Base:

833845 Overview of Office XP Service Pack 3 for SharePoint Team Services

Installing Office XP SP3 for SharePoint Team Services does not remove existing foreign keys. Office XP SP3 for SharePoint Team Services only prevents new foreign keys from being created. If the number of foreign keys that currently are in the UserInfo table exceeds the maximum number of foreign keys, use SQL Query Analyzer to run a script to remove the existing foreign keys.

To use SQL Query Analyzer to remove existing foreign keys from the UserInfo table, follow these steps:  Use SQL Query Analyzer to run a query to remove the existing foreign keys. To do this, follow these steps:  Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer. In the Connect to SQL Server dialog box, specify the instance of SQL Server that you want to connect to, specify the type of authentication that you want to use, and then click OK. In the list that is displayed in the toolbar, click the DOWN ARROW, and then click the database that is used by SharePoint Team Services.  Copy and then paste the following query to the Editor pane of SQL Query Analyzer: USE &quot;databaseName&quot; GO DECLARE @TableName nvarchar(256) DECLARE @KeyName nvarchar(256) DECLARE @DropSQL nvarchar(1024) DECLARE FKCursor CURSOR FOR SELECT dbo.sysobjects.name AS KeyName, sysobjects_1.name AS ParentName FROM dbo.sysobjects INNER JOIN dbo.sysobjects sysobjects_1 ON dbo.sysobjects.parent_obj = sysobjects_1.id WHERE (dbo.sysobjects.type = 'F') AND (sysobjects_1.name <> N'Lists')

OPEN FKCursor FETCH NEXT FROM FKCursor INTO @KeyName, @TableName

WHILE @@FETCH_STATUS = 0 BEGIN SET @DropSQL = 'ALTER TABLE ' + @TableName SET @DropSQL = @DropSQL + ' DROP CONSTRAINT ' + @KeyName EXECUTE (@DropSQL) FETCH NEXT FROM FKCursor INTO @KeyName, @TableName END

CLOSE FKCursor DEALLOCATE FKCursor  Click Execute Query.</li></ol> </li> Restart IIS. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.</li></ol>

Note If you delete a user from the Web site, and then you use the Server Health Check feature to check server health, the user's information is deleted from the UserInfo table in the database. The user's information is deleted from the UserInfo table even though the user still owns list items and documents. Therefore, when you view documents and list items that are owned by that user on Web pages in the Web site, the name of the user is not listed in the Modified By and Created By fields of the documents and of the list items. Instead, the user ID of the user is listed in the Modified By and Created By fields. This condition does not affect the functionality of the Web site.

<div class="moreinformation_section">

MORE INFORMATION
For more information about how to obtain the latest service pack for SharePoint Team Services, click the following article number to view the article in the Microsoft Knowledge Base:

839025 How to obtain the latest service pack for SharePoint Team Services

For more information about how to configure and how to administer SharePoint Team Services, see the SharePoint Team Services product documentation. To view the SharePoint Team Services product documentation, visit the following Microsoft Web site:

http://www.microsoft.com/resources/documentation/STS/2001/all/proddocs/en-us/default.mspx

Additional query words: sts

Keywords: kberrmsg kbtshoot kbprb KB888843

-

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

© Microsoft Corporation. All rights reserved.