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

    ORA-00942: table or view does not exist NO_PROCESS_DETAILS_LINES

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

    Description:
    Problem Description:

    TABLE_NAME in USER_TABLES for usmr0 is:
    PRC_PROCESS_DETAILS
    p_arc_01 contains three references to:
    $arc_user.prc_process_detail
    Note the lack of the ‘s’ in the table name in p_arc_01

    Actual Results:
    Running p_arc_01 results in the error messages:

    PROCESS_CODE TASK_CODE START_DATE END_DATE ERROR_DESC
    select * from USMR0.prc_process_detail where ERROR_DESC <> ' ' and process_code = (select max(process_code) from USMR0.prc_process_detail)
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist
    NO_PROCESS_DETAILS_LINES
    select count (*) from USMR0.prc_process_detail where process_code = (select max(process_code)from USMR0.prc_process_detail)
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    Expected Results: p_arc_01 would run without producing errors

    Resolution:
    There is now an ARC_VERSION variable in aleph_start.

    setenv ARC_VERSION 2.0

    In order to have the new settings in the next ETL run, please restart the job_daemon and batch_que (for all the ADMs) processes.

    • Article last edited: 10/8/2013