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