Job aborts when run with Node 2 or more

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sharma
Premium Member
Premium Member
Posts: 46
Joined: Mon Dec 24, 2007 2:16 pm

Job aborts when run with Node 2 or more

Post by sharma »

Hi,

I am running a job that process 3.5 millions rows ,reading from a file and after processing inserting to DB tables.

When i run that Job with Node 1 then its is running fine but when i try to run it either by Node2 or Node 4 then it aborts with an error message:

Message: APT_CombinedOperatorController(2),0: ERROR: Attribute 'c0' not found.
Message: order_nw_stg,0: Failure during execution of operator logic.

Why is it happening??


Regards
~Nirmal
Nirmal Sharma
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

If you using Transformer in the job, trun of the operator combination by changing the following CombinabilityMode to Dont Combine in Stage properties to find what the exact error is.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What is "c0" in your job?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sharma
Premium Member
Premium Member
Posts: 46
Joined: Mon Dec 24, 2007 2:16 pm

Post by sharma »

I truned off the operator combination and again ran the job on 3.5 million records.
Again in the end it aborts with the below erroe message.

order_nw_stg,0: ERROR: Attribute 'c0' not found
order_nw_stg,0: Failure during execution of operator logic.

There is nothing as 'c0' in my Job.I checked again in the order_nw_stg stage.

It is working fine if i run with node 1.
But whenever i try to run with node2 or more its fails with the above error message.
Nirmal Sharma
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Re: Job aborts when run with Node 2 or more

Post by John Smith »

sharma wrote:Hi,

I am running a job that process 3.5 millions rows ,reading from a file and after processing inserting to DB tables.

When i run that Job with Node 1 then its is running fine but when i try to run it either by Node2 or Node 4 then it aborts with an error message:

Message: APT_CombinedOperatorController(2),0: ERROR: Attribute 'c0' not found.
Message: order_nw_stg,0: Failure during execution of operator logic.

Why is it happening??


Regards
~Nirmal
Just to clarify are you talking about running with more than 1 node e.g using a different config file to run with 2 nodes or more? How do you run on Node2 ? Just curious.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please post your one-node configuration file and job score and your two-node configuration file and job score. Enclose each in Code tags for easier visibility.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply