Synchronous JDBC - message timeout

[Former Member]

Hi,

I have a scenario RFC-XI-JDBC synch. I am getting a message timeout error while trying to post large data volume. Apparently the sync message is geting expired after timeout (default 180 sec).

I found SAP note 730870 (question 14) suggests to increase the property xiadapter.inbound.timeout.default. However, SAP note 791379 says you should never change this value.

Is anyone has chaged this value in oreder to optimize performance ? Pls suggest.

Also pls let me know if you have any other suggestion.

[Former Member]

First try to to check how much time will XI take to post the messge in the Database(for all the fields). based on that you can increase the time interval.

Thanks

Faroo

[Former Member]

We are executing a DELETE and an INSERT statement within the single transaction. In the worst case scenario, the scenario should be able to DELETE 4000 records and INSERT another 4000 to it.

However, I am getting an message timeout error in the response message.

Here is the details:

com.sap.aii.af.ra.ms.api.MessageExpiredException: Message ccfaa480-bd4a-11dc-b6f5-00145e4d4476(INBOUND) expired

We have increased the following XI parameters.

1. jdbc timeout 200 to 300

2. connect time from 120 to 200

Still we are getting inconsistent results on timeout error.

Please help.

[agasthuri_doss]

Hi,

Go thru the Discussion in the below thread - Might Help

Regards

Agasthuri Doss

[Former Member]

Agasthuri,

I have a RFC-XI-JDBC synch scenario and having timeout issue in adapter framework.

Please go through the thread and suggest a solution.

- Shibaji

[GabrielSagaya]

As per the documentation

http://help.sap.com/saphelp_nw04s/helpdata/en/29/22ee41c334c717e10000000a155106/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bd5950ff-0701-0010-a5bc-86d45fd5...

You should increase the timeout from 180000(default) to 240000.

or 240 sec.

please visit