SFTP Sender CC weird Error: Duplicated Message-ID in database

[Former Member]

Hi gurus,

my scenario:

PI 7.31 Java only with SFTP Addon 1.0. Just pick up ASCII Files from external SFTP Server via SFTP-Sender CC to put them in the internal Server per FTP- Adapter.

SFTP Sender CC has the following Error:

Message ID 1385382546/2118165793/-1101616143/1500264263 already exists in database: com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException: [250]: Duplicate secondary key:I_XI_ID_MAP_ID1

OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION]

I have researched the forum and executed the following options:

- cleaned up the destination directory.

- restarted Java-Application com.sap.aii.adapter.sftp.app in NWA

- restated XPI: File in NWA

- restarted CC

- renamed the source file name.

- even restarted PI.

But this error still stays.

Could you give me some suggestion?

Thanks a lot in advance

Rene

[iaki_vila · Accepted solution]

Hi Rene,

Are you using the parameter duplicateCheckPersist? 1744700 - SFTP Adapter - duplicateCheckPersist Attribute

Regards.

[Former Member · Accepted solution]

Hi Vila,

thank u for your suggestion!

after update to SP05, the problem is resolved.

Regards

Rene

[Former Member]

Nobody could give me more hints?

[Former Member]

here is the log:

but the messages could be sent. I actived the delete option in CC, but the message was not deleted.

so strange!

[former_member184720]

Finally can you also check if there are any locks on this channel?

[Former Member]

Hi Hareesh,

thank you for your prompt reply.

I have deleted all blocks, but no effect.

I have to create a new OSS to SAP?!

Regards

Rene