Skip to Content
avatar image
Former Member

SFTP adapter issue with dupliacate files


Hello Guys,

I am working on file to proxy scenario on PI 7.31 Java only system.

I am facing issue with SFTP sender adapter, i wanted to reprocess the same file again. Although i unchecked the duplicate file checkbox.

File is not getting processed and adapter gives below error.

Error while sending message: Message ID 1406196843/-1496048728/1376310205/103581509 already exists in database: com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException: ORA-00001: unique constraint (UNKNOWN.obj#=24157) violated

OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION]

Note- SFTP component is 1.0 and patch level is 01.

Please let me know if anyone have came accros such error and resolution for the same.

Thanks,

Sandip

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 06, 2014 at 11:02 PM

    Hi,

    Per Note -1692819, The changes on SFTP adapter  will come only into effect after the restart in lower versions of software and this bug is fixed from SP2, patch 8 and SP1, patch 17. If you are on lower version try restarting the SFTP adapter application and see if its making any difference,

    If not you may have to move to the latest version.

    Cheers,

    Sunil.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2014 at 02:10 PM

    Hi Sandip,

    Similar problem discussed in the below thread and looks like the SP upgrade fixed the issue.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2014 at 02:25 PM

    Hi Sandip,

    What is your PI SP level?, check if this note affects your system

    1635853 - Concurrency issue during load test

    1979353 - Recurring TxRollbackException with MODE_STORE_ON_ERROR stage configuration

    Check also this thread

    Regards.

    Add comment
    10|10000 characters needed characters exceeded