Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. "This location cannot be deleted because it is being used in a renew transactions archive record" when try to delete location in SysAdmin

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Symptoms
    2. Cause
    3. Resolution
    4. Workaround
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    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"

    Location was already removed from all Acq/Cat/Circ policies and any security profiles.

    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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • "Temporarily shelved at" does not appear in WebVoyage when the item's permanent and temporary locations are the same
      • "This location cannot be deleted while it belongs to an acquisitions policy group" when try to delete location in SysAdmin
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved