DIH Connector Execution Fails
(Doc ID 2759459.1)
Last updated on MARCH 04, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.0.6 and laterInformation in this document applies to any platform.
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
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 |
Cause |
Solution |