July 5, 2018 at 8:07 am
Hello everyone
Who can help me about this error please
Error generation on DB Side : System.Data.SqlClient.SqlException: Table error: table 'TLOG.ITEMS' (ID 494624805).
Data row does not have a matching index row in the index 'IX_StatsItem' (ID 20). Possible missing or invalid keys for the index row matching: at StoreOffice.SQL.Utils.ExecStoredProcedure(String StoredProcedure, String Parametres) at StoreOffice.Closure.BasePOS.PerformEndOfDay()
July 5, 2018 at 8:10 am
Looks like a corrupt index, similar to this https://www.sqlservercentral.com/Forums/Topic1401804-2893-1.aspx
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2018 at 9:44 am
run dbcc to check this table, and really, you ought to run a dbcc checkdb across the entire database.
July 6, 2018 at 3:26 pm
Drop and recreate the index.
July 8, 2018 at 11:39 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply