Job Abort for Funnel Stage

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
bhargav_dd
Premium Member
Premium Member
Posts: 57
Joined: Tue Jun 30, 2009 9:38 am

Job Abort for Funnel Stage

Post by bhargav_dd »

One of my jobs aborted for the following error:

main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel FnlPartys. The number of partitions is already constrained to 2, but an eSame partitioned input virtual dataset produced by parallel All_Owners has 1.

The FnlPartys is a Funnel Stage.All_Owners is Dataset Stage and one of the two links to the funnel stage FnlPartys.

Any help on this would be greatly appreciated.
Shaanpriya
Participant
Posts: 22
Joined: Thu Sep 11, 2008 11:47 pm
Location: Bangalore

Post by Shaanpriya »

Have you specified same partition to the data coming from the dataset?
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Include a copy stage after the dataset with clear partition set.
Leenaz
Participant
Posts: 2
Joined: Mon Mar 16, 2009 1:43 am
Location: None

It worked for me by Change Partioning in DataSET from Defaul

Post by Leenaz »

Sainath.Srinivasan wrote:Include a copy stage after the dataset with clear partition set.
It worked for me by Change Partioning in DataSET from Default (Propogate ) to clear.
Post Reply