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. Cannot open GHCQ when large number of heading changes in queue

    Cannot open GHCQ when large number of heading changes in queue

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Voyager
    • Product Version: all

    Problem Symptoms:

    * Global Headings Change Queue (GHCQ) has thousands of heading changes
    * Attempt to open GHCQ in Cataloging results in Run-time error 6 : Overflow

    Cause:

    The Cataloging client cannot handle a large volume of headings. This behavior typically occurs as heading changes begin to exceed 20,000, though the exact number has not been determined.

    Resolution:

    1. If already unable to open queue, query for any data to retain. These tables are impacted by GHC:
    *HEADING_CHANGE_QUEUE
    *HEADING_CHANGE
    *HEADING_CHANGE_FIELDS
    HEADING
    AUTH_HEADING
    BIB_HEADING
    SUBDIVISION
    AUTH_SUBDIVISION
    BIB_SUBDIVISION
    *=tables that will be cleared

    2. Open a Support Incident and request that the queue be cleared. If this issue recurs repeatedly, there may be an additional cost associated with this work.

    3. Follow these guidelines for future changes:
    * If do not use GHC, simply delete all headings from GHCQ regularly.
    * If doing a mass import of authority records, import in chunks of 5,000 records or fewer. (See Article #5190 : "How should I BulkImport a large set of records?")
    * Process or clear GHCQ after each chunk of records.

    Category: Cataloging


    • Article last edited: 1/7/2015
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Cannot limit ledger access by Acq Security Profile
      • Cannot relink mfhd if linked to same bib as mfhd linked to PO
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. Cataloging
      2. contype:kba
      3. Prod:Voyager
      4. Type:General
    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