Pos: Sync Error - Concurrency violation

From AutoCount Resource Center

Question :

I have an outlet failed to sync for few days, when I do manual sync at POS Transaction record it prompts this error?

(Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.)

(Error found while sync Pos from JJ01 to HQ. Concurrency violation: the Update Command affected 0 of the expected 1 records.)

000256-a.png


Possible Reason :

The outlet hardware performance overload; too much transaction needed update flag when doing sync.


Solution :

1. Go to Point of Sale > POS Transaction Viewer > make sure all transaction already sync back to HQ database.

000256-b.png


2. Go back AutoCount POS Sync > select correct profile Name > DB Sync > SQL Query > Yes

000256-c.png


3. Enter Password (please ask from software provider) > OK

000256-d.png


4. Click on drop down button > select correct Terminal

000256-e.png


5. Enter statement Update POS set Sync = 'T' > highlight it > Execute > Yes

000256-f.png


6. Go to do speed sync, done.


By: CK 20211012, Jacky 20211022, P211025 [000256]


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


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