Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Cannot open GHCQ when large number of heading changes in queue

    • 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