DSXchange

I doubt seriously if there is any "normal" or "formal" way to change that value at the project level programmatically. You may just have to use the GUI.

Ernie

I wouldn't suggest using OMD for that...and you certainly don't want to arbitrarily turn on OMD at the project level (it can be done at the administrator client but it not something to do without a lot of awareness of the jobs and the project, etc.). Do your own inspection using dsjob...it can pull ...

Great idea Doug! ...but, groan... I hate creating that QETEXT file... I guess it wouldn't be "that" hard a ds job to write to do it....

Ernie

It means that you are never getting "out of the box"....it's stopping before it even gets to the point where it can make the invocation. If you are building the SOAP header or SOAP body yourself, then review it carefully...I usually cut and paste one directly from a tool like SOAP UI and t...

I haven't seen this fail, so my suggestion would be, using your tiny document sample, to play with some possibilities: a) move the repeating element. right now you have it on an attribute....usually that works, but who knows. Make it "street" and see if/how the behavior changes for the mis...

Ray is correct....it's not worth the work when the details are right there at your finger tips and two or three clicks. ...another solution, if they won't let you have direct access, is for them to provide you with the Teradata DDL (create statements). It's not a perfect solution, but you could use ...

hard to say, but indeed, normal behavior for this would be for you to receive nulls for elements that don't exist in that lower node.... ...but carefully check which column on the output link has your "repeating element" (key = yes). That may have sometihng to do with it. It should be one ...

One useful debugging trick is to try it in a Server Job and turn on tracing....(at the run dialog, there is a trace option...select your stage and then click all four options on the right)......you will get a whole lot of log data, and at the center will be the xml soap request....and the xml soap r...

Does it abort always, or just once in awhile?

Did it "ever" work correctly?

What are you using to display the result below?

You say it aborts...where is this message or data? In the log, or in the target file?

Ernie

You can...but you have a lot of work to do and to research about your document.... Some document structures are so primitive that you can just "paste" them together one after the other.... Others have deep internal structure and will require massive amounts of inspection and parsing. Open ...

at quick glance, it looks like your example. The xml is perfectly valid, and probably the xsd is too. replaced by, ammended by, corrected by (others also)--- each of these are simply independent repeating elements..... retreive them as I noted above in your original example. On separate links.... th...

I see nothing natural in that xml that would produce the output that you say you are expecting. "A" has no priority or parentage in that structure...it's simply another instance of docref. I would hope and expect that you should get: for the docref link: 12 A 12 B 12 C ...three rows. and f...

Definitely change the java class if you can...it can easily send it's output in multiple rows and individual columns.....

Ernie

sorry...read that too quickly. haven't had my coffee this morning. Check your security for that sub-directory and also look at the encoding. I had a strange one like this recently and when I removed the entire encoding attribute (where it has UTF-8 or similar), it worked.

Ernie

search the forum and also go here:

http://dsrealtime.wordpress.com/2007/12 ... -a-source/

Don't use the Sequential Stage to read your xml documents.

Ernie