Receiver JDBC Channel : Unlimited Retries causing Performance Issue

[Former Member]

Dear Experts,

       We have a Proxy to JDBC asynchronous scenario from ECC to MySQL database for updated pricing information. Where the receiver JDBC channel is trying to post the failed message unlimited times again and again, this is causing performance issues in the MySQL database.

Error Message in SAP PI:

Transmitting the message to endpoint <local> using connection SOAP_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'pricing_product_a980' (structure 'Delete_Pricing_Product_A980'): com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction..

     Can we restrict the number of retires in the receiver JDBC channel?

Thanks.

[manoj_khavatkopp]

Try setting this Parameter :

Configuring the Receiver JDBC Adapter - Advanced Adapter Engine - SAP Library

Under Number of Retries of Database Transaction on SQL Error , specify how often the system is to attempt to reestablish the database connection and access the database in the event of an SQL exception.
If the number of retries is exceeded, the last status is reported to the sender Integration Server or the sender PCK. If an error occurs, the message is only processed again when the Integration Server/PCK sends it again.

Br,

Manoj

[former_member186851]

Hello Selva,

check the below discussion

Changing number of retries and retry interval o... | SCN

I would suggest you to do  it in dev first check it then do in production.Default retires will be 3.