DSXchange

is there a way to let all the reject links output to a same place (single ds file or database table)? Run each through a Transformer stage to add any static information you might require and to produce a consistent format, then run them through a Funnel stage to consolidate them. OR Create a shared...

As others have noted, please check the job log of the sequence job. Report back the detail of the first Fatal message. Also report back the content of the first Fatal mesage in the log of the job itself when run under control of the sequence.

As Craig notes, we really do need to see your design. In particular, is there any output from the Sequencer? If so, what activity type is on the other end of that link?

I saw something similar to this recently on version 11.5 (Engine on Windows). There was an underlying problem with the temporary tablespace in the database not being able to allocate sufficiently large page sizes. We created a new database with a bigger page size (8K) and automatic management of the...

Good thought, but they ARE managed by the same services tier. Will try the diffapicmdline utility next time I return to this problem.

Not yet. It's not high in my list of current priorities, but I'll get back to it some time.

It should be obvious from the values in the error messages that the error is occurring in the first row and it's trying to read the column headings as data. This is because of a property in the Sequential File stage that has not been set properly. Let us know that you've found the property in questi...

@Craig It's not possible from a parallel Transformer, but it is possible from a BASIC Transformer stage.

Maybe (just a guess) escape the space characters themselves?

Create a job that has the Surrogate Key Generator stage downstream of an appropriate database Connector stage. A Surrogate Key Generator stage with an input link can be used to update the state file. Use an appropriate query to get the new initial value. SELECT MAX(SK) + 1 AS NEW_BASE_SK FROM tablen...

DataStage may get it wrong, but it's almost certain that there's a UNIQUE constraint in the database that will prevent surrogate key re-use. Perhaps you can re-initialise your state file from the database.

You say that the job fails in production. Are you implying that the same job does not fail in dev or test? If so, what is different about the production environment?

Click any of the links on my new home page which takes you to a public page on OneDrive. Download RayWurlodDateRoutines.dsx from there.

There is no need to ask the question via Private Message unless you are seeking to engage services on a professional basis.

What format string are you using with the TimestampFromString() function?