"ODI-1217: Session Load_... fails with return code 7000" When Using LKM SAP BW To Oracle (SQLLDR) To Extract Data From SAP (Doc ID 1515816.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

When executing an ODI Integration Interface  / Mapping that loads data from a SAP InfoCube to an Oracle database table using the following LKM:

   LKM SAP BW to Oracle (SQLLDR)

and setting the Execute on option to the SOURCE schema, the Interface fails with the following message:

ODI-1217: Session Load_......INFOCUBE (389200) fails with return code 7000.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
 Task: 11
java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: ``out.print("BeanShell script error: Sourced file: inline evaluation of: `` if( ty . . . '' Token Parsing Error: Lexical error at line 2, column 25.  Encountered: "\\" (92), after : "":
 BSF info: Extract Data at line: 0 column: columnNo
  at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:485)
  at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:783)
  ...

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