PLS-00201: identifier 'ETL DQA.RUN PROCESS LOG' must be declared
- Product: ARC
- Product Version: All version
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
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