cancel
Showing results for 
Search instead for 
Did you mean: 

SFTP adapter issue with dupliacate files

sandip_hole
Participant
0 Kudos


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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

iaki_vila
Active Contributor
0 Kudos

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.

former_member184720
Active Contributor
0 Kudos

Hi Sandip,

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