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. Record viewable in SQL but not in UTIL F/4

    Record viewable in SQL but not in UTIL F/4

    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:
    We see the following symptoms:

    1) In running p_manage_50: ERROR: unable to retrieve ADM record xxx50-000095980 for BIB record xxx01-000095980

    2) In trying to do "Load ADM" from bib record 95980 (and others in the problem range) in GUI Cataloging, we get the message, "Record does not exist".

    3) ADM record 95980 cannot be viewed in util f/4 ("Error reading doc") -- while it *can* be viewed in SQL (by doing: select * from z00 where z00_doc_number = '000095980';).

    Resolution:
    Though util a/17/14 showed that the z00_id Oracle index was present and valid, we found that doing util a/17/3 to rebuild it *temporarily* corrected the problem. But it came back with different records.

    The solution is to export the z00 with p_file_03, recreate the z00 table, and then reload using p_file_04. There was some problem in the Oracle 8 -> Oracle 9 upgrade of this particular file. (Note: E.L. was not involved in this upgrade, so we can't say for sure. It was an "upgrade in place".)

    [Additional info not directly involved in the solution:] The site had upgraded to Oracle 9 but had not recreated the Oracle indexes. The site had done an upgrade-in-place with the Oracle DBUA (Database Upgrade Utility). It's unclear what this utility says about Oracle index regeneration, but, based on this experience, I suggest that, unless it's very clear that such regeneration is not necessary, you should do it. Oracle index regeneration can be done for an entire ALEPH library at once using util a/17/3 "all".

    Additional Information

    record, viewable, SQL, UTIL F/4


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Record updated by user xxxxx" prevents saving more than once
      • Record was last updated by a higher level cataloger
    • 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