DSXchange

If the 'master' link is the Sequential file source, then off the top of my head I don't understand the relationship between the two transformers. Can you please try editing your original post, wrapping the design in tabs and making liberal use of the 'Preview' function until everything lines up prop...

Perhaps an Aggregator with min(start dt) and max(end date).

Welcome. Again. :wink: First help us out with the job design you've posted. How do those three streams link together? I'm assuming first the ODBC and Seq File sources are used to populate two hashed files and then the 'middle' stream runs and does lookups against both hashed files. Is that correct? ...

Angelok wrote:Yes, after restarting the job, it always completes successfully.

That smacks of a resource issue, probably on your source / vendor side. Can you go into a little more detail on your source and the "data checking" you are doing?

Make sure you do an exact search and don't include too much text... there is a bug (feature?) in the other searches in that they only go back in time a small number of days, no clue why. The exact search searches everything. I got 57 matches on "does not fulfill the sort requirements", for...

You might also look into the csplit function.

"cat tail"? Just tail. Not that that is your problem, just an observation.

Your expression is probably evaluating as 'true', hence the one. I too would be curious what you get when you run the command manually and what exactly you are expecting to get from it.

Hopefully somebody else knows as they haven't posted in three years. Have you involved your official support provider yet? Just how "similar" is your issue... Server job, 7.x version as well?

Exactly... forgot they specifically said "crappy internal disks".

When you run the job manually you are 'prompted'. Command line / scheduled stuff... not so much.

It can also depend on the capabilities of the disks themselves and how their filesystem is configured. Had one client where we found that DataStage had been installed on (their words) "the crappy disks" and performance suffered horribly for it, simply moving it elsewhere helped. Others hav...

There are 10 other matches for "Error 81002" if you do an exact search here, see if any of them help.

Also, what is your project level timeout value set to, 21600?

Contact your official support provider.

phanikumar wrote:I will be running with all the values at once or each one at a time.

So... which is it?

KBA Job Control Utilities.