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

    Error: io_z00 - table doesn't exist ... USR00; update_cursor1 z103

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Problem Symptoms:
    In www_server_4500.log the following messages appear:

    WWW-F : ITEM-GLOBAL

    Error: io_z00 - table doesn't exist in database or tab_io_remote for library: USR00
    Error: io_z00 - table doesn't exist in database or tab_io_remote for library: USR00

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

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

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

    Cause:


    Resolution:
    These messages are occurring in connection with the Holdings Detail / Item display. USR00 is the Aleph Demo usr_library. Checking the xxx50 Z103, I don't find any (incorrect) links to USR00.

    We believe that this may be due to the

    DOC-TYPE-ADM=Y

    in the usr00/tab/tab100. (The system thinks it's an ADM library and looks for z00, z103, etc.). In version 20, this is corrected to

    DOC-TYPE-ADM=N

    The xxx00/tab/tab100 should have:

    DOC-TYPE-BIB=N
    DOC-TYPE-HOL=N
    DOC-TYPE-ADM=N
    DOC-TYPE-AUT=N
    DOC-TYPE-ILL=N

    This change should be made in the usr00 tab100 for earlier versions as well.

    Environment
    Aleph 18

    Cause
    Configuration

    Category: Web OPAC (500)

    Subject: Web server (500)

    • Article last edited: 10/8/2013