Webservices Client - Error

Naren12345babu · Post by **Naren12345babu** » Wed Feb 03, 2016 4:29 pm

Hi,

I am trying to connect to Webservices through Webservices client stage. I have created a job and when I run it, I am getting below error :

Web_Services_Client_22,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: Response unexpected null object.
at com.ascentialsoftware.wsclient.OperationCall.invoke(OperationCall.java:380)
at com.ascentialsoftware.wsclient.WebService.callServiceInternal(WebService.java:1685)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1591)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1544)
at com.ascentialsoftware.wspack.Transformer.process(Transformer.java:105)
at com.ascentialsoftware.jds.StageFactory.runStage(StageFactory.java:544)
at com.ascentialsoftware.jds.StageFactory.runTarget(StageFactory.java:348)

Can any one help me to resolve this please.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 03, 2016 7:37 pm

Can you invoke the same web service through some other client, such as SoapUI ?

Naren12345babu · Post by **Naren12345babu** » Thu Feb 04, 2016 2:12 pm

Hi Ray, yes I can. It is giving valid response when I invoke through SOAP UI

eostic · Post by **eostic** » Thu Feb 04, 2016 3:40 pm

Hard to say...but one tip that may help is to put the invocation in a WSTranformer of a Server Job...and then when you run it, find the Tracing tab and check the WSTransformer Stage on the left side, and then all four boxes on the right side...

This will produce a voluminous trace log in the DS log..... at the "center" of that trace....look for two lines.....for the xml payload "request" and the xml payload "response".... open those...it may give you hints, or also make it clear if you aren't getting a response, or maybe even if it blows up before geting a request......

Ernie

Naren12345babu · Post by **Naren12345babu** » Thu Feb 04, 2016 4:05 pm

hi,
where will i get tracing Tab, I am not able to find one in designer.

Naren12345babu · Post by **Naren12345babu** » Thu Feb 04, 2016 4:10 pm

Okay . GOt it

Naren12345babu · Post by **Naren12345babu** » Thu Feb 04, 2016 4:13 pm

Hi Ernie,

I did not get trace log in DS Log.

Naren12345babu · Post by **Naren12345babu** » Thu Feb 04, 2016 4:26 pm

In webservices client, under proxy--> HTTP/HTTPS Proxy required

what should be the values of these options

Username
Password
HostName
Port Number

Naren12345babu · Post by **Naren12345babu** » Thu Feb 04, 2016 6:03 pm

Username , password and hostname is fine but how to know the port number

Naren12345babu · Post by **Naren12345babu** » Thu Feb 04, 2016 6:50 pm

One more thing I think is,

Datastagd is getting response, and respose is null. So, it could be something which webservices is not allowing datastGe

ray.wurlod · Post by **ray.wurlod** » Thu Feb 04, 2016 9:13 pm

Port number is the port number on which the web service is listening.

If you haven't got this right, then you can't get any response. Which you are interpreting as a null response.

Naren12345babu · Post by **Naren12345babu** » Fri Feb 05, 2016 12:45 am

So in that case Hostname is Ipaddress of the server where webservices is hosted.

eostic · Post by **eostic** » Fri Feb 05, 2016 4:43 am

you mentioned that this is working in soapUI.......if so, then you should be very aware of every property here....the ports, the security, the host. Review the work you are doing in soapUI.......make sure you are intimate with every aspect of this service.....its request prooerties and their daratypes, header and security requiremwnts, and details of the response.......also try to find and speak with the author of the service.

.....and in the log exercise above, was it a server job that you created? if you didnt get any xml in that trace then maybe your request is never leaving datastage, regardless of the message you are seeing.

what does this web service do? what kind of argumentsnis it asking for?

The web services stages work well with simple scalar services that accept one row of input, or a primitive array, and return one row of output, or a primitive array.........anything outside of that may require the java integration stage.

Ernie

Naren12345babu · Post by **Naren12345babu** » Fri Feb 05, 2016 5:18 am

Hi Ernie,

In SOAP UI it is working fine. I created a SOAP Project and called this WSDL. then I got Methods. Under methods, I opened Request. Here I edited WSDL with some values and ran it, I got response.

Here I am using Web services Client stage for the first time, I was just rechecking whether all properties I have mentioned are correct.

eostic · Post by **eostic** » Fri Feb 05, 2016 6:25 am

..and you did this in a Server Job, not a Parallel Job?