Description

extract_arc is executing with the error below and failed.

mqbr1@ARC4> BEGIN ETL_DQA.RUN_PROCESS_LOG(2,'F'); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'ETL_DQA.RUN_PROCESS_LOG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

This error can occur, when the ETL_DQA.RUN_PROCESS_LOG is not owned by user MQBR1 in ARC. 

Resolution

1. connect as ssh user crn to your ARC system. 
2. set environment variable 
setenv ARC_LIBS MQBR1 
3. echo $ARC_LIBS 
MQBR1 
4. Import the library 
csh -f $arc_proc/imp_arc_libs 

This will erase the data in the schema but rebuilt the structure and permissions. 

After that, please re-run a FULL ETL. 

• Article last edited: 30-Dec-2016