ODI Parse Error "ODI-17810: Error During BeanShell Evaluation" with Double-Quotes Around Column Names (Doc ID 2551361.1)

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

When running an Oracle Data Integrator (ODI) mapping that reads from files, the following error is reported in the operator logs:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
 Task: 50
com.sunopsis.tools.core.exception.SnpsSimpleNLSMessageException: ODI-17810: Error during BeanShell evaluation: BeanShell script error: Parse error at line #, column #. Encountered: ( BSF info: null at line: 0 column: columnNo, Pre-execution code:
  ...
  out.print( (char) 58 + ""column_name"" ) ;

Note that in the example above, the string "column_name" is surrounded by two sets of double-quotes (").

Cause

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