ETL not working after upgrade from ARC1 to ARC2

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

Description:
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

Resolution:
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.