java.lang.Exception: BeanShell Script Error: Sourced File: Inline Evaluation Of: `` // Normal Load Type Loads Data Via Agent To C$ Table Ff (loadType.equals("NORMA . . . '' Error Occurs when Executing Custom ODI Interface (Doc ID 2444329.1)

Last updated on APRIL 28, 2023

Applies to:

Symptoms

On Oracle Data Integrator (ODI) 11.1.1.9.0, when trying to execute a customized interface from a Business Intelligence Applications (BIAPPS) Out-of-the-box (OOTB) mapping, the following error may occur:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 9
java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: `` // Normal load type loads data via agent to C$ Table if (loadType.equals("NORMA . . . '' : Undefined argument: createFlexColList  : at Line: 6 : in file: inline evaluation of: `` // Normal load type loads data via agent to C$ Table if (loadType.equals("NORMA . . . '' : ( createFlexColList )
BSF info: Create work object 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 oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:380)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:312)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:304)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:874)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)
  at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.bsf.BSFException: BeanShell script error: Sourced file: inline evaluation of: `` // Normal load type loads data via agent to C$ Table if (loadType.equals("NORMA . . . '' : Undefined argument: createFlexColList  : at Line: 6 : in file: inline evaluation of: `` // Normal load type loads data via agent to C$ Table if (loadType.equals("NORMA . . . '' : ( createFlexColList )
BSF info: Create work object at line: 0 column: columnNo
  at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
  at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
  at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:556)
  ... 11 more

Text: <$ // Normal load type loads data via agent to C$ Table
if (loadType.equals("NORMAL")) {  
$>
create table <Schema_Name>.C$_<$=Y$>_0
(
<TABLE_INFORMATION>
)
NOLOGGING

<$ // DBLink load type loads data via source view across DB Link referenced by C$ Synonym
} else if (loadType.equals("DBLINK")) {
$>  
/* DB link option chosen, creating synonym referencing remote view */  
create synonym <Schema_Name>.C$_<$=Y$>_0
for SYSADM.C$_<$=Y$>_0@.WORLD@DSN_#BIAPPS.DATASOURCE_NUM_ID

<$ // SDS load type loads data via C$ view repointing at source tables in SDS schema
} else { $>
/* SDS enabled, creating view referencing source tables in SDS schema */
create or replace view  <Schema_Name>.C$_<$=Y$>_0 as

select <$=hintstr$>
DISTINCT
<TABLE_INFORMATION>
from <$=sdsSchemaName$>.<Table_Name> <Alias>
where (1=1)
 
<$ } $>.
  at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:764)
  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:380)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:312)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:304)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:874)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)
  at java.lang.Thread.run(Thread.java:745)

Changes

1. The original BIAPPS OOTB interface was duplicated via ODI Studio.
2. Next, the source table for the interface was modified.

Cause