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.
Updated on: 05/06/2023
Thank you!