Page 1 of 1
web services error
Posted: Thu Jan 28, 2010 9:35 am
by pavan_test
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
web services error
Posted: Thu Jan 28, 2010 10:40 am
by pavan_test
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
Posted: Thu Jan 28, 2010 10:48 am
by chulett
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.
Re: web services error
Posted: Thu Jan 28, 2010 1:25 pm
by dganeshm
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.
web services error
Posted: Thu Jan 28, 2010 1:53 pm
by pavan_test
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
Re: web services error
Posted: Thu Jan 28, 2010 1:58 pm
by dganeshm
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..
web services error
Posted: Thu Jan 28, 2010 2:13 pm
by pavan_test
Are you refering to datastage server or the webservices server where I get the information (they are 3rd party).
Thanks
Mark
Posted: Thu Jan 28, 2010 4:37 pm
by chulett
So, what was the resolution?
Posted: Thu Jan 28, 2010 5:12 pm
by dganeshm
chulett wrote:So, what was the resolution?
Yeah, it would be good to know the resolution..