Pos:Sync process stuck at Get All Change Log

From AutoCount Resource Center
Jump to navigation Jump to search

Question: Why the process keeps stuck at Get all Change log when I perform speed sync?


Changelog1.png


Possible Reason:

Change log is too big. System takes long time to get all the change log.


Solution:

1. Insert query on outlet database (do it at your own risk) to clear the change log.

AutoCount Accounting Management Studio > Tools > SQL Query

delete from changelog where tablename!='Member' AND changetype!='k'


Changelog2.png



Note: This query is only applicable to Outlet database. Backup your Outlet database before applying this query.


2. Try to perform speed sync again.


By: Kim Seng 171228, KM 171229, P171229



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