DSXchange

You could always help yourself - an exact search for "Controller problem: Unhandled failure" will show you this has been asked and answered many times here.

Unfortunately, "Stopped/Restartable" is a lie. It's not. The only restartable status is "Aborted/Restartable".

'faffing about giving me elliptical comments'... me likey.

Ah... that makes sense, the error was thrown because the job was running.

I wasn't aware you could do any such thing. Have you seen this mentioned or documented somewhere?

I've looked at the same code and have very little idea what cp$dtm would be. That's the problem with going 'under the covers' and using undocumented internal functions not meant for us mere mortals.

The difference in performance of using 1 Transformer or 4 is minimal. However, 4 helps support his "conditional" lookup model and can help performance if large numbers of lookups fail. With everything in one transformer, all lookups would be done unconditionally. With multiple transformer...

No, 'fraid I don't. Mine was a new install on an SP3 machine, not where SP3 was added to an old client machine. Best to ask your official support provider about this and let us know what you find out. I imagine this could become more and more of an issue as SP3 rolls out.

I just had something similar with a brand new install on an SP3 machine... but a reinstall of the client (right over the top of 'old' one) fixed things for me.

While you could certainly 'roll your own' I believe most of us here use a version of the script found on Kim Duke's website in his Tips section.

Interesting this came up searching for SP3 - just got a new work laptop running XP SP3 and having some odd DataStage issues. Not sure if it's related or not but I think I'm one of the first here at work with that service pack and I'm getting automation/ole errors trying to add new parameters to jobs...

Or FasterTrack.

Director / Job / Clear log...

We're missing some critical information, it seems. Can you please describe in detail your complete Sequence job design? Include all options and triggers (etc) please.

Probably. For planning purposes.