OBIA 11g - ODI-17517: Error during task interpretation and Token Parsing Error

(Doc ID 1617913.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


The following error occurs while running a load in ODI from PeopleSoft HCM 9.1. ODI-17517: Error during task interpretation.

 Task: 23

java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: ``out.print("( /* Subselect from SDE_PSFT_PersistedStage_WorkforceEvent_Headcount. . . . ''

Token Parsing Error: Lexical error at line 20, column 75.  Encountered: "\n" (10), after : "\"\\\\s+$    SQ_HDC,<$ ": <at unknown location>

 BSF info: Generate nested SQL at line: 0 column: columnNo

     at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(

     at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(

     at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(

     at com.sunopsis.dwg.dbobj.SnpSession.treatSession(

     at com.sunopsis.dwg.dbobj.SnpSession.treatSession(

     at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(

     at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(

     at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(


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