DSXchange

Hi Ray...I haven't had a chance to play with it, but last year the Imp/Export manager was given a command line interface that takes an xml document as the input arguments (that match what's in the GUI). Wish I could tell you exactly where to find it, but at the moment I don't know and will have to c...

Could be a whole lot of things. Early 8.x received lots of java errors initializing the pack...that could be it here. Search the forum for things like "can't initialize jvm" and other similar errors. Exactly what release of 8.x are you on...those things were corrected in 8.1 with FP1. Try ...

On the input link of your XML output stage, play with the "key"....it's not a "key" per se, but indicates the deepest level of repeating nodes that represents the "base" row....... the column that has that setting usually has a big impact on the aggregation break point....

Do some basic testing first, just to see if you are able to read and extract this particular xml column....once you have that, the rest is straightforward....feeding that column as "content" to the xmlInput Stage. You will find many posts on this subject, and the other tips posted just abo...

Very cool description, Kim. Thanks. Nice work to all!

An xsd isn't the issue here, assuming that the xml is already being created successfully. Tell us more about the rows coming in....how are they sorted, what do the values look like? How are they grouped, and also share the "xpath" on the input link of your xmlOutput Stage [the values in th...

At the moment I can't think then, of why one environment would work and not the other.....I will assume that you have carefully checked both jobs, and that neither of them have "validate" checked, and that they are both truly reading the exact same documents. As noted earlier, namespaces c...

Can we assume that these two environments are also the exact same operating system?

Ernie

Hard to say. Patch levels maybe? Namespaces had a variety of issues in early 8.x.

Ernie

Let's make sure we fully understand the Job and the terminology/functions that you are using in ISD..... You say that you have two ODBC stages. My understanding is that they are both used as lookups.....and both are used as "sparse" lookups only. And there are no others..... In ISD, you &q...

We would need more details, but it sounds like (maybe) you have a parallel job that is using lookups...... by default, lookups in EE load all their data into memory when the job is initialized...... there is a lot going on here....it sounds like you might have a job with WISDinput stage (which means...

some additional thoughts... Simpler maintenance over time...ESPECIALLY if the team changes or people move on or get promoted...... someone can look at a DS Job and can quickly get an idea of what is going on, even if they don't know the exact details.....not always so easy with a 3gl..... Also consi...

kumar's note is the important one....it sounds like the file is being mis-read at the source prior to getting into the Stage....send the path and name of the file into the xmlInput Stage, not the content...

Ernie

If it helps, here are some notes I've been keeping on this issue....(it was the same for JavaPack and WSPack). I've also found that in some cases I've needed to set these at the OS level via Control Panel/System/Environment Variables, and in other cases I only needed them in the individual Job envir...