ERP Integrator Process Failure

Issue: For certain JDBC drivers, such as the 10gR2 JDK 1.5- compliant driver, the ERP Integrator ODI processes may fail, and you may encounter this error message:

java.lang.IllegalAccessException: Class org.python.core.PyReflectedFunction can not access a member of class oracle.jdbc.driver.OraclePreparedStatementWrapper with modifiers "public"

Solution: Follow these steps:

  1. Create a file named registry in the ODI_HOME/lib/scripting folder.

  2. Insert this line in the registry file:

    python.security.respectJavaAccessibility = false
  3. Restart the ODI agent.