My Oracle Support Banner

Mantas Patch P25933753_80200_Generic.zip Installation Issue with ORA-02291: integrity constraint (OFSAACONF_US.FK_CSSMS_GRMG) violated (Doc ID 2617871.1)

Last updated on DECEMBER 12, 2019

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.2 version, Installers

ACTUAL BEHAVIOR
---------------
Mantas patch p25933753_80200_Generic.zip installation issue.



[Mon Nov 18 15:33:31 CET 2019]~[INFO]~PreparedStatement Query: MERGE INTO CSSMS_GROUP_ROLE_MAP CGRM USING (SELECT V_GROUP_CODE, V_ROLE_CODE FROM CSSMS_GROUP_ROLE_MAP_PACK WHERE V_APP_ID in (?)) CGRMP ON (CGRM.V_GROUP_CODE = CGRMP.V_GROUP_CODE AND CGRM.V_ROLE_CODE=CGRMP.V_ROLE_CODE) WHEN NOT MATCHED THEN INSERT (V_GROUP_CODE, V_ROLE_CODE) VALUES (CGRMP.V_GROUP_CODE, CGRMP.V_ROLE_CODE)
[Mon Nov 18 15:33:31 CET 2019]~[DEBUG]~Calling setString with index = 1, String = OFS_GRC_QTNR
[Mon Nov 18 15:33:31 CET 2019]~[DEBUG]~Calling executeUpdate
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OFSAACONF_US.FK_CSSMS_GRMG) violated - parent key not found

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegating

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
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.