Wednesday, April 15, 2009

"Attempted to Insert Duplicate Row" Error Message

You may receive the following error message when you are updating a collection code:

Attempted to insert a duplicate row. Attempt to insert duplicate key row in object 'dewey_call' with unique index 'dewey_call_item_index' Comand has been aborted.

If you receive this message, email the barcode of each item to Danielle Haas (Jurisdiction System Administrator) and mention the error message. She will run these items through a software routine to clear up the problem. You will be notified when that process has been completed and Horizon will then let you change the collection code. Unfortunately, we are not sure why this happens, only the workaround to fix it.

rev. 6/2017