My Oracle Support Banner

TF 8.0.8.1.7 - Error with MT202COV message fails with unique constraint error (Doc ID 2747226.1)

Last updated on NOVEMBER 25, 2022

Applies to:

Oracle Financial Services Transaction Filtering - Version 8.0.8.1.0 and later
Information in this document applies to any platform.

Symptoms

User encountered error with tag 57a while posting swift message for MT202COV

Steps to reproduce :

Step 1 : Post the MT202COV message using JSP

Step 2 : Check the RTI Server.log for the below error.

Expected behavior :

The MT202COV message payment must be processed without issue and alert must be created.

Actual behavior :

The MT202COV message is not posted and encountered below error.

Error in rtiserver.log :

[ERROR][sourceEntityListener-5] aai - ORA-00001: unique constraint (OFSAAFCCM.UK_IDX_MSG_TAG_MSGID_IDEN) violated
java.sql.BatchUpdateException: ORA-00001: unique constraint (OFSAAFCCM.UK_IDX_MSG_TAG_MSGID_IDEN) violated
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9711) ~[ojdbc8.jar:19.3.0.0.0]

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.