A KB article I really don’t like.

On November 12, 2011, in news, by

SharePoint 2010: Missing stored procedure error after installation of SP1:
http://support.microsoft.com/kb/2635071

I really don’t like that KB article. 

The error that has been seen on some SharePoints post sp1 is this:

SharePoint Foundataion 5586

Event Details:    

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below. Could not find stored procedure ”proc_UpdateStatisticsNVP”. 2011-10-18T00:00:05.957: Starting 2011-10-18T00:00:05.957: Dropping automatically created stats on user tables 2011-10-18T00:00:05.957: Updating statistics on user indices 2011-10-18T00:00:05.967: Statistics for dbo.IX_Dependencies_ObjectId are now being updated with default sampling. 2011-10-18T00:00:05.967: Rebuilding 2011-10-18T00:00:06.067: Done 2011-10-18T00:00:06.067: Statistics for dbo.IX_Objects_Version are now being updated with default sampling. 2011-10-18T00:00:06.067: Rebuilding 2011-10-18T00:00:06.120: Done 2011-10-18T00:00:06.120: Statistics for dbo.PK_Objects are now being updated with default sampling. 2011-10-18T00:00:06.120: Rebuilding 2011-10-18T00:00:06.190: Done 2011-10-18T00:00:06.190: Statistics for dbo.IX_Objects_ClassId_ParentId_Name are now being updated with default sampling. 2011-10-18T00:00:06.190: Rebuilding 2011-10-18T00:00:06.510: Done 2011-10-18T00:00:06.510: Statistics for dbo.IX_Objects_Version are now being updated with default sampling. 2011-10-18T00:00:06.510: Rebuilding 2011-10-18T00:00:06.570: Done 2011-10-18T00:00:06.570: Statistics for dbo.PK_Objects are now being updated with default sampling. 2011-10-18T00:00:06.570: Rebuilding 2011-10-18T00:00:06.660: Done 2011-10-18T00:00:06.660: Statistics for dbo.IX_Objects_ClassId_ParentId_Name are now being updated with default sampling. 2011-10-18T00:00:06.660: Rebuilding 2011-10-18T00:00:06.697: Done 2011-10-18T00:00:06.697: Statistics for dbo.IX_Objects_Version are now being updated with default sampling. 2011-10-18T00:00:06.697: Rebuilding 2011-10-18T00:00:06.747: Done 2011-10-18T00:00:06.747: Statistics for dbo.PK_Objects are now being updated with default sampling. 2011-10-18T00:00:06.747: Rebuilding 2011-10-18T00:00:06.813: Done 2011-10-18T00:00:06.813: Statistics for dbo.IX_Objects_ClassId_ParentId_Name are now being updated with default sampling. 2011-10-18T00:00:06.813: Rebuilding 2011-10-18T00:00:06.970: Done 2011-10-18T00:00:06.970: Statistics for dbo.IX_Tombstones_Version are now being updated with default sampling. 2011-10-18T00:00:06.970: Rebuilding 2011-10-18T00:00:07.037: Done 2011-10-18T00:00:07.037: Statistics for dbo.PK_Tombstones are now being updated with default sampling. 2011-10-18T00:00:07.037: Rebuilding 2011-10-18T00:00:07.093: Done 2011-10-18T00:00:07.097: Statistics for dbo.IX_Tombstones_Version are now being updated with default sampling. 2011-10-18T00:00:07.097: Rebuilding 2011-10-18T00:00:07.193: Done 2011-10-18T00:00:07.193: Statistics for dbo.PK_Tombstones are now being updated with default sampling. 2011-10-18T00:00:07.193: Rebuilding 2011-10-18T00:00:07.483: Done 2011-10-18T00:00:07.483: Statistics for dbo.PK_LastUpdate are now being updated with default sampling. 2011-10-18T00:00:07.483: Rebuilding 2011-10-18T00:00:07.543: Done 2011-10-18T00:00:07.543: Statistics for dbo.IX_ServerVersionInformation_ServerId_Product_PatchableUnit_PatchName are now being updated with default sampling. 2011-10-18T00:00:07.543: Rebuilding 2011-10-18T00:00:07.577: Done 2011-10-18T00:00:07.577: Statistics for dbo.IX_TimerTargetInstances_JobId_TargetInstanceId are now being updated with default sampling. 2011-10-18T00:00:07.577: Rebuilding 2011-10-18T00:00:07.610: Done 2011-10-18T00:00:07.610: Statistics for dbo.IX_TimerLocks_JobId are now being updated with default sampling. 2011-10-18T00:00:07.610: Rebuilding 2011-10-18T00:00:07.640: Done 2011-10-18T00:00:07.640: Statistics for dbo.IX_TimerLocks_LockedByServerId are now being updated with default sampling. 2011-10-18T00:00:07.640: Rebuilding 2011-10-18T00:00:07.673: Done 2011-10-18T00:00:07.673: Statistics for dbo.IX_TimerLocks_JobId are now being updated with default sampling. 2011-10-18T00:00:07.673: Rebuilding 2011-10-18T00:00:07.707: Done 2011-10-18T00:00:07.707: Statistics for dbo.IX_TimerLocks_LockedByServerId ar

Nice huh.  And so far the official resolution is “don’t worry we’ll fix it sometime in the future”.

“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. “

Nice.

Not.

Another potential ignore this error.

One I don’t like to hear that as a resolution.

 

One Response to A KB article I really don’t like.