ALWAYSON has occurred 2 times, logged:
DBCC execution is complete. If DBCC outputs an error message, contact your system administrator.
Msg 2767, Level 16, State 1, procedure Sp_table_statistics2_rowset, line 105th
Statistics ' _wa_sys_0000001c_090a5324 ' cannot be found in the system directory.
DBCC execution is complete. If DBCC outputs an error message, contact your system administrator.
Query methods such as:
Temporary solution:
Execution on the main library:
Drop Statistics table_name._wa_sys_0000001c_090a5324
or linkedserver use OpenQuery to query:
SELECT * FROM OPENQUERY (srv_lnk, ' select * FROM [databasename].[ DBO]. [table_name] ')
Reference:
https://feedback.azure.com/forums/908035-sql-server/suggestions/32908315- Sql2012-could-not-locate-statistics-on-secondary-r
http://jasonbrimhall.info/2017/10/17/linked-servers-and-stats/
SQL AlwaysOn Secondary Contact query statistics "Missing" causes query to fail