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

    ETL not working after upgrade from ARC1 to ARC2

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

    I can see the following error in the arc_01 log in $alephe_scratch:

    BEGIN RUN_PROCESS(7, 4, 5); END;

    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00905: object LONR0.RUN_PROCESS is invalid
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    Whenever ARC_VERSION is being changed, aleph_shutdown and aleph_startup needs to be run.

    The problem was related to the fact that the batch que was not restarted and it continued to point to ARC 1.1 and not ARC 2.0.

    To check the current ARC_VERSION do:

    echo $ARC_VERSION

    This variable should be defined in $alephe_root/aleph_start.

    Additional Information

    ARC ARC2 upgrade ARC1 ETL object RUN_PROCESS is invalid

    • Article last edited: 10/8/2013