My Oracle Support Banner

DIH8111: CONNECTOR WITH 10 OR MORE ALIASES ON MULTIPLE SOURCE TYPE EXECUTION FAILURE (Doc ID 2856064.1)

Last updated on MARCH 22, 2022

Applies to:

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

Symptoms

on DIH 8.1.1.1

Define a connector with more than 10 aliases of an EDD and having multiple source types.


Connector Execution fails with the below error:
Caused by: oracle.odi.domain.mapping.exception.MapPhysicalException: ODI-16171: KM LKM MultiFiles to Oracle (SQLLDR) is not valid for physical node A10_AP. The default KM is LKM Oracle to Oracle Pull (DB Link).
For one of the Oracle type EDD alias , wrong LKM is getting assigned during publish. Instead of LKM SQL to Oracle it is getting assigned to LKM MultiFiles to Oracle and hence the publish is getting failed.
Issue started after there was architectural change at TD bank to move few tables out from atomic schema to a different schema. prior to this change Connector was getting published successfully.

Changes

 Post defining a new connector with more than 10 aliases and with multiple source types.

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
Changes
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.