My Oracle Support Banner

DIH Connector Execution Fails (Doc ID 2759459.1)

Last updated on SEPTEMBER 03, 2023

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.6 and later
Information in this document applies to any platform.


Connector execution fails with below error

ODI-1217: Session FLX_CUST_ACCT_CASA_VAN (11) fails with return code ODI-1298.
ODI-1226: Step FLX Cust Acct Casa Van_100 fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection .
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-VANSIT_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-VANSIT_UNIT (20)" failed because child task "Create work table-LKM SQL to Oracle- (40)" is in error.
Caused By: ODI-17517: Error during task interpretation.
 Task: 40 ODI-17810: Error during BeanShell evaluation: BeanShell script error: Sourced file: inline evaluation of: ``out.print("create table SCHEMA.\"C$_") ; out.print(vSess) ; out.print("0I_3516_F . . . '' : Undefined argument: vSess : at Line: 2 : in file: inline evaluation of: ``out.print("create table SCHEMA.\"C$_") ; out.print(vSess) ; out.print("0I_3516_F . . . '' : ( vSess )
 BSF info: null at line: 0 column: columnNo, Pre-execution code:
out.print("create table SCHEMA.\"C$_") ;
out.print(vSess) ;
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(
at oracle.odi.runtime.agent.execution.SessionTask.createTaskLog(
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentReques

Steps to reproduce
Try to execute connector

Business impact:
unable to execute connectors


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

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