SQL2012 Could not locate Statistics on secondary replica - by AgentJeff

Status : 

 


10
0
Sign in
to vote
ID 780062 Comments
Status Active Workarounds
Type Bug Repros 3
Opened 2/26/2013 2:51:00 PM
Access Restriction Public

Description

When querying a table thru a linked server, got the following error message.

Msg 2767, Level 16, State 1, Procedure sp_table_statistics2_rowset, Line 105
Could not locate statistics '_WA_Sys_00000007_47DBAE45' in the system catalogs.

The database was a secondary replica, primary replica was fine.  Ran dbcc show statistics on secondary replica, that failed to find statistics distribution.  There was an entry in sys.stats on both.   Drop statistics on primary, to resolve.
Sign in to post a comment.
Posted by andrewblack on 4/2/2015 at 1:38 AM
>A real pain!
+1
Posted by Y Wahnon on 7/9/2014 at 11:04 PM
This is happening to us, at least 3 times a week, on different tables in the database. The drop statistics on primary works, but the processes that are meant to run on the secondary via, linked servers are failing! A real pain!