ABAP Proxy to SFTP Scenario

[Former Member]

Hi All,

While executing the ABAP Proxy to SFTP Scenario.

I am trying to send data from SAP to SFTP server.

I am getting this below error, could you please let me know what could be the problem?

DuplicateKeyException - SQL-State:
23505; Error-Code: -803; Message: [SQL0803] Duplicate key value specified.

OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION];
To-String: com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException:
[SQL0803] Duplicate key value specified.
OpenSQLExceptionCategories:
[NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION].

Thanks

Ramesh.D

[former_member184681]

Hi,

Check the SAP Note 1635853 - Concurrency issue during load test. It seems to mention an error identical to yours.

Regards,

Greg

[iaki_vila]

Hi Ramesh,

Thisis a SQL error. Are not you using jdbc receiver or jdbc lookup?

Regards.

[Former Member]

I am new to this kind of scenario, could you please let me know what is the significance of lookup for this and i am not using any JDBC adapter its simpe proxy to SFTP scenario.

[baskar_gopalakrishnan2]

This is not certificate issue.  The error might be in abap proxy coding where you do some sql query lookup or something. Otherwise you might be doing some jdbc lookup in mapping where it causes this error. Please see the log traces. Check your database table design against query and see where you do the mistake. Elaborate more here if you need further help.

[Former Member]

But here PI got data from SAP System.

[rajasekhar_reddy14]

Hi Ramesh,

Please share more info about your issue. like where exatly you are facing this issue like adapter level or SFTP side or moni?

it looks certificate issue.

Regards,

Raj