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. No z00r records for certain bib records

    No z00r records for certain bib records

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    Though most of our xxx01 bib records have z00r entries, some records, as shown by the following SQL, do not. 

      SQL> select z00_doc_number from z00 minus select z00r_doc_number from z00r;

    Why might this be?

    Resolution

    One cause can be that the bib record is logically deleted (that is, it has a "DEL Y" field).  *Usually* what happens in the case of logical deletion is that the z00r has the same fields as the bib stub record (that is, LDR, 008, CAT, etc.), but it seems that in some cases the z00r's are not written.  (Since the record is deleted, this shouldn't be an issue.)

    But we have found that there are other cases where the the z00r's are missing even though the bib record has no "DEL Y" field.  The following SQL can be used to locate such cases:
     
    SQL> select z00_doc_number from z00 minus select z00r_doc_number from z00r minus select z13_rec_key from z13 where z13_title is not null;

    In a previous case we found that resending the (non-deleted) records to the server resulted in the expected z00r entries being generated.  They created a file like this:

       000123456ABC01
       000234567ABC01
       <etc.>

    which they used as input to the manage-40 Service, which generated z07's which were processed by ue_01, generating proper index entries, including the z00r.
     

     

     


    • Article last edited: 1-Nov-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • No year in date on email message header
      • No Z01s after running p_manage_17; Error on table UCD01.Z01, column Z01_HASH
    • Was this article helpful?

    Recommended articles

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