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. Error reading Z100 in usr_library

    Error reading Z100 in usr_library

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1.  
    2. Description
    3. Resolution: 
    4. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local;

     


    Description


    Running 'Create Tar File for ALEPH Published Records (publish-06)' the following error appears:
    Oracle error: update_cursor z100
    ORA-00942: table or view does not exist

    Error reading Z100 in usr_library
    Z100-REC-KEY:
    Wrote Z100 record with rec-key: no_such_symbol


    Resolution: 


    Table z100 must also be defined for the $usr_library in Aleph 19 (and up)

    Definition of z100 for the $usr_library can be done in one of 2 ways:
    1) adding it to the $usr_library $data_root/file_list or
    2) setting the $usr_library $data_root/prof_library file_list_type so that it will be included from the $aleph_root/tab/file_list.USR template.


    Then do dlib $usr_library and run util a/17/1 for z100 to actually create it.

    Also, when the USR and the ADM library are the same, in the XXX50/prof_library file parameter, "file_list_type", should be ADM:


    setenv file_list_type ADM

    In addition to this setting, the variable usr_library in $alephe_root/aleph_start.private should also be ADM.

     

    setenv usr_library <xxx50 ADM library>

     

    (such as "USM50")

    Additional Information

    See also Knowledge Base item clear_vir01 error after v19 Upgrade Express: &quot;Error reading Z100 in usr_library&quot; for a case where the error was occurring in clear_vir01.

     

     

    Category: Background processing


    • Article last edited: 21/March/2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Error printing loan receipt
      • Error running p_publish_06
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Background processing
      3. contype:kba
      4. Dedicated-Direct
      5. Direct
      6. Local
      7. Prod:Aleph
      8. 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