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 laterInformation 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 |