ODI 11g Data Lineage Load Plan Failing with "AttributeError: 'NoneType' object has no attribute 'group'"

(Doc ID 2304033.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When executing a Data Lineage process in an Oracle Data Integrator (ODI) 11.1.1.7 environment, it runs for a few minutes but then it fails with the following error message:

ODI-1217: Session MYSESSION (176464750) fails with return code 7000.
ODI-1226: Step Parse SQL fails after 1 attempt(s).
ODI-1232: Procedure Parse SQL execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "", line 1, in
File "", line 56, in parse_sql
File "", line 22, in parse_sql_query
AttributeError: 'NoneType' object has no attribute 'group'
  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)
  ...

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