"This location cannot be deleted because it is being used in a renew transactions archive record" when try to delete location in SysAdmin

Symptoms

System Administration > System > Locations > highlight location > Click Delete: "This location cannot be deleted because it is being used in a renew transactions archive record"

Cause

Location is in the renew_trans_archive table.

Cause 1:  This is the result of an old software bug where item locations are incorrectly stored as the renew_location in the renew_trans_archive table instead of the OPAC Circulation Desk location for renewals made through the OPAC; these rows will also have a null renew_oper_id.

Cause 2:  This location was a Circulation Happening Location and renewals occurred there naturally (not caused by the software bug; the renew_oper_id will not be null).  This is is normal behavior for Voyager and the location cannot be deleted.

Resolution

Open a Case with Voyager Support to determine if this bug is the cause of the problem.  If determined to be Cause 1, Support may be able to update the problem data in question.  If determined to be Cause 2, proceed to the Workaround below.

Workaround

Instead of deleting locations in Voyager you can remove all bib records, add a zzz to the front of the location name so that it sorts to the bottom of any list, and remove it from client Policy Definitions and Security Profiles.  Operators will no longer be able to use the location in question in new data.

• Article last edited: 19-Oct-2020