DSXchange

Indeed. There is no question that some scenarios are going to be more difficult than others. Unknown or large numbers of occurrences are more challenging and will probably necessitate independent creation of xml for "that chunk" (which is effectively a kind of pivot). The degree of complex...

This one had me curious. So I did some digging in my old notes and checked around. In 8.5, I ran into stability problems with multiple Output Links in a Server Job using the XML Stage. Are those corrected in 8.7 and 9.1? I don't know, but I would certainly hope and expect consistent behavior between...

Hi dspr... I made the mistake up above of using the word "Formally"....there is nothing formal about it. In theory, the Stage should work the same in all environments for multiple output links. In release 8.5 I found the Stage to be more stable in EE, and I haven't myself had a chance sinc...

Congrats! For future readers who might find this via search, there are multiple stages that can be used to "write" xml documents. The xmlOutput Stage, which is available in releases 7.x and above, and the XML Stage, which arrived in 8.5. Both Stages can be used, but the XML Stage, which is...

good 'ol server usually doesn't care until it has to lay it down in a Stage that does care (usually rdbms stages)......it probably could be decimal and would still work ; ) Bottom line --- xml is nearly always just "text". Treat it that way and always deal with it as text and things are ge...

Just taking a wild guess.... check the datatype of the column that sources your chunk....assuming it is a varchar, you might need to set the APT_STRING_PADCHAR. Make it equal to a single space...no quotes. It could be that binary zeros or other such stuff is getting in the way.

Ernie

Hard to say, but this looks like a the scenario we've seen happen when there is only one innermost element of the repeating node. As a test, see what happens if you add several dummy columns.... create them upstream in a transformer, and give them a unique counter value (use a Stage variable or @INR...

ah wait. your header IS bad.

...right there at the end...

<XMLDATA>123</XMLDATA</ns2:XMLBAG

The XMLDATA tag isn't closed.

Should be:

<XMLDATA>123</XMLDATA></ns2:XMLBAG ...

Ernie

Your header looks ok...but look deep in your document....could be a lot of things....namespace declarations can appear anywhere in a document. Are you sure that 5000 is enough characters? Maybe something is getting oddly truncated somewhere. Send it to disk (put your input link to a sequential stage...

Depends a bit on what you mean by "append records". XML doesn't have "records"....it has nodes...and those nodes can be nested, and HAVE to be closed by a higher level node.....it's certainly possible to append "snippets" of xml together, probably using the Sequential S...

You mentioned BG in your initial post........do you have Metadata Workbench installed? That would potentially be another way to get the connection details you are looking for...

Ernie

Check that first row. Make sure also that there aren't any other reasons that the row might be dropped. Any nulls or anything in that row? And as noted earlier, for now, make sure that all your data is 100% character, and present, and loading only to xs:string type elements.

Ernie

Ok... great. Thanks. This is a multi-path hierarchy.....loosely defined as any time that you might have separate repeating child nodes under a common parent. Think "purchase order with 'n' addresses (say, three) and 'm' detailed line items being ordered (say) 27". If it is possible for you...

Ok....so here's the big question. Is it possible...that there will EVER be more than one StudentUniqueStateId under the StudentProgramAssociation node AND/or EVER possible that there will be more than one StudentUniqueStateId under the StudentProgramExtension node (in a single xml document or single...

Ok....so here's the big question. Is it possible...that there will EVER be more than one StudentUniqueStateId under the StudentProgramAssociation node AND/or EVER possible that there will be more than one StudentUniqueStateId under the StudentProgramExtension node (in a single xml document or single...