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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.