My Oracle Support Banner

Execution of EDMCS connector with multiple target fails post 811 upgrade (Doc ID 2790925.1)

Last updated on JUNE 27, 2023

Applies to:

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

Symptoms

Problem description:

Execution of EDMCS connector with multiple target fails after 811 upgrade.

Error:
[27-05-21 17:35:54.144][ERROR] [ScenarioExecutor][main]Exception occured while executing connector - EDM COA B Tl Hier Connector
java.lang.Exception: Exception occured while executing connector - EDM COA B Tl Hier Connector
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:23) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofs.reveleus.DIH.model.ScenarioExecutor.main(ScenarioExecutor.java:104) [dih.jar:8.1.1.0.0_10400232459495]
Caused by: java.lang.Exception: Exception occured while executing the connector
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.executeConnector(DIHExecutor.java:75) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:15) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
... 1 more
Caused by: java.lang.Exception: Error occured while executing connector
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.loadData(DIHExecutor.java:129) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.executeConnector(DIHExecutor.java:69) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:15) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
... 1 more
Caused by: java.lang.Exception: Error occured while getting final Query
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenerator.getFinalSelectQueries(QueryGenerator.java:457) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.loadData(DIHExecutor.java:122) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.executeConnector(DIHExecutor.java:69) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:15) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
... 1 more
Caused by: java.lang.Exception: Error occured while getting select clause
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenerator.getSelectClauseWithMappedCols(QueryGenerator.java:142) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenerator.getSelectClause(QueryGenerator.java:112) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenerator.getFinalSelectQueries(QueryGenerator.java:439) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.loadData(DIHExecutor.java:122) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.executeConnector(DIHExecutor.java:69) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:15) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
... 1 more
Caused by: java.lang.NullPointerException
at com.ofss.fsgbu.dihrun.impl.qrygen.InsertQueryGen.getTrgtRealColumnName(InsertQueryGen.java:177) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenerator.getSelectClauseWithMappedCols(QueryGenerator.java:136) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenerator.getSelectClause(QueryGenerator.java:112) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenerator.getFinalSelectQueries(QueryGenerator.java:439) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.loadData(DIHExecutor.java:122) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.executeConnector(DIHExecutor.java:69) ~[dih-exec.jar:8.1.1.0.0_10400232459495]
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:15) ~[dih-exec.jar:8.1.1.0.0_10400232459495]


Steps to reproduce:
Try to execute EDMCS connectors with multiple targets(ADIs) post DIH 811 upgrade

Business impact:
Unable to execute connectors successfully

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
References


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