ODI-1519: Serial step "Start Load Plan (InternalID:6500)" failed because child step "Global Variable

987994 · Feb 29, 2016 4:10AM

Hello All,

I am using OBIA 11.1.1.10.1

Trying to load Project Analytics related data from EBS 12.1.3 Vision instance through Load Plan in windows environment ,

I am getting below error when I try to load data for the first time (Full Load)

In the error list I can see many parameter has to be set (Don't know where exactly those has to be set)

Path "D:/Oracle/Middleware/instances/instance1/biapps/logs/healthcheck/log" exists & i am able to navigate to the path through command prompt.

After "Generate" step is executed I got below warning

""********WARNING: Variable DIAG_ERR_LOG_ENABLE not Found!!"

Generation status says "Succeeded with warning "

Below is the error obtained after drill down from load plan in "Functional Setup Data Configuration and Load Plan Administration" i,e in ODI console

Let me know what other details to be set up for the successful loading of OBIA 11.1.1.10.1 Project Analytics ,How below error can be solved?

Also saw question posted Load Plan Execution failed which is more of insufficient privilege issue

I too have a readonly user for EBS but don't find anything on privilege issue in the Error listed below

Load Plan Name PA_Full_Laod1_1_20160226_020617

Started By BIAppsSystemUser

Physical Agent OracleDIAgent

Context Global

Start Sunday, February 28, 2016 8:59:41 PM GMT-08:00

End Sunday, February 28, 2016 9:01:01 PM GMT-08:00

Duration 01:20

Execution Status Error

Return Code ODI-1519

Error Message ODI-1519: Serial step "Start Load Plan (InternalID:6500)" failed because child step "Global Variable Refresh (InternalID:7500)" is in error.

ODI-1519: Serial step "Global Variable Refresh (InternalID:7500)" failed because child step "1 Diagnostics Health Check (InternalID:14500)" is in error.

ODI-1519: Serial step "1 Diagnostics Health Check (InternalID:14500)" failed because child step "Case Variable: BIAPPS.DIAG_HEALTHCHECK_RUN_FLAG (InternalID:15500)" is in error.

ODI-1521: Case step "Case Variable: BIAPPS.DIAG_HEALTHCHECK_RUN_FLAG (InternalID:15500)" failed; the selected child "When Value = Y (InternalID:16500)" is in error.

ODI-1520: Case-When/Else step "When Value = Y (InternalID:16500)" failed because child step "rootStep_caseWhen (InternalID:17500)" is in error.

ODI-1519: Serial step "rootStep_caseWhen (InternalID:17500)" failed because child step "LOAD_AND_CONTROL_HEALTHCHECK (InternalID:18500)" is in error.

ODI-1217: Session LOAD_AND_CONTROL_HEALTHCHECK (13500) fails with return code 7000.

ODI-1226: Step Load Diagnostics fails after 1 attempt(s).

ODI-1232: Procedure Load Diagnostics execution fails.

Caused By: org.apache.bsf.BSFException: exception from Jython:

Traceback (most recent call last):

File "<string>", line 12, in <module>

Exception: Unable to create log file. Check if the directory /Oracle/Middleware/instances/instance1/biapps/logs/healthcheck/log exists and the ODI agent has permissions to create files in this directory.

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)

at java.lang.Thread.run(Thread.java:745)

Caused by: Traceback (most recent call last):

File "<string>", line 12, in <module>

Exception: Unable to create log file. Check if the directory /Oracle/Middleware/instances/instance1/biapps/logs/healthcheck/log exists and the ODI agent has permissions to create files in this directory.

at org.python.core.PyException.doRaise(PyException.java:219)

at org.python.core.Py.makeException(Py.java:1166)

at org.python.core.Py.makeException(Py.java:1170)

at org.python.core.Py.makeException(Py.java:1174)

at org.python.pycode._pyx14.f$0(<string>:27)

at org.python.pycode._pyx14.call_function(<string>)

at org.python.core.PyTableCode.call(PyTableCode.java:165)

at org.python.core.PyCode.call(PyCode.java:18)

at org.python.core.Py.runCode(Py.java:1204)

at org.python.core.Py.exec(Py.java:1248)

at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

... 19 more

ODI-1523: Exception handler for step "Global Variable Refresh (InternalID:7500)" failed, because the root exception serial step "Global - Export logs and send notification (InternalID:2500)" is in error.

ODI-1519: Serial step "Global - Export logs and send notification (InternalID:2500)" failed because child step "Serial (InternalID:3500)" is in error.

ODI-1519: Serial step "Serial (InternalID:3500)" failed because child step "Export failed session logs (InternalID:4500)" is in error.

ODI-1217: Session EXPORT_FAILED_SESSION_LOGS (14500) fails with return code 7000.

ODI-1226: Step Export Failed Session Logs fails after 1 attempt(s).

ODI-1232: Procedure Export Failed Session Logs execution fails.

Caused By: java.io.IOException: Cannot create directory

at com.sunopsis.repository.manager.RepositoryManager.logExport(RepositoryManager.java:2706)

at com.sunopsis.repository.manager.RepositoryManager.logExport(RepositoryManager.java:2635)

at com.sunopsis.dwg.tools.ExportLog.actionExecute(ExportLog.java:125)

at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3449)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1510)

at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)

at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)