My Oracle Support Banner

ODI 11g Data Lineage Load Plan Failing with "AttributeError: 'NoneType' object has no attribute 'group'" (Doc ID 2304033.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


When executing a Data Lineage process in an Oracle Data Integrator (ODI) 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(
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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