My Oracle Support Banner

DIH Connector Execution Issue Post Upgrade to 812 (Doc ID 3012963.1)

Last updated on APRIL 01, 2024

Applies to:

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

Symptoms

 On Oracle Financial Services Data Integration Hub (DIH) 8.1.2, Interfaces ALM, FTP, PFT:

When executing a DIH connector in OFSAA UAT Environment, the following error is output to the log:

ERROR
-----------------------
][ERROR] [ScenarioExecutor][main]ODI-15405: Scenario generation exception: com.sunopsis.dwg.SQLWorkReposException
ORA-00001: unique constraint (***) violated
 

Steps:

--------------------

 The issue can be reproduced at will by executing the Connector.


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot verify the DIH setup in the UAT environment so it can be migrated to production.

Changes

 Testing Connector execution for the first time after upgrade to 812.

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.