Webservices Client stage help

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
Hope
Participant
Posts: 97
Joined: Sun May 13, 2007 2:51 pm
Contact:

Webservices Client stage help

Post by Hope »

<soapenv:Envelope xmlns:soapenv=
"http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns="urn:xxx/xx/ecbs/object/"
xmlns:quer="urn:xxx/xx/ecbs/object/Query">
<soapenv:Header/>
<soapenv:Body>
<ns:operation_Input>
<quer:ListOfContact pagesize="100" startrownum="0" recordcountneeded="True">
<quer:Contact searchspec="">
<quer:ModifiedDate></quer:ModifiedDate>
<quer:ContactFirstName>='xxx yyy'</quer:ContactFirstName>
</quer:Contact>
</quer:ListOfContact>
<ns:ViewMode>Organization</ns:ViewMode>
</ns:operation_Input>
</soapenv:Body>
</soapenv:Envelope>

I am using the above query in SOAP UI and I get expected results.I want to get the same results through Datastage.I am using the Webservices client stage to extract data from Oracle CRM on demand.I imported the WSDL from OOD.If I give ContactFirstName='xxx' I get the results.But If I give ContactFirstName value ='xxx yyy' in my table definition I get error.Datastage is not taking the spaces.what value should I pass?.please advice.

Webservices_rec..XML_Input_14: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelop ... ring>Error while processing argument urn:/crmondemand/xml/Contact/Query:ListOfContact for operation ContactQueryPage(SBL-EAI-04316)</faultstring><detail><siebelf:siebdetail xmlns:siebelf="http://www.siebel.com/ws/fault"><siebel ... rmsg>Error while processing argument urn:/crmondemand/xml/Contact/Query:ListOfContact for operation ContactQueryPage(SBL-EAI-04316)</siebelf:errormsg></siebelf:error><siebelf:error><siebelf:errorcode>(SBL-EAI-04121)</siebelf:errorcode><siebelf:errorsymbol>IDS_EAI_ERR_INTOBJHIER_ATTR_UNKN</siebelf:errorsymbol><siebelf:errormsg>Field with XML tag &apos;null&apos; and XML Style of &apos;Attribute&apos; is not found in the definition of EAI Integration Component &apos;Contact&apos;(SBL-EAI-04121)</siebelf:errormsg></siebelf:error></siebelf:errorstack></siebelf:siebdetail></detail></ns1:Fault>
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

That looks like the fault is being returned to you by Siebel.....so...either Siebel doesn't like the spaces in the value, or the value is being altered somewhere along the way.

The Trace option wasn't working in 8.x, so I haven't tried it in a long time, but give it a shot and see......click the Trace tab when you run the job, select your WSStage on the left side, and check all four boxes on the right. If the Trace is working, you will get lots of detail in the dslog --- some of that will be the xml soap envelope going out....and the xml soap envelope coming back..... perhaps you will be able to see what is there.

Otherwise, look on the web for a tool called tcpmon...it will let you monitor your tcp/ip traffic...you can set it up to intercept the http packet, inside of which will be your SOAP envelope...find out exactly what is being sent "up" when you use DataStage and compare that to exactly what is being sent "up" when you use SOAPui. Been a long time since I've used tcpmon, but it is fairly easy to use, and if not that one, there are many other packet viewing tools available on the web.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

I use Oracle's JDeveloper. Its HTTP Analyzer will give you all the detailed info. and it's free.
Post Reply