SFTP channel error: same file processing twice with error as :Message ID XXXXXXXXXXX....XXXX already exists in database: com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException: ORA-00001

[Former Member]

Hi All,

Currently we are having an issue SFTP to IDOC scenario. The sender SFTP channel is picking up and processing same file twice in SAP PO (Single java stack) with the error as

Message ID XXXXXXXXXXX....XXXX already exists in database:com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException: ORA-00001.

I have already setup lock mode, duplicate file check in sender SFTP channel, but still it is throwing error at each time of picking up file. The current polling interval is 10 mins.

Please let me know if anyone has solution on this.

Regards,

Saru

[Former Member]

Hi Saru,

Please check this:

Regards,

Hailong

[engswee]

Hi Saru

Try and check if the file is being picked up by the SFTP channel while it is still being written by the sending application.

If that is the case, try requesting the sending application to write using a temporary file name (which does not match the pattern on the SFTP channel) and rename it to the final name upon completion of file write.

Regards

Eng Swee

[Former Member]

Thanks Eng Swee Yeoh,

But channel is scheduled to pick up file only once in a day. And file is getting placed  on SFTP server around -3-4 hours before it. Hence there is no point of using temporary file option. We have enabled duplicate check also but still its not working.

Regards,

Saru

[former_member186851]

Hello Saru,

if you enable duplicate check the duplicate files wont be proccessed.

[iaki_vila]

Hi Saru,

If you are in PI 7.4 at first this note is not applicable 1721113 - Duplicate IDoc numbers and transaction ids generated

However, you can try with the tip of setting AutoNumberFromDB to false in the properties of the IDOC_AAE adapter, if you are using this one and not the IDOC ABAP adapter.

Regards.