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

    Can't retrieve records with limits; serial not retrieved via JALL or JKEY

    • Article Type: General
    • Product: Voyager
    • Product Version: 9.2.0

    Problem Symptoms

    • Cannot retrieve a journal via a left-anchored or keyword journal title search
    • Record is cataloged properly (i.e. has a bib level = s)
    • NOTE: Other limit searches are affected, not just journal title

    Cause

    The cache_segs cache_maps is responsible for limits, including the limit of s for serial titles. Occasionally the cache_segs and cache_maps tables get out of synch due to bib editing and updating, particularly when there's a lot of simultaneous cataloging occurring (similar to the keyword indexes).

    This issue is not uncommon when using the -M flag with Bulk Import (allow multiple instances of bulk import).

    Resolution

    This is not a bug; maintenance work needs to be done periodically.

     

    • Voyager Support can run a script to resolve this issue.
    • In Voyager 9.2.0 and higher, this has been automated for anyone to run with an option in the UTIL menu (Index Maintenance > Clear Cache tables).

    Additional Information

    Please contact Voyager Support for assistance.

     

    For more information on using the UTIL menu to clear cache tables, see UTIL Menu documentation.

     


    • Article last edited: 08-Jun-2016
    • Was this article helpful?