Home Dashboard Directory Help
Search

SQL2012 Could not locate Statistics on secondary replica by AgentJeff


Status: 

Active


3
0
Sign in
to vote
Type: Bug
ID: 780062
Opened: 2/26/2013 2:51:00 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
Sign in to post a comment.
Sign in to post a workaround.