DB adapter calling stored procedure in synchronous SOA composite call fails after 600 seconds : Read
My long running synchronous service calls another service, which has a DB adapter and calls a stored procedure. If that stored procedure takes more than 10 mins that is 600 seconds, the invoke activity gets read timeout error. I have already changed the value of StuckThreadMaxTime from 600 seconds to 3600 seconds. Still it is getting failed at 10 mins.
For long running Synchronous service, the values configured for different properties are:
JTA: Timeout seconds: 4500
Beans: 4000
SyncMaxWaitTime : 3500
StuckThreadMaxTime : 3600
MaxStuckThreadTime: 3600
What should I do to resolve this.
Regards,
Kuldeep Tiwari