Duplicate Key Row 'lc_call' Error Message

If you are trying to check in a book and get the following error message regarding a "duplicate key row in object 'lc_call', contact Tech Support. Send them the item barcode and the customer's borrower ID and/or barcode. There is no way for you to remove the item from the customer's account from your end. Tech Support has to work with System to remove it.

Troubleshooting Problems With A Request

There are various reasons why Horizon/ValleyCat will not allow a customer to request an item. Many times the message the software returns when it encounters a problem is not clear. Here's a list of reasons why the request did not go through and the resulting message to help you troubleshoot the issue.

1. Customer already has the title requested. The following message appears: "Unable to place request. You have the maximum number of requests allowed for this title".


2. Borrower type of the customer does not allow requests (i.e. btype=FSURF). The following message appears: "This title is not available for requests".

3. Itype of the item does not allow requests. Examples include if a child/teen btype tries to request an R-rated movie (itype=fvir). Or the customer tries to request a reference item (itype=fre). The following message appears: "Your request cannot be filled because no requestable items exist for this title".

4. Status of the item does not allow requests. An item cannot be requested if it has a status of damaged, librarian review, lost, missing, relocation in progress, trace, weeded or withdrawn. The following message appears: "This title is not available for requests".

"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