Analytics Initial ETL failed with error - SQLException: ORA-20002: Errors encountered in the load process for: W_HS_STUDY_ACCESS_SECS (Doc ID 2776920.1)

ODI-1519: Serial step "Full Load (InternalID:2)" failed because child step "Parallel - SDE Stage Full Loads (InternalID:59)" is in error.
ODI-1518: Parallel step "Parallel - SDE Stage Full Loads (InternalID:59)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: SCN_01_15_SDE_STUDY_ACCESS_SEC_DIM_FL (InternalID:69)
ODI-1217: Session SCN_01_15_SDE_STUDY_ACCESS_SEC_DIM_FL (94) fails with return code ODI-1298.
ODI-1226: Step Int_SDE_Study_Access_Sec_Dim_FL_DS_STEP fails after 1 attempt(s).
ODI-1240: Flow Int_SDE_Study_Access_Sec_Dim_FL_DS_STEP fails while performing a Truncate Error Table - End-IKM AN SQL Control Append - SDE Dim FL- operation. This flow loads target table W_HS_STUDY_ACCESS_SECS.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-LS_AN_ArgusAnlaytics_UNIT (120)" is in error.
ODI-1298: Serial task "SERIAL-EU-LS_AN_ArgusAnlaytics_UNIT (120)" failed because child task "Truncate Error Table - End-IKM AN SQL Control Append - SDE Dim FL- (180)" is in error.
ODI-1228: Task Truncate Error Table - End-IKM AN SQL Control Append - SDE Dim FL- fails on the target connection DS_AN_ArgusAnlaytics.
Caused By: java.sql.SQLException: ORA-20002: Errors encountered in the load process for: W_HS_STUDY_ACCESS_SECS. Please check the error table: AN_DWH.EL$_W_HS_STUDY_ACCESS_SECS for more information...
ORA-06512: at line 13

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:214)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:38)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:891)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1835)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1790)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 20002, Position : 0, Sql = declare
eCnt number;
ex exception;
begin
select count(*) into eCnt
from AN_DWH.E$_W_HS_STUDY_ACCESS_SECS;
AN_DWH.opvaUtilCommon.p_Trunc_Table(UPPER('E$_W_HS_STUDY_ACCESS_SECS'));
if nvl(eCnt,0) > 0 and 1 = 1 then
raise ex;
end if;
exception
when ex then
raise_application_error(-20002, 'Errors encountered in the load process for: W_HS_STUDY_ACCESS_SECS. Please check the error table: AN_DWH.EL$_W_HS_STUDY_ACCESS_SECS for more information...' );
end; , OriginalSql = declare
eCnt number;
ex exception;
begin
select count(*) into eCnt
from AN_DWH.E$_W_HS_STUDY_ACCESS_SECS;
AN_DWH.opvaUtilCommon.p_Trunc_Table(UPPER('E$_W_HS_STUDY_ACCESS_SECS'));
if nvl(eCnt,0) > 0 and 1 = 1 then
raise ex;
end if;
exception
when ex then
raise_application_error(-20002, 'Errors encountered in the load process for: W_HS_STUDY_ACCESS_SECS. Please check the error table: AN_DWH.EL$_W_HS_STUDY_ACCESS_SECS for more information...' );
end; , Error Msg = ORA-20002: Errors encountered in the load process for: W_HS_STUDY_ACCESS_SECS. Please check the error table: AN_DWH.EL$_W_HS_STUDY_ACCESS_SECS for more information...
ORA-06512: at line 13

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 36 more