My Oracle Support Banner

"ODI-17517: Error during task interpretation" Signalled At ODI 12.1.3 Mapping Runtime In "Generate TTU Script" Task Of "IKM SQL To Teradata (TTU)" (Doc ID 1984083.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

When executing an Oracle Data Integrator (ODI) 12.1.3 Mapping which populates a Teradata target table with data from an Oracle table including a Timestamp(0) column and using IKM SQL to Teradata (TTU), the following error stack is observed at the 'Generate TTU Script' Task:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 40
org.apache.bsf.BSFException: BeanShell script error: Parse error at line 227, column 10. Encountered: ( BSF info: null at line: 0 column: columnNo
 at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
 at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
 at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:483)
 at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:180)
 at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:80)
 ...

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.