• 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