web services error

pavan_test · Post by **pavan_test** » Thu Jan 28, 2010 9:35 am

Hi All,

I have a etl job calling web service from datastage 8.1.
when i try to run this job it is aborting due to

JObNAME_XXX.WS_Make_Call_Tfm: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:HTTP</faultcode>
<faultstring>(500)Internal Server Error</faultstring>
<detail>
<string>return code: 500
<html>
<head>
<title>Request timed out.</title>
<style>

Can anyone please suggest me what this error mean.

Thanks
Mark

pavan_test · Post by **pavan_test** » Thu Jan 28, 2010 10:40 am

I am thinking this is a web services connectivity error.

JOBNAME_XXX.Add_Call_Info_Tfm: DSD.StageRun Active stage starting, tracemode = 0.
JOBNAME_XXX.WS_Make_Call_Tfm: DSD.INTOpen Active stage starting, tracemode = 0.
JOBNAME_XXX.Receive_Response_Tfm: DSD.INTOpen Active stage starting, tracemode = 0.
JOBNAME_XXX.Parse_Response_PRS: DSD.INTOpen Active stage starting, tracemode = 0.

JOBNAME_XXX.WS_Make_Call_Tfm: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:HTTP</faultcode>
<faultstring>(500)Internal Server Error</faultstring>
<detail>
<string>return code: 500
<html>
<head>
<title>Request timed out.</title>
<style>

Any suggestions, Thanks in advance,

Thanks
Mark

chulett · Post by **chulett** » Thu Jan 28, 2010 10:48 am

Your request timed out. Have you attempted to access this service outside of DataStage? There are a number of good tools out there for this, none of which I can remember off the top of my head at the moment (SoapScope?) that can help isolate if the issue is the service itself or something you're doing in the job.

dganeshm · Post by **dganeshm** » Thu Jan 28, 2010 1:25 pm

pavan_test wrote:I am thinking this is a web services connectivity error.

JOBNAME_XXX.Add_Call_Info_Tfm: DSD.StageRun Active stage starting, tracemode = 0.
JOBNAME_XXX.WS_Make_Call_Tfm: DSD.INTOpen Active stage starting, tracemode = 0.
JOBNAME_XXX.Receive_Response_Tfm: DSD.INTOpen Active stage starting, tracemode = 0.
JOBNAME_XXX.Parse_Response_PRS: DSD.INTOpen Active stage starting, tracemode = 0.

JOBNAME_XXX.WS_Make_Call_Tfm: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:HTTP</faultcode>
<faultstring>(500)Internal Server Error</faultstring>
<detail>
<string>return code: 500
<html>
<head>
<title>Request timed out.</title>
<style>

Any suggestions, Thanks in advance,

Thanks
Mark

Mark,

I dont think its a connectivity issue, if it were it would give the following error :

com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>java.net.ConnectException: Connection refused</faultstring>
<detail>
<ns1:stackTrace xmlns:ns1="http://xml.apache.org/axis/">java.net.ConnectException: Connection refused

I think the server which is hosting the webservices itself is not up and running.

pavan_test · Post by **pavan_test** » Thu Jan 28, 2010 1:53 pm

I agree. I re-ran the job after changing login information and the job aborted with a different error message, bad username and password exception.

the server which is hosting the webservices itself is not up and running. whom do i contact to find out the server is not running.

Thanks
Mark

dganeshm · Post by **dganeshm** » Thu Jan 28, 2010 1:58 pm

pavan_test wrote:I agree. I re-ran the job after changing login information and the job aborted with a different error message, bad username and password exception.

the server which is hosting the webservices itself is not up and running. whom do i contact to find out the server is not running.

Thanks
Mark

If you know the server name, you can try pinging it from your local machine to check if its replying or not , most probably you will have to get in touch with the administrator of the server to resolve if there are any issues..

pavan_test · Post by **pavan_test** » Thu Jan 28, 2010 2:13 pm

Are you refering to datastage server or the webservices server where I get the information (they are 3rd party).

Thanks
Mark

chulett · Post by **chulett** » Thu Jan 28, 2010 4:37 pm

So, what was the resolution?

dganeshm · Post by **dganeshm** » Thu Jan 28, 2010 5:12 pm

chulett wrote:So, what was the resolution?

Yeah, it would be good to know the resolution..

DSXchange