"ODI-17517: Error During Task Interpretation" Encountered When Using LKM File To Oracle (EXTERNAL TABLE) (Doc ID 1469977.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

Oracle Data Integrator (ODI) encounters an error with LKM File to Oracle (EXTERNAL) when the file uses " as a text delimiter:

ODI-1217: Session XYZ File (99001) fails with return code 7000.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 6
java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: ``out.print("The application script threw an exception: java.lang.StringIndexOutOf . . . '' Token Parsing Error: Lexical error at line 2, column 42. Encountered: "\\" (92), after : "":
BSF info: Create external table at line: 0 column: columnNo
  at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:485)

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