OBIA 11g Execute Load Plan Failed With 'ODI-1519' (Doc ID 1923183.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 to 11.1.1.8.1 [Release 11g]
Information in this document applies to any platform.

Symptoms

After generating and executing a Load Plan in the BIA Configuration Manager, the following errors occur:

ODI-1519
Error Message    
ODI-1519: Serial step "Start Load Plan (InternalID:1500)" failed because child step "Global Variable Refresh (InternalID:2500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:2500)" failed because child step "1 Domain (InternalID:6500)" is in error.
ODI-1519: Serial step "1 Domain (InternalID:6500)" failed because child step "2 Domain SIL (InternalID:164500)" is in error.
ODI-1519: Serial step "2 Domain SIL (InternalID:164500)" failed because child step "3 SIL General Flexfield (InternalID:207500)" is in error.
ODI-1519: Serial step "3 SIL General Flexfield (InternalID:207500)" failed because child step "Initialize Flexfield (InternalID:208500)" is in error.
ODI-1518: Parallel step "Initialize Flexfield (InternalID:208500)" failed; 2 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: Initialize : W_FLEX_COLUMN_G_TL (InternalID:210500), Initialize : W_FLEX_VALUE_SET_G (InternalID:211500)
ODI-1217: Session EXEC_TABLE_MAINT_PROC (134500) fails with return code 7000.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 7
java.lang.Exception: The application script threw an exception: TableException: Custom Exception: Exception occured when trying to establish Target Connection BSF info: Build Table List at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:570)
at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:744)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1068)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:137)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)

Caused by: org.apache.bsf.BSFException: The application script threw an exception: TableException: Custom Exception: Exception occured when trying to establish Target Connection BSF info: Build Table List at line: 0 column: columnNo
at bsh.util.BeanShellBSFEngine.eval(Unknown Source) at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:556)
... 11 more

 

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