Page 1 of 1

SOAP UI ISD/Datastage error <faultcode>Server</faul

Posted: Fri May 15, 2015 11:24 am
by Gaurav.Dave
Hello,

I have created simple test job (DB2 ---> xfm ---> ISD Output) as a service on our DataStage 9.1 FP1 environment to design proof of concept for ISD usage for service. I am passing three fields to ISD output and only selecting one row for test. On ISD environment, I have used Soap over HTTP binding and created service. After deploying service, I got the wsdl information which I try to execute from SOAP UI.



Thing is we are able to execute datastage job from SOAP UI, and DataStage jobs finishing Successfully but on SOAP UI, we are not seeing resulted three fields from above DataStage jobs but its throwing following error message on SOAP UI. Little bit lost, if I am missing something on DataStage/ISD or something else. Need some guidance. Thanks.

Return error on SOAP UI is

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header/>
<soapenv:Body>
<soapenv:Fault>
<faultcode>Server</faultcode>
<faultstring>Internal Error</faultstring>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

Re: SOAP UI ISD/Datastage error <faultcode>Server</

Posted: Mon May 18, 2015 3:51 pm
by Gaurav.Dave
Gaurav.Dave wrote:Hello,

I have created simple test job (DB2 ---> xfm ---> ISD Output) as a service on our DataStage 9.1 FP1 environment to design proof of concept for ISD usage for service. I am passing three fields to ISD output and only selecting one row for test. On ISD environment, I have used Soap over HTTP binding and created service. After deploying service, I got the wsdl information which I try to execute from SOAP UI.



Thing is we are able to execute datastage job from SOAP UI, and DataStage jobs finishing Successfully but on SOAP UI, we are not seeing resulted three fields from above DataStage jobs but its throwing following error message on SOAP UI. Little bit lost, if I am missing something on DataStage/ISD or something else. Need some guidance. Thanks.

Return error on SOAP UI is

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header/>
<soapenv:Body>
<soapenv:Fault>
<faultcode>Server</faultcode>
<faultstring>Internal Error</faultstring>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

Posted: Mon May 18, 2015 4:00 pm
by chulett
Is that supposed to be a bump? :?

Posted: Mon May 18, 2015 8:25 pm
by eostic
Look for "something" that might be out of the ordinary....

How much volume? Did this ever work? Is the first one you have written?

If first one..make sure that you are sending back exactly one row.

...and with tiny columns...and all varchar.

...try different columns. Create a .csv file using a text editor and make that your first test --- you need a "control" test that always works.

Too much data under certain circumstances, bad data (any stray hex characters for example)....that and lots more could mess up SOAP UI, or ISD, or the plumbing in between.

Ernie