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. create_z127: "Error writing to Z100 in:USR00"

    create_z127: "Error writing to Z100 in:USR00"

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    In the "POST UPGRADE ACTIONS IN THE COURSE READING LIBRARY" document I am at step 4 - running create_z127, but I have gotten errors (see below).

    Not sure if this is related to the z100 errors I am getting when running clear_vir01 (see KB 16384-3313).


    Oracle error: io_z100_write
    ORA-00942: table or view does not exist

    Error writing to Z100 in:USR00
    Info: Empty table /tmp/utf_files/exlibris/aleph/u20_1/alephe/error_eng/p_file_04
    Info: Empty table /tmp/utf_files/exlibris/aleph/u20_1/alephe/error_eng/p_global
    creating utf version for file: /exlibris/aleph/a20_1/aleph/error_eng/p_file_04
    ...
    ...
    Param Errors Found:
    F01: Invalid or missing Oracle table name

    Oracle error: update_cursor z100
    ORA-00942: table or view does not exist

    Error reading Z100 in usr_library
    Z100-REC-KEY:000000004

    Oracle error: update_cursor z100
    ORA-00942: table or view does not exist

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

    Oracle error: update_cursor z100
    ORA-00942: table or view does not exist

    Error reading Z100 in usr_library
    end
    Param Initialization Failure, Exiting !!!
    --------------------------------------------------------------------------------

    Our $usr_library is ABC50

    z100 is defined in abc50/file_list (see entries below) but is not defined in any other file_list. Should it be?
    USR00 is a demo library.

    u20_1/abc50/file_list:TAB z100 30M 0K TS2D
    u20_1/abc50/file_list:IND z100_id 2M 0K TS2X
    u20_1/abc50/file_list:IND z100_id1 2M 0K TS2X

    Resolution:
    [From site:] The addition of z100 in usr00 seems to have solved the problem - create_z127 now runs without errors, and I was able to proceed with the rest of the course reserves set up steps.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Create Z00_ID: "such column list already indexed"
      • Creating a browse index for call numbers in XXX30 library
    • Was this article helpful?

    Recommended articles

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