My Oracle Support Banner

ADI Refresh fails with ORA-00001: unique constraint (DEV_OFSAEPM.PK_STVAL_ATTR_MAP) error (Doc ID 2418023.1)

Last updated on AUGUST 16, 2018

Applies to:

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

Symptoms

 ADI Refresh fails with below error in DIH 8.0.4:

DIH.log:

[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175935, stValId=563, attrId=19587, colId=21770]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175936, stValId=563, attrId=19588, colId=21775]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175937, stValId=563, attrId=19589, colId=21768]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175938, stValId=563, attrId=19590, colId=21767]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175939, stValId=563, attrId=19591, colId=21774]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175940, stValId=570, attrId=19790, colId=23879]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175941, stValId=570, attrId=19793, colId=21821]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175942, stValId=570, attrId=19794, colId=21822]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=175943, stValId=570, attrId=19795, colId=21820]
[11-06-18 12:49:56 PM] ~ INFO ~ DIHLOGGER ~ [StValAttrMap][persistMultiple]<FAIL>--<OBJECT TYPE: StValAttrMap>--<OPERATION: Could not persist Attr for StValAttrMap [stValAttrId=20042, stValId=570, attrId=19790, colId=21823]
[11-06-18 12:49:56 PM] ~ ERROR ~ DIHLOGGER ~ ORA-00001: unique constraint (DEV_OFSAEPM.PK_STVAL_ATTR_MAP) violated

java.sql.BatchUpdateException: ORA-00001: unique constraint (DEV_OFSAEPM.PK_STVAL_ATTR_MAP) violated

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216)
at com.ofs.reveleus.DIH.entity.adi.StValAttrMap.persistMultiple(StValAttrMap.java:458)
at com.ofs.reveleus.DIH.model.TestADIRefresh.testAdiRefresh(TestADIRefresh.java:1895)
at com.ofs.reveleus.DIH.action.RegisterAction.testAdiRefresh(RegisterAction.java:10891)
at com.ofs.reveleus.DIH.action.RegisterAction.runRefreshAction(RegisterAction.java:10930)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)

[11-06-18 12:51:36 PM] ~ INFO ~ DIHLOGGER ~ [TestADIRefresh][testAdiRefresh]<NOTE>--ADI Refresh has been completed at: 2018/06/11 12:51:36 . Total Time taken - [453] seconds
[11-06-18 12:51:36 PM] ~ INFO ~ DIHLOGGER ~ [RegisterAction][testAdiRefresh]<FAIL>--ADI Refresh was unsuccessful

Changes

 Client has merged DM_PFT_ALM_BSP_IFRS_TR_Pack_Basel Models and triggered ADI Refresh post the successful Model Upload, but ADI Refresh failed

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!


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