Pos3/5/FNB: Sync Error POS Session: Difference between revisions
no edit summary
(Created page with "<u><b>Question :</b></u> I have some sync error and when I check I get this error. <span style='color:blue'>Error Message: Foreign Key Error (Constraint Name=FK_Pos_Session).</span> File:000319-a.png <u><b>Possible Reason :</b></u> POS Session record is synced to older server database. <u><b>Solution :</b></u> 1a. Login <span style='color:red'>POS</span> > <span style='color:red'>More Function</span> > <span style='color:red'>Configuration Setting</span> > <...") |
No edit summary |
||
Line 18:
1b. Login <span style='color:red'>FnB</span> > <span style='color:red'>More Function</span> > <span style='color:red'>Setting</span> > <span style='color:red'>Configuration Setting</span> > <span style='color:red'>Miscellaneous</span> > <span style='color:red'>SQL Query</span> > Enter <span style='color:red'>Password</span> > <span style='color:red'>OK</span> > <span style='color:red'>Copy the query below and paste onto SQL query windows</span> > <span style='color:red'>Execute</span>.
<span style='color:red'>UPDATE POS SET Sync = 'F' WHERE SyncErrorMessage is not NULL</span>
<span style='color:red'>UPDATE PosSession SET Sync = 'F' WHERE SessionKey IN (SELECT Session FROM POS WHERE Sync = 'F')</span>
Line 24 ⟶ 26:
<span style='color:red'>UPDATE PosSubSession SET Sync = 'F' WHERE SubSessionKey IN (SELECT SubSession FROM POS WHERE Sync = 'F')</span>
| |||
