Reverse Engineer of BAM Into ODI Fails With Return Code 7000 in ODI 11g (Doc ID 2417358.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

The Oracle SOA Suite documentation contains steps on integrating with Oracle Data Integrator (ODI). When performing section 57.5 (Reverse Engineering the Oracle BAM Schema), it fails with a return code of 7000 and the following error in the Studio log:

org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 40, in <module>
File "<string>", line 66, in __init__
  at oracle.bam.enterpriselink.BAMJdbcConnection.<init>(BAMJdbcConnection.java:346)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:86)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:58)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:542)
  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)

java.lang.Exception: java.lang.Exception: Unable to load BAM configuration:
  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)
  ...
Caused by: Traceback (most recent call last):
File "<string>", line 40, in <module>
File "<string>", line 66, in __init__
  at oracle.bam.enterpriselink.BAMJdbcConnection.<init>(BAMJdbcConnection.java:346)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:86)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:58)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:542)
  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)

java.lang.Exception: java.lang.Exception: Unable to load BAM configuration:
  at org.python.core.PyException.fillInStackTrace(PyException.java:70)
  at java.lang.Throwable.<init>(Throwable.java:67)
  at org.python.core.PyException.<init>(PyException.java:46)
  at org.python.core.PyException.<init>(PyException.java:43)
  at org.python.core.Py.JavaError(Py.java:455)
  at org.python.core.Py.JavaError(Py.java:448)
  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:173)
  ...
Caused by: java.lang.Exception: Unable to load BAM configuration:
  at oracle.bam.enterpriselink.BAMJdbcConnection.<init>(BAMJdbcConnection.java:346)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:86)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:58)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:542)
  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)
... 49 more
Caused by: java.io.FileNotFoundException: Cannot find BAMODIConfig.xml
  at oracle.bam.enterpriselink.BAMJdbcConnection.<init>(BAMJdbcConnection.java:341)
... 54 more

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.