Article ID: 2635071 - View products that this article applies to.
You have a Microsoft SharePoint Server 2010 or Microsoft SharePoint Foundation 2010 environment that was upgraded to Service Pack 1 (SP1). The following error may be logged in the Application log of one or more SharePoint servers in the farm on a periodic basis:
[Further details of the entire error text omitted]
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.
The SharePoint 2010 Health Analyzer consists of a health rule that has the title "Databases used by SharePoint have outdated index statistics." This rule runs on a daily schedule and checks the SharePoint databases for outdated index statistics. If database index statistics are outdated, the rule automatically tries to update the database statistics. The error is generated because the health rule tries to run the proc_UpdateStatisticsNVP stored procedure against the configuration database. However, this stored procedure does not exist in the configuration database.
The error does not affect the functionality of the product in any way and can be safely ignored. To resolve this issue, install Service Pack 2 (SP2) for your SharePoint 2010 product. For more information about SP2 for SharePoint 2010 products, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2687453/ )Description of SharePoint Server 2010 SP2
(http://support.microsoft.com/kb/2687464/ )Description of SharePoint Foundation 2010 SP2
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 exist only in the SharePoint content databases. Other SharePoint databases do not have the "NameValuePair" database tables. This includes the configuration database. Because the "NameValuePair" tables do not exist in these databases, proc_UpdateStatisticsNVP is not needed on these databases.
Contact us for more help
Connect with Answer Desk for expert help.