DSXchange

In other words, you lied to the Aggregator stage about the sort order and it is busting you for it.

Or post an actual screen print of it. Any of the image hosting sites out there (like Image Shack or Photo Bucket) are good for that.

This can happen when string fields are not quoted and there is a comma (or whatever the delimiter of choice is) in the data for a field. Or fields.

Isn't the Operator role still restricted to only viewing released jobs in the Director?

There's no reason to extract the data like that. Nor is there a need to include an XML Input stage in the mix. It's just a matter of proper XPath expressions and which field, if any, should be marked as a Key field to indicate a repeating group. Try marking the brand field as a key, if you haven't t...

Check this post.

Searching for that error only finds one other post that mentions it. No solution there, but there is a complete error message and it probably shows what was cut off from yours. Best to contact Support for this one, I would think.

I believe that if you search the forum for the RESIZE command you'll find some posts from Ray mentioning using it for just that purpose. Pretty sure, anywho.

So, no love for us Server slubs, eh? Not that I need these, just thought it might be cool to put Mr Wizard through his paces and see what popped out.

Aren't what... intelligent? usable?

peterbaun wrote:In the derivation field in the DB2 plugin you will have to enter 'distinct ColName'

Exactly.

Specifically, insert the keyword 'distinct' before the derivation of the first column. Don't use custom sql for something simple like that.

On the subject of implementing SCD jobs, has anyone played with the Intelligent Assistants in 7.5.1A? Or know where / how you use them? There is quite a collection of xml 'templates' under Ascential/DataStage/Assistants/Generation/templates, hence the question. 83 in all, actually, including SCD1, S...

I'm sure they're in there somewhere. One place it may be easier to find is in the readme files that is installed in your Client folders. There are two new plugins, from what I recall - DRS and STP. All of the other new stages are for Sequencer jobs - Terminate Activity, Start Loop, End Loop and User...

An error 14 is a timeout. It is a symptom of an overloaded machine - i.e. too many processes / jobs attempting to run at the same time. This could be because the hardware is underpowered for the load being put on it or perhaps because some tunables are set too low. You haven't given us any clues abo...

Suggestion: When your problem is solved, the thread is closed. It only confuses things to immediately launch into a new problem in the same thread. It also makes it hard for people searching for solutions later.

Best Practice is to start a new thread with the new question / problem.