My Oracle Support Banner

Connector execution failure due to error 'ODI-17506: Variable has no value' (Doc ID 2678292.1)

Last updated on FEBRUARY 27, 2022

Applies to:

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


On : 8.0.7 version, Metadata_OFSS

When attempting to execute DIH connector, the following error occurs.


Session CONNECTOR(1006) fails with return code ODI-1298.[[
ODI-1217: Session CONNECTOR (1006) fails with return code ODI-1298.
ODI-1226: Step CONNECTOR_100 fails after 1 attempt(s).
ODI-1240: Flow CONNECTOR fails while performing a Insert flow into I$ table-IKM Oracle Insert Only- operation. This flow loads target table I_EDD_XXX.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-EDS_SCUSA_FAH_STG_UNIT (110)" is in error.
ODI-1298: Serial task "SERIAL-EU-EDS_XXXX (110)" failed because child task "Insert flow into I$ table-IKM Oracle Insert Only- (160)" is in error.
Caused By: oracle.odi.core.exception.OdiRuntimeException: java.lang.Exception: ODI-17506: Variable has no value: ODI_POC.RUNTIME_PARAM_BATCHID
at oracle.odi.query.VariableDwgBridgeImpl.getValue(

The issue can be reproduced at will with the following steps:
1. Try executing connector

The issue has the following business impact:
Due to this issue, users cannot successfully execute connector.


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.