DSXchange

No offense meant by this, but it is simply not an answer, technique, or subject for discussion. Valid xml, by the "xml standards" (see w3c.org), considers CRLFs and extra blanks as "noise". About 10 to 12 years ago, being able to do pretty formatting was useful, because there wer...

There is a check box in the ISD Console...at the Operation level.....at the bottom where you see the input and output tabs...you'll see check boxes to group into structure and to return an array. Be sure that is checked....the WSDL will reflect it properly.

Ernie

...and you've tried sending up the EXACT payload from SOAPui, inside of DS? (meaning...just copy and paste it into a transformer...whole payload). Send that into the WSTransformer with "user defined column" selected.

Ernie

I'd probably break it out to debug it further. Take one of the xml documents and in a new job, put the WHOLE document in a Derivation in an upstream transformer, and then send THAT column to the WSTransformer...just to entirely isolate the debugging process.

Ernie

I'd probably break it out to debug it further. Take one of the xml documents and in a new job, put the WHOLE document in a Derivation in an upstream transformer, and then send THAT column to the WSTransformer...just to entirely isolate the debugging process.

Ernie

Welcome to the forum and to DataStage.... As far as passing "records" or "rows" (the definition of which can be a bit ambiguous, but for the moment we'll assume them to be the same --- a single "tuple" of relational style, with one "row" of one or more "c...

Absolutely. Let the tool (whatever tool) do the work....it also streamlines everything else, from portability (easier to change stage types), data lineage, and more. There will always be those times when you need your own, from special techniques to a need for special dialects, or just because the c...

Make sure also that the whole payload "as is" from SOAPui can be called effectively. ...just in case the error has nothing to do with your particular payload and is something in the installation or configuration. Do this by having one single column coming into the WSTransformer directly fr...

Don't know what that particular error is (could just be a simple install issue with the Stage on that central machine...it might be trying to lay down Flash, if it wasn't already installed). As the folks that support that machine and have appropriate administrator rights to get into the stage and fi...

Ok. Good. So it's not the xmlOutput Stage causing the issue. Just a thought....put a transformer in the middle, between the xmlOutput Stage and the WSTransformer. Maybe some old xpath in the Description is causing a conflict.

Ernie

Hi Deb Been awhile, but I've done this configuration and it works great. As I recall, those are just new properties within WAS (and I think that's just a typo)..you establish them, and then give them a value....then give that username what you want he users "without" putting in log in info...

Hi Deb Been awhile, but I've done this configuration and it works great. As I recall, those are just new properties within WAS (and I think that's just a typo)..you establish them, and then give them a value....then give that username what you want he users "without" putting in log in info...

...by the way...can you please share any settings that you might have in your job regarding tracing or other such things? The message you are seeing, especially where it says something like "xml envelope", is typically part of the WSTransformer "tracing" option --- something that...

Check it again. Create a copy of you job and REMOVE the WSTransformer....replace it with a Sequential Stage......send ONLY the xmlContent column (your resulting column) down that link [longvarchar, length of something like 99999]. In the Sequential Stage, use delimeter NONE and quote character NONE....

Step 1 is to make sure you can successfully call the web service using a tool like SOAPui. Be certain that you know exactly what the SOAP header looks like and what should be in it. I agree with Ray....it's nice to use a transformer to build your SOAP header....then it can be dynamic. As I recall, t...