My Oracle Support Banner

DIH Connector Getting Failed When LKM exceeding 30 characters (Doc ID 2730786.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

Connector is Getting failed when Creating the EDD with more than 26 characters by using the control option.
Observed the below error in Odiagent.log as well as ODI.
ODI-1228:Task insert flow into I$ Table-IKM Oracle Insert only-fails on the target connection OFSADOM
Caused By: Java.Sql.SQLException: ORA-29913error in Executing ODCIEXTTABLEOPEN callout
ORA-29400: data Cartridge Error
KUP-04109:Specified path Of Directory Object “EDD NAME” is Invalid
java.Sql.SQLSyntexErrorException: java.Sql.SQLSyntexErrorException:java.Sql.SQLSyntexErrorException:ORS00972:identifier is too long


Steps To Reproduce:
1. Login to OFSAA
2. Navigate to DIH Application
3. Create EDS with File type
4. Create EDD (Enter the EDD name more 26 characters) by using the Control option with external file
5. Create Connector and execute the same 

 

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.