My Oracle Support Banner

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 SEPTEMBER 13, 2018

Applies to:

Oracle Data Integrator - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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