Data could not be saved. Cannot insert duplicate key row in object 'dbo.CACHEDDISCOUNTRESULT' - when procesing a transaction with different price types

When trying to process a transaction in daily sales that contains two different tickets you may receive the error: Data could not be saved. Cannot insert duplicate key row in object 'dbo.CACHEDDISCOUNTRESULT' with unique index 'UIX_CACHEDDISCOUNTRESULT_INPUTHASH_LASTUSED'. The duplicate key value is (0x9f1e9127a36e2899bc3122d8e6d401440967a6de
Work around:
  1. Click Tickets > Program search and search for your program
  2. Edit the price types of the program
  3. Change the price type currently used in the transaction for the ticket to a price that is not currently in use and then change it back
    1. Click the drop down arrow next to the price type and click delete
    2. Click the add button and a different price type
    3. Delete that price type and re add the original price type
  4. Refresh Altru and try to process the transaction again

Environment

 Altru Arts & Cultural

Was this article helpful?