Can't setup Terminal after DB reset
Case
After a database reset was done (MOB DB was deleted from SQL Management Tool), the POS can't be open.
An error is showing (attached) and the following error appears in the logs:
The error from the logs is 2021-02-23 10:14:24,777, ERROR, MyOrderBox.Core.Impl.Logger, System.Data.SqlServerCe.SqlCeException (0x80004005): Invalid column ID. [ number ]
Troubleshooting steps taken****
The Terminal was deleted from the BO.
The MOB folders on both POS and KDS were deleted from localappdata.
Both POS and KDS were updated to the newest build.
SQL service was restarted.
Solution
The issue occurs in POS in case the the setting Order Step is equal to 0 in BO > Setup > POS > Receipts. Only positive values should be allowed, 0 is invalid value.
After a database reset was done (MOB DB was deleted from SQL Management Tool), the POS can't be open.
An error is showing (attached) and the following error appears in the logs:
The error from the logs is 2021-02-23 10:14:24,777, ERROR, MyOrderBox.Core.Impl.Logger, System.Data.SqlServerCe.SqlCeException (0x80004005): Invalid column ID. [ number ]
Troubleshooting steps taken****
The Terminal was deleted from the BO.
The MOB folders on both POS and KDS were deleted from localappdata.
Both POS and KDS were updated to the newest build.
SQL service was restarted.
Solution
The issue occurs in POS in case the the setting Order Step is equal to 0 in BO > Setup > POS > Receipts. Only positive values should be allowed, 0 is invalid value.
Updated on: 05/06/2023
Thank you!