ORA-00942: table or view does not exist NO_PROCESS_DETAILS_LINES
- 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