My Oracle Support Banner

Issue In DIH Execution (Doc ID 2684876.1)

Last updated on MAY 21, 2023

Applies to:

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

Symptoms

DIH Connector execution is getting failed with below error

DIH.log
-----------------------
[16-04-20 08:25:40.658][INFO ] [ExecutionHistory][loadOdiScenarioReport]----------------------------------
[16-04-20 08:25:40.658][INFO ] [ExecutionHistory][loadOdiScenarioReport]Failed Step number -[10]
[16-04-20 08:25:40.658][INFO ] [ExecutionHistory][loadOdiScenarioReport]Failed Step Name -[SERIAL - MAP_MAIN - null]
[16-04-20 08:25:40.658][INFO ] [ExecutionHistory][loadOdiScenarioReport] Source Failed Command -
null
[16-04-20 08:25:40.658][INFO ] [ExecutionHistory][loadOdiScenarioReport] Target Failed Command -
null
[16-04-20 08:25:40.658][INFO ] [ScenarioExecutor$1][write] Error msg -
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-FSDFINFO_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-FSDFINFO_UNIT (20)" failed because child task "Load data-LKM SQL to Oracle- (50)" is in error.
ODI-1228: Task Load data-LKM SQL to Oracle- fails on the target connection EDS_FAH_SRC_OFSA.
Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 23



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


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