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. ADM records display in Cataloging navigation pane, but get "Record does not exis

    ADM records display in Cataloging navigation pane, but get "Record does not exis

    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: 16.02

    Description:
    We have several bib records where the navigation pane indicates that there is a ADM record, but when I click on it, I get "Record does not exist." Why?

    Resolution:
    Each bib Z103 with LKR type ADM should have a corresponding ADM Z103 and Z00 record.
    It seems that there was a problem with space in the TS2D tablespace in which the adm record z00 and z103 tables reside at the time these adm records were supposed to have been created.
    The following SQL shows that there are 19 ABC01/XXX50 Z103's which do not have a corresponding XXX50 Z103 and Z00 record:

    SQL-ABC01> select substr (z103_rec_key,1,14) from z103 where z103_rec_key like 'XXX50%' minus select substr (z103_rec_key,1,14) from xxx50.z103;

    Deleting the extraneous Z103 records in SYS01 with SQL corrected the problem.

    Additional Information

    Oracle table space, retrieving records


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ADM record deletion after replication
      • ADM records not visible
    • Was this article helpful?

    Recommended articles

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