Webservice job hanging

Developer9 · Posted: Thu Jul 16, 2015 2:55 pm

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 · Posted: Thu Jul 16, 2015 5:32 pm

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.