Page 1 of 1

Unable to run job --2

Posted: Mon Jun 18, 2007 4:12 am
by sudhakar_viswa
Hi,

I am getting the follwoing error in Parallel edition.

unable to run job --2

The above fatal error is occuring in Transformer (both Transformer and basic Transformer).


Thanks,
-- sudhakar

Posted: Mon Jun 18, 2007 5:44 am
by ray.wurlod
Not enough information.

For example, how can you assert that "The above fatal error is occuring in Transformer (both Transformer and basic Transformer)."? What proof do you have of this? What other error/warning messages were there that you have elected not to post?

Posted: Mon Jun 18, 2007 5:58 am
by sudhakar_viswa
Hi Ray,

In logs it is showing as it is occuring in transformer.

Thanks,
-- sudhakar

Posted: Mon Jun 18, 2007 6:00 am
by chulett
Post the full errors you are getting.

Posted: Mon Jun 18, 2007 3:03 pm
by ray.wurlod
We can not see your job logs. Right now your question is in the "my car won't start, what's wrong with it?" category.

Getting same error message

Posted: Wed Jun 20, 2007 10:36 pm
by Hesubo
I was getting the same uninformative error message in our job tonight:

"ODBCTORURLOGSUM, 0:Unable to run job --2"

The ODBCTORURLOGSUM refers to the name of a container stage that includes an ODBC stage used to update data in a SQL server table. We are using the container stage to incorporate the Server ODBC stage because an ODBC connecion was not available in Px.

After additional research it appears the root cause of this failure was that this job had failed with other errors earlier tonight and left a phantom process running. After killing that phantom process, recompiling the job ( I don't really lthink the recompile was necessary) and resubmitting the job it ran to successful completion.

Not sure if that help resolve your error or not, but thought I would offer our experience.