Pos: Sync error - Unknown Sql Exception…SQL Server detected a logical consistency-based I/O error

From AutoCount Resource Center
Jump to navigation Jump to search

Question: Error message prompted: “Unknown Sql Exception (Number=824, Message=SQL Server detected a logical consistency-based I/O error:incorrect checknum…” when I want to do speed sync?


Logical consistency 1.png



Possible Reason:

The outlet/HQ database is corrupted.


Solution:

Do backup for both the HQ and outlet account book. Try run “DBCC CHECKDB” using SQL Management studio.

If the minimum repair level is “allow_data_loss”, restore the backup file for HQ/Outlet. If you don’t have any backup, you have to create a new account book and re-setup the new account book.

Continue to perform sync after above action is performed.


Note: Please refer to below link on how to perform DBCC.

How to perform DBCC


Remark: Please contact your software dealer in case you are unsure on how to perform DBCC.



By: Michelle 180209, KM 180328, P180403




Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations