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 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

The following error occurs while running a load in ODI from PeopleSoft HCM 9.1.

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: 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(SnpTaskNameCodeInterpretor.java:570)

     at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:744)

     at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)

     at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

     at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1895)

     at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

     at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

     at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:512)

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