HTTP Timeout in JDBC Scenario

[Former Member]

Hi,

I have a synchronous scenariou which fetches record from DB using JDBC receiver. Also, I have a BPM which does an async-sync bridge.

Recently in production we got a file which were hanging in the send synchronous step and finally giving a ICM_HTTP Timeout error.

We increased the timeout to 600 seconds, increased the java heap space error but still facing the same issue.

We suspected whether this might be due to the number of records being fetched for each record. But surprisingly, when i checked the jdbc channel, it has not even initiated call request.

I executed the same file in Q and found the same error. In one instance the PI java server iteself went down and came back in 4 mins.  After we increased the java heap space error, now we are getting only timeout error.

Error while receiving by HTTP (error code: 402 , error text: ICM_HTTP_TIMEOUT) (See attachment HTMLError for details)</

Error:	-5
Version:	7200
Component:	ICM
Date/Time:	Tue Aug 20 22:25:45 2013
Module:	icxxthr_mt.c
Line:	4295
Server:	sappip00_PI1_25
Error Tag:	{-}
Detail:	Connection to partner timed out after 600s

Is this error related to jdbc receiver and if so i can't see any call request in the audit log.

Please let me know what else config i need to do to analyse this issue.

Regards

Anandh

[Pranil1 · Accepted solution]

Hi Anandha,

Please check the below document.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c059d583-a551-2c10-e095-eb5d95e03...

Regards,

Pranil.

[ambrish_mishra]

Hi Anandha,

You need to analyze if the payload is not too big (running into thousands of records), then the TIME_OUT value of 600 seconds is more than sufficient.

Are you able to connect to this database system?

It might also be due to firewall issues.

Check with your basis team if they are able to ping the DB host from OS level. If yes, then you need to check the guide posted by Pranil and look at configuration parameters or performance enhancement techniques.

Ambrish