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. Web OPAC and GUI Search keyword searches (Find), extremely slow / time out

    Web OPAC and GUI Search keyword searches (Find), extremely slow / time out

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1.  
    •  
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Description:
    Web OPAC and GUI Search keyword searches (Find), are extremely slow and usually time out.

    Resolution:
    The primary tables involved in keyword searching are z95, z97, z98, and z980.
    Checking with util a/17/14, we found that the z98_id Oracle index was not present.

    Running util a/17/2 to rebuild it was unsuccessful because of duplicates:
    CREATE UNIQUE INDEX XXX01.Z98_ID ON XXX01.Z98 (Z98_REC_KEY ASC)
    ERROR at line 1:
    ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


    Running util a/17/18 to delete the duplicates (and create the unique index) was successful. (See article Cannot CREATE UNIQUE INDEX; duplicate keys found; using util a/17/18 **HOW TO** (KB 8192-424) for details on util a/17/18.)

     


    • Article last edited: 22-Mar-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Web OPAC /goto uncertified relocate
      • Web OPAC browsing in MEDIA collection slow
    • Was this article helpful?

    Recommended articles

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