Pos3/5/FNB: Sync Error POS Session

From AutoCount Resource Center

Question :

I have some sync error and when I check I get this error.

Error Message: Foreign Key Error (Constraint Name=FK_Pos_Session).

000319-a.png


Possible Reason :

POS Session record is synced to older server database.


Solution :

1a. Login POS > More Function > Configuration Setting > Miscellaneous > SQL Query > Enter Password > OK > Copy the query below and paste onto SQL query windows > Execute.

1b. Login FnB > More Function > Setting > Configuration Setting > Miscellaneous > SQL Query > Enter Password > OK > Copy the query below and paste onto SQL query windows > Execute.

UPDATE POS SET Sync = 'F' WHERE SyncErrorMessage is not NULL

UPDATE PosSession SET Sync = 'F' WHERE SessionKey IN (SELECT Session FROM POS WHERE Sync = 'F')

000319-b.png


3.Erase previous query, copy the query below and paste onto SQL query windows then click on Execute.

UPDATE PosSubSession SET Sync = 'F' WHERE SubSessionKey IN (SELECT SubSession FROM POS WHERE Sync = 'F')

000319-c.png


3.Perfom speed sync on outlet system.

PS: If you are not confident in doing so, you may call our support or your dealer to help you with it.


By: CK 20220404, Jacky 220422, P220425 [000319]


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