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

    Oracle error in ARC ETL log on Aleph production: "Oracle error: io_z900_by_time"

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    Error messages in ARC ETL log file:
    $alephe_scratch/arc_etl.log

    <<
    /SQL procedure successfully completed.

    IN CREATE ARC DELETE TRIGGERS
    1 START READING DELETED REC AT 04:48:18

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

    Cause:
    Configuration of ./alephe/tab/library_relation

    Resolution:
    Remove references to ABC30 library which is not fully defined in the system

    Change relevant lines in ./alephe/tab/library_relation as follows

    ./alephe/tab/library_relation
    ADM ABCL30 ABC50 <<<< remove this line
    HOL ABC30 ABC60 <<<< remove this line

    change
    BIB ABC50 ABC01 ABC30 ABC40
    to
    BIB ABC50 ABC01 ABC40

    change
    BIB ABC60 ABC01 ABC30
    to
    BIB ABC60 ABC01

    Additional Information

    The ETL is looking for all bibliographic libraries related to the ADM library as defined in $alephe_tab/library_relation.
    If this library is not fully set up, this definition causes the error message "Oracle error: io_z900_by_time
    ORA-00942: table or view does not exist"

    Category: ETL (ARC)/ARC

    Subject: ARC


    • Article last edited: 5/5/2014