Webservice job hanging

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
Developer9
Premium Member
Premium Member
Posts: 187
Joined: Thu Apr 14, 2011 5:10 pm

Webservice job hanging

Post by Developer9 »

I have a webservice which delete records from a table and the job hangs when it encounters certain records. It just does not do anything from that point. I compared the records for anamolies but couldnt find any compared to the ones that process successfully. I ran it through SOAP UI client and get the below error. Not sure why its happening only for few records. Any thoughts??

Also when i directly run a delete command on the database for these records they get deleted without any issue.

Error getting response for [webservice] ;java.net.SocketTimeoutException: Read timed out.
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

Webservice is timing out, even when invoked from SOAP UI client, so it is probably not a DataStage issue.

Do you see any other error message? You can start by getting in touch with DBAs and check if they see any issues with table/indexes. Also check the timeout setting of the web-service.
Post Reply