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
Unable to run job --2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
Unable to run job --2
i need to know datastage
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Getting same error message
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.
"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.