DIH Connector Execution Fails (Doc ID 2759459.1)

Last updated on MARCH 04, 2022

Applies to:

Symptoms

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: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
 Task: 40
com.sunopsis.tools.core.exception.SnpsSimpleNLSMessageException: 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) ;
out.print("0I_3516_FILTER\"\n(\n\tN_PRIN_AFTER_MODIFICATION_AMT\tNUMBER(22,3) NULL,\n\tN_PRIN_BEFORE_MODIFICATION_AMT\tNUMBER(22,3) NULL,\n\tN_PRIN_WRITEOFF_AMT\tNUMBER(22,3) NULL,\n\tN_PRINCIPAL_DRAWN_AMT\tNUMBER(22,3)
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:550)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:183)
at oracle.odi.runtime.agent.execution.interpreter.SessionTaskCodeInterpreter.codeInterpretation(SessionTaskCodeInterpreter.java:80)
at oracle.odi.runtime.agent.execution.SessionTask.createTaskLog(SessionTask.java:351)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:843)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentReques

Steps to reproduce
Try to execute connector

Business impact:
unable to execute connectors

Cause

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