Pos: Sync Error - Concurrency violation

From AutoCount Resource Center
Revision as of 10:02, 28 October 2021 by PeterT (talk | contribs) (Created page with "<u><b>Question :</b></u> I have an outlet failed to sync for few days, when I do manual sync at POS Transaction record it prompts this error? (<span style='color:blue'>Concu...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.)

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


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