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
Hi Rene,
Are you using the parameter duplicateCheckPersist? 1744700 - SFTP Adapter - duplicateCheckPersist Attribute
Regards.
Finally can you also check if there are any locks on this channel?
Add a comment