"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 APRIL 07, 2017

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

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