Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    create_z127: "Error writing to Z100 in:USR00"

    • 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