Tuesday 28 April 2015

FDMEE integration with EBS using ODI cosole

COMM_SETUP_SOURCE_SYSTEM Details

Definition

28501
COMM_SETUP_SOURCE_SYSTEM
COMM_SETUP_SOURCE_SYSTEM
001
GLOBAL
OracleDIAgent
SUPERVISOR
MyKeywords

Execution Statistics

Error
Tuesday, 28 April, 2015 10:18:05 PM GMT+05:30
Tuesday, 28 April, 2015 10:18:18 PM GMT+05:30
13
7000
ODI-1217: Session COMM_SETUP_SOURCE_SYSTEM (28501) fails with return code 7000. ODI-1226: Step Set Process Failed fails after 1 attempt(s). ODI-1232: Procedure COMM Update Process execution fails. Caused By: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last): File "<string>", line 3, in <module> RuntimeError 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:48) 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:2913) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931) 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:513) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83) at java.lang.Thread.run(Thread.java:662) Caused by: Traceback (most recent call last): File "<string>", line 3, in <module> RuntimeError. 2) If you get above error while configuring ODI in integration bw FDMEE and EBS.. Make sure that you have given correct source system URL and schema name should be in uppercase letters.