My Oracle Support Banner

ADI refresh failed due to ORA-01400 (Doc ID 2619991.1)

Last updated on DECEMBER 17, 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_OFSS

When attempting to perform ADI refresh,the following error occurs.

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


[09-12-19 18:44:25.558][ERROR] [ADIRefresh][trigger]Error occurred while creating revisions
java.lang.Exception: Error occurred while creating revisions
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.createRevisions(ADIRefreshUtils.java:901) ~[dih-adiref.jar:8.0.7.0.0_10175166611298]
at com.ofss.fsgbu.dihref.impl.ADIRefresh.trigger(ADIRefresh.java:116) [dih-adiref.jar:8.0.7.0.0_10175166611298]
at com.ofs.reveleus.DIH.rest.service.Refresh$2.run(Refresh.java:87) [dih.jar:8.0.7.0.0_10175166611298]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_221]
Caused by: java.sql.SQLException: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("XXXX"."FSI_ADI_B_HIST"."VERSION_ID")

at com.ofs.reveleus.global.db.utils.QueryRunner.executeUpdate(QueryRunner.java:295) ~[CommonPlatform.jar:?]
at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.excuteUpdate(QueryRunnerUtils.java:36) ~[dih-core.jar:8.0.7.0.0_10175166611298]
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.createRevisions(ADIRefreshUtils.java:892) ~[dih-adiref.jar:8.0.7.0.0_10175166611298]
... 3 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("XXXX"."FSI_ADI_B_HIST"."VERSION_ID")

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3736) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1063) ~[ojdbc8.jar:19.3.0.0.0]
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170) ~[com.bea.core.datasource6.jar:12.2.1.4]
at com.ofs.reveleus.global.db.utils.QueryRunner.executeUpdate(QueryRunner.java:290) ~[CommonPlatform.jar:?]
at com.ofss.fsgbu.dihcore.utils.QueryRunnerUtils.excuteUpdate(QueryRunnerUtils.java:36) ~[dih-core.jar:8.0.7.0.0_10175166611298]
at com.ofss.fsgbu.dihref.util.ADIRefreshUtils.createRevisions(ADIRefreshUtils.java:892) ~[dih-adiref.jar:8.0.7.0.0_10175166611298]
... 3 more
STEPS
-----------
The issue can be reproduced at will with the following steps:
1. Try to perform ADI refresh after upgrading DIH from 803 to 807

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


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