DSXchange

You might also consider provisioning just that table.

Why? You writing a book or something? Maybe no-one else has ideas or, if they do, they prefer not to share them. Remember that DSXchange is an all-volunteer site.

Then look at a few more lines of the log.

A sequence containing ten job activities with explicit error handling from each, collecting through a sequencer into final error handling.

Unreal!

These ones are rather difficult to diagnose, other than to make the blindingly obvious statement that an interrupt signal was raised somewhere in the system and handled by one of your processes. You should investigate the SystemOut.log and SystemErr.log for the WebSphere AppServer, and any logs for ...

"00000000" is not a valid date (there is no year 0, there is no month 0, there is no day 0). So don't try to convert it.

Standard components. The "Get" jobs write values to a file, the "Retrieve" activities read the file for example using cut command.
GetParams1 --> RetrieveParams1 --> RunInstance1 --> GetParams2 --> RetrieveParams2 --> RunInstance2 --> ...

It's not array size. Your Aggregator stage is running out of memory. That's why sorting the data removes the problem - sorted data enables a more efficient memory-consumption strategy to be used in the Aggregator stage.

If the values are quoted you can use the "contains terminators" property in the Columns grid of a Sequential File stage.

You need to have some "recovery" jobs ready to re-load the hashed files with synchronized data. Hashed files don't "fail over", particularly not when cached in memory.

Are you saying that you're trying to sum a VarChar data type?

Please post the exact properties you've used in the Aggregator stage, as well as whether your data are sorted (and, if so, on what fields).

I can't envisage how DSSetUserStatus would work from multiple processing nodes. In parallel jobs you're better off writing to a file unless you call DSSetUserStatus from a BASIC Transformer stage constrained to execute on a single node.

Please post the exact text of the error message.

OK, so I was away for the weekend. (Had to go to baseball umpiring school to renew my accreditation.)

Try