Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
SharePoint 2010: Missing stored procedure error after installation of SP1
Article ID: 2635071 - View products that this article applies to.
You 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
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]
The 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.
This 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.
The 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.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.