My Oracle Support Banner

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

Last updated on MARCH 17, 2021

Applies to:

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


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( ~[ojdbc8.jar:]


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

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