My Oracle Support Banner

DIH Connector Task Failing With ORA-00918: column ambiguously defined Errors (Doc ID 2987155.1)

Last updated on NOVEMBER 16, 2023

Applies to:

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

Symptoms

On DIH 8.1.1.1, connector task is failing with the following error in the batch task log file:

ERROR

[09-11-23 19:37:09.518][ERROR] [ScenarioExecutor][main]Exception occured while executing connector - ARE JRNL CNTL
java.lang.Exception: Exception occured while executing connector - ARE JRNL CNTL
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:23) ~[dih-exec.jar:8.1.1.1.0_10401241287277]
at com.ofs.reveleus.DIH.model.ScenarioExecutor.main(ScenarioExecutor.java:104) [dih.jar:8.1.1.1.0_10401241287277]
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.1.0_10401241287277]
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:15) ~[dih-exec.jar:8.1.1.1.0_10401241287277]
... 1 more
Caused by: java.lang.Exception: Error occured while getting query generator
at com.ofss.fsgbu.dihrun.impl.qrygen.QueryGenProvider.getQueryGenerator(QueryGenProvider.java:30) ~[dih-exec.jar:8.1.1.1.0_10401241287277]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.getQueryGenerator(DIHExecutor.java:108) ~[dih-exec.jar:8.1.1.1.0_10401241287277]
at com.ofss.fsgbu.dihrun.impl.DIHExecutor.executeConnector(DIHExecutor.java:64) ~[dih-exec.jar:8.1.1.1.0_10401241287277]
at com.ofss.fsgbu.dihrun.impl.IConExecutable.execute(IConExecutable.java:15) ~[dih-exec.jar:8.1.1.1.0_10401241287277]
... 1 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:12.1.0.1.0]

Changes

Recently applied Oracle Database <Patch 35279794>.

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
References


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