My Oracle Support Banner

ADI refresh fails with Error occured while updating connector tables (Doc ID 2624057.1)

Last updated on DECEMBER 30, 2019

Applies to:

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

Symptoms

On : 8.0.7 version, ADI Refresh_OFSS

When attempting to Perform ADI refresh the following error occurs.

ERROR in ADI.log
-----------------------

[23-12-19 08:42:07.988][ERROR] [ADIRefresh][trigger]Error occured while updating connector tables:

java.lang.Exception: Error occured while updating connector tables:

at com.ofss.fsgbu.dihref.util.UpdateADIData.updateContTables(UpdateADIData.java:92) ~[dih-adiref.jar:8.0.7.0.0_10175166621574]

at com.ofss.fsgbu.dihref.impl.ADIRefresh.trigger(ADIRefresh.java:118) [dih-adiref.jar:8.0.7.0.0_10175166621574]

at com.ofs.reveleus.DIH.rest.service.Refresh$2.run(Refresh.java:87) [dih.jar:8.0.7.0.0_10175166621574]

at java.lang.Thread.run(Thread.java:748) [?:1.8.0_144]

Caused by: java.lang.Exception: Error occured while updating truncate details

at com.ofss.fsgbu.dihref.util.UpdateADIDataUtils.updateEntityIds(UpdateADIDataUtils.java:270) ~[dih-adiref.jar:8.0.7.0.0_10175166621574]

at com.ofss.fsgbu.dihref.util.UpdateADIData.updateContTables(UpdateADIData.java:77) ~[dih-adiref.jar:8.0.7.0.0_10175166621574]

... 3 more

Caused by: java.lang.Exception: Error occured while executing batch

at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.executeBatchUpdate(QueryRunnerUtils.java:135) ~[dih-core.jar:8.0.7.0.0_10175166621574]

at com.ofss.fsgbu.dihref.util.UpdateADIDataUtils.updateEntityIds(UpdateADIDataUtils.java:268) ~[dih-adiref.jar:8.0.7.0.0_10175166621574]

at com.ofss.fsgbu.dihref.util.UpdateADIData.updateContTables(UpdateADIData.java:77) ~[dih-adiref.jar:8.0.7.0.0_10175166621574]

... 3 more

Caused by: java.sql.BatchUpdateException: ORA-01407: cannot update ("OFSATM"."FSI_CONT_TRUNCATE_OPTIONS"."ENTITY_ID") to NULL

 




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute ADI refresh from ADI screen

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform ADI refresh successfully

Changes

 

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.