OCDA_INFA_Study_Subject_Dim_SIL_PRG Failed with NOT-CURRENT Error (Doc ID 1343026.1)

Last updated on AUGUST 17, 2011

Applies to:

Oracle Clinical Development Analytics - Version: 2.0 and later   [Release: 2.0 and later ]
Information in this document applies to any platform.

Symptoms

Executing the ETL Programs OCDA_PLS_ETL_WORKFLOW_PRG and it is failing at
"OCDA_INFA_Study_Subject_Dim_SIL_PRG" with the following error:

BACKCHAIN/DoBackChain/Starting b/c with Job=458820001, Program Name=
OCDA_INFA_Study_Subject_Dim_SIL_PRG PRRef=730001/2
BACKCHAIN/DoBackChain/PRRef/Status=1030001_2/CANNOT-BACKCHAIN
(OCDA_INFA_User_Dim_SIL_PRG) does NOT require submission
BACKCHAIN/DoBackChain/Job submitted: 458980001 for the program
OCDA_INFA_Study_Subject_Dim_SDE_OC_PRG
BACKCHAIN/lSubmitJob/*** ERROR at Stage: Creating CDR submission / job for
PRRefID=1420001/3 (OCDA_INFA_Study_Subject_Dim_SDE_SC_PRG) - ORA-20200: ***
ERROR: cdr_exe_owb_execution.startedJob: SQL error: ORA-01403: no data found
ORA-01403: no data found
BACKCHAIN/DoBackChain/*** ERROR at Stage: 1420001_3 is NOT-CURRENT, hence Submit Job
- ORA-20200: *** ERROR: CDR_EXE_BACKCHAIN.lStopProc - *** ERROR at Stage: Creating
CDR submission / job for PRRefID=1420001/3 (OCDA_INFA_Study_Subject_Dim_SDE_SC_PRG) -
ORA-20200: *** ERROR: cdr_exe_owb_execution.startedJob: SQL error: ORA-01403: no data found

ORA-01403: no data found
Execution Status : SETFAILURE :: Job Status: Failure :: 07-08-2011 16:20:07

Error Code: -20200:: Error Description: ORA-20200: *** ERROR:
CDR_EXE_BACKCHAIN.lStopProc - *** ERROR at Stage: 1420001_3 is NOT-CURRENT, hence
Submit Job - ORA-20200: *** ERROR: CDR_EXE_BACKCHAIN.lStopProc - *** ERROR at Stage:
Creating CDR submission / job for PRRefID=1420001/3
(OCDA_INFA_Study_Subject_Dim_SDE_SC_PRG) - ORA-20200: *** ERROR:
cdr_exe_owb_execution.startedJob: SQL error: ORA-01403: no data found

ORA-01403: no data found::8:
Execution Status : SETFAILURE :: Job Status: Failure :: 07-08-2011 16:20:07

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms