Select the product you need help with
SharePoint 2010: Missing stored procedure error after installation of SP1Article ID: 2635071 - View products that this article applies to. SYMPTOMSYou have a SharePoint Server 2010 or SharePoint Foundation 2010 environment that has been upgraded to Service Pack 1. The following error may appear in the application event log of one or more SharePoint servers in the farm on a periodic basis: Log Name: Application Source: Microsoft-SharePoint Products-SharePoint Foundation Date: <Date and Time> Event ID: 5586 Task Category: Database Level: Error Keywords: User: Domain\Username Computer: Servername Description: Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below. Could not find stored procedure 'proc_UpdateStatisticsNVP'. <Date and Time>T00:00:13.143: Starting <Date and Time>T00:00:13.143: Dropping automatically created stats on user tables <Date and Time>T00:00:13.143: Updating statistics on user indices <Date and Time>T00:00:13.150: Statistics for dbo.IX_Dependencies_ObjectId are now being updated with default sampling. <Date and Time>T00:00:13.150: Rebuilding <Date and Time>T00:00:13.153: Done <Date and Time>T00:00:13.153: Statistics for dbo.IX_Objects_Version are now being updated with default sampling. [Further details of the entire error text omitted] CAUSEThe SharePoint 2010 Health Analyzer consists of a rule with the Title "Databases used by SharePoint have outdated index statistics". This health rule runs on a daily schedule and checks the SharePoint databases for outdated index statistics. If databases index statistics are found to be outdated, the rule automatically attempts to update the statistics on the databases. The error is generated because the health rule attempts to run 'proc_UpdateStatisticsNVP' stored procedure against the configuration database, however, this stored procedure does not exist in the configuration database. RESOLUTIONThis is a known issue that will be fixed in a future release of the product. The error does not affect the functionality of the product in any way and can be safely ignored. MORE INFORMATIONThe database stored procedure proc_UpdateStatisticsNVP is part of the SharePoint content databases and is called to update the index statistics for the "NameValuePair" database tables. The "NameValuePair" tables only exist in the SharePoint content databases. Other SharePoint databases, including the configuration database do not have the "NameValuePair" database tables. Because the "NameValuePair" tables do not exist in these databases, "proc_UpdateStatisticsNVP" is not needed on these databases. Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.PropertiesArticle ID: 2635071 - Last Review: October 24, 2011 - Revision: 5.0
|  |
Back to the top
