Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Dec 04, 2013 at 11:53 AM

    Hi Rene,

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

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2013 at 01:52 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2013 at 02:43 PM

    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!


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2013 at 11:02 AM

    Nobody could give me more hints?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.