Friday, February 8, 2013

Error in AX 2012 for Retail POS: 'Cannot select a record in Catch weight setup (PdsCatchWeightItem)'

Error:

In the POS for AX 2012 for Retail, we were seeing the error "Cannot select a record in Catch weight setup (PdsCatchWeightItem). The SQL database has issued an error. Cannot execute the required database operation. The SQL database has issued an error. Cannot execute a data definition language command on (). The SQL database has issued an error." (Figure 1 below). This error can also be something like 'LedgerJournalTrans'

Figure 1 - Error from the POS

Solution:

Those familiar with AX will recognize this error as a table sync error (except usually in AX, not the POS). There are no issues in AX though. Even more curious, we weren't even using catch weights for items. The table is actually synced correctly in AX but it seems that there is something in the RTS or AOS that makes the POS not happy...

While this may not be the solution to all scenarios where this is encountered, the solution to this can be a few things:
  1. sync the table in the first error (PdsCatchWeightItem in this example)
  2. restart the retail transaction service (RTS)
  3. If still needed: restart the AOS where you are seeing this issue. 
Not entirely sure what the root problem was but the above will fix the issue. Hope this helps out!

1 comment: