Pos:Sync process stuck at Get All Change Log: Difference between revisions

From AutoCount Resource Center
Content added Content deleted
(Created page with "'''Question:''' Why the process keeps stuck at Get all Change log when I perform speed sync? File:Changelog1.png <u><b>Possible Reason:</b></u> Change log is too big....")
 
No edit summary
 
Line 31: Line 31:


By: Kim Seng 171228, KM 171229, P171229
By: Kim Seng 171228, KM 171229, P171229


{{NavigateForUser}}

Latest revision as of 01:18, 12 January 2018

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



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'




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

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations