Issue with XML stage mapping

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
hobocamp
Premium Member
Premium Member
Posts: 98
Joined: Thu Aug 31, 2006 10:04 am

Issue with XML stage mapping

Post by hobocamp »

I'm trying for the first time to use the fancy all-in-one XML stage, and I'm having a hard time with one column.

I'm getting error CDIUI2805E, which I see referenced in a few posts, but I don't believe those posts relate to the problem I'm seeing.

My design is dataset --> XML --> WebService Client stage

First step: Dataset contains 6 fields, five of which get mapped into into an xml schema.

Second step: The resulting xml that was just mapped is then mapped to a second schema, which contains two elements (determined by the WebService wsdl). The first element receives the entire payload that was just mapped, and the second element should receive the 6th field from the initial dataset.

The problem I have is that by the time I get to the second xml transformation, the field I need to be mapped (a field from my initial dataset) is no longer available. If I drill down and try to map to it, I get the CDIUI2805E error.

Any suggestions on what I might be doing wrong?

Thanks in advance!
Tom
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

An exact search for that error comes up empty here, so not sure what other posts you are referring to. All I could find out in the wild is this reference entry that seems to confirm it is about your inability to map it:

http://www-01.ibm.com/support/knowledge ... 2805e.html

(copy/paste into your browser)
-craig

"You can never have too many knives" -- Logan Nine Fingers
hobocamp
Premium Member
Premium Member
Posts: 98
Joined: Thu Aug 31, 2006 10:04 am

Post by hobocamp »

Aargh! Thanks Craig, because you made me realize I'd pasted the wrong error message in my original post. This is the one I meant to post:

CDIUI2820E The mapping is not applicable due to an invalid type conversion or difference in the source and target list dimensions.

To summarize, when I try to map a field from my initial input into second mapping (by selecting Other....), any of the fields I select give me that error, even though they are of the same data type and dimensions.

Thanks.
Tom
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

This is a fairly typical problem when first using the stage.....it is likely that you need to do a regroup somewhere in the path for whatever identifies your repeating nodes......

....or if you are reading the xml.....that you first have to map your lowest level list to the output link list (match the proper blue icons) before doing anything else....

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

:idea:
Why don't you (Ernie) propose "Mysteries of the new XML Stage... Revealed!!" as a paper for Insight 2015?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hobocamp
Premium Member
Premium Member
Posts: 98
Joined: Thu Aug 31, 2006 10:04 am

Post by hobocamp »

I'm closing this one and marking it as resolved.

My ultimate output was to be a payload for a web service. The payload, a single string, consisted of two columns - 1) the xml payload and 2) an ID string. My mistake was that I was trying to include the ID string as part of the entire XML payload. Once I understood that mistake, the payload was created correctly.
Post Reply