Technical Teams, Database Administrators, and Product Development
Description of Issue:
Error 21 - (0xC0068021) - Aloha responds with a failed order with this error:
"Error Details: Error adding item '123456-No price altering substitutions/additions' to check with id 22020098 - System.Runtime.InteropServices.COMException (0xC0068021): Exception from HRESULT:
This issue is caused by an item being committed to POS as it is mapped in Olo and the Item Record ID does not actually exist in the POS's Database (in the local itm.dbf). Often times, this can be the memo id that Olo is using.
Confirm that the local POS database does in fact have the mapped record IDs in it. The mapping on the Olo side should match what is in POS.
For anyone reading this article that is not familiar with CFC, this is Configuration Center - NCR's tool for managing the POS database.
- Confirm the mapping is correct in the Olo Company Menu. It is possible that the item ID has a typo.
- Confirm the item is in both CFC>Maintenance>Menu>Items and is in your local %iberdir%\data\itm.dbf (the windows directory that holds the data).
- If the item is in CFC but not in the dbf, there could be a failed data Refresh or hierarchy issue in Aloha.
We often see this error with memo items that are configured in Olo to be used, but are not in the local POS database. Please confirm your memo item is active.