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 not visible

    ADM records not visible

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

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

     

    Description: 
    We have discovered a problem with records in the Depository ADM that may have resulted from the creation of a separate administrative unit for the Depository. We have identified over 8,000 records in the Depository ADM that do not have visible ADM records, although they do have item records linked to a Depository HOL record. 

     

    Resolution: 
    abc01 bib 4862581 is supposed to be linked to dep50 ADM record 82103. Using util f/3/12, we see that there is a link in dep50: 

    ENTER HOME LIBRARY : dep50 
    ENTER DOC-NUMBER : 82103 
    ABC01 004862581 ADM 
    END 

    and likewise using util f/4: 

    ENTER DOC NUMBER : 82103 
    CAT L $$c20080104$$lDEP50$$h1624 
    001 L $$a000082103 
    LKR L $$aADM$$b004862581$$lABC01 

    but the link to the dep50 record is missing in abc01: 

    ENTER HOME LIBRARY : abc01 
    ENTER DOC-NUMBER : 4862581 
    ABC60 004064560 HOL 
    END 


    I don't know how this happened, but it can be corrected by copying the missing z103 links from dep50 to abc01. The following SQL can be used: 

    abc01@ALEPH0> insert into z103 select * from DEP50.Z103 where Z103_REC_KEY_1 like 'ABC01%' minus select * from z103; 


    The site wrote: 

    What we'd like to do is import this file to ABC50 as bill_temp3 (with the 13 char field z103_target) and use the following SQL: 

    insert into abc01.z103 
    select z.* 
    from dep50.z103 z, bill_temp3 
    where substr(z103_rec_key_1,1,13) = Z103_TARGET 
    minus 
    select * from abc01.z103; 

    One of the above SQL statements was used to successfully update the abc01 z103. 

     


    • Article last edited: 12-Mar-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ADM records display in Cataloging navigation pane, but get "Record does not exis
      • ADM50/tab100 - BARCODE-DELETE-SPACES
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    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