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. Keyword searches retrieve completely unrelated words

    Keyword searches retrieve completely unrelated words

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    2. Attachment
    • Product: Aleph
    • Product Version: 22
    • Relevant for Installation Type: All

     

    Description:

    Keyword searches retrieve completely unrelated words.  For example, a search on the word “train” displays a “no hits” screen, with words which are supposedly just before and after “train”, but, in this case, are random beginning with  “/e” -- despite the fact that there are records containing the word “train”.

     

    Resolution:

    Util a/17/14 (“Drop & Create Table and Index”)  for the z97 showed that the z97_id (built on the z97_word column) was missing.  An attempt to build it with util a/17/2 (“Create Index”) failed with a duplicate keys error, but util a/17/18 (“Search for Duplicate Keys”) was successful.   See link to article

    “Cannot CREATE UNIQUE INDEX; duplicate keys found; using util a/17/18” below.

     

    [Note: Though it could occur with any bib library, in this case it occurred with v22 usm01 data.]   

     

     And also:  "Searches/results for another user appear on screen"

     

    Additional Information

    Insert additional information content here, if there is no content please delete the header for this section

    Attachment

    If there is an attachment add link to the attachment according to steps below, if there is no content please delete the header for this section

    View article in the Exlibris Knowledge Center
    1. Back to top
      • Keyword searches failing after full Word index
      • Keyword searches take long time then give "Page cannot be displayed"
    • Was this article helpful?

    Recommended articles

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