Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Display of HOL record extremely slow.

    Display of HOL record extremely slow.

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    After upgrading to version 18, the display of HOL records is extremely slow.

    The display of expanded fields (852, 866) from HOL records in the Web Full display is OK, but the display of the OPAC Holdings is extremely slow; as is:
    the display of the HOL record in GUI Cataloging when you click on Edit [HOL] in the Bib record display,
    the display of the HOL record when you connect to the xxx60 library, and
    the display of the tree in the left-hand pane when you display an HOL record. [ <Jerry Specht > ]

    Resolution:
    If all access of the HOL record were slow, that would point to a problem with the xxx60 z00_id Oracle index, but this case where display of the records via expand is OK, while direct access is extremely slow, points to a problem with the xxx60 z103 table. (This is because the bar at the top of the GUI HOL display includes the title, which comes from the bib z13 table.)

    util a/17/14 showed that the xxx60 z103_id and z103_id1 Oracle indexes were OK. Rebuilding these indexes via util a/17/3 did not help.

    Exporting the xxx60 z103 table (using p_file_03) and importing it (using p_file_04) corrected the problem.

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Display of garbage 'Note' in upper pane of course doc
      • Display of ILL Request Bibliographic Info on Separate Lines in Web OPAC
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 17.01
      2. contype:kba
      3. Prod:Aleph
      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