Files moving to NFS error folder - Could not insert message into duplicate check table

[Former Member]

Hi Friends

Have anyone faced this error, could suggest me why.

The CSV Files failed on Sender Channel and moves to NFS error path  and in the log it says as below.

Error: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Could not insert message  into duplicate check table. Reason: com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error

[former_member184720 · Accepted solution]

Hi Uma - is that a duplicate file? have you enabled duplicate file check in sender channel?

please check if the below note is applicable

1979353 - Recurring TxRollbackException with MODE_STORE_ON_ERROR stage configuration

[Former Member · Accepted solution]

Thanks Hareesh. I will check with respective team for the same to prevent future failures.

[Former Member · Accepted solution]

Hi Hareesh

I think this has to be set in the property of XI Adapter, not any to configure on Application side.