irreconcilable constraints

pkothana · Post by **pkothana** » Thu Dec 18, 2003 11:38 am

My job consists of 2 join stages to join 3 Datasets. When i run this job it aborts immediately with the following error message.

"main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel APT_JoinSubOperator in JnsTgtCol_1.

The number of partitions is already constrained to 1,but an eSame partitioned input virtual dataset produced by

parallel inserted tsort operator {key={value=GUEST_I}} has 4."

Can anybody please explain what is the error and how can i resolve it.

Regards
Pinkesh

vzoubov · Post by **vzoubov** » Thu Dec 18, 2003 2:48 pm

pkothana wrote:My job consists of 2 join stages to join 3 Datasets. When i run this job it aborts immediately with the following error message.

"main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel APT_JoinSubOperator in JnsTgtCol_1.

The number of partitions is already constrained to 1,but an eSame partitioned input virtual dataset produced by

parallel inserted tsort operator {key={value=GUEST_I}} has 4."

Can anybody please explain what is the error and how can i resolve it.

Regards
Pinkesh

Pinkesh,

Can you send me the osh script?

Vitali.

pkothana · Post by **pkothana** » Sat Dec 20, 2003 1:46 am

Hi,
I got some info on the problem I'm facing.

I have two jobs that are creating Data Sets as the output. After that one job merges these two data sets to create the final sequential file output.

When I run the jobs with One Node configuration, everything works fine. But when I run the jobs with 4 node configuration, the Merge Job Aborts with Irreconcilable Constraints Error.

If in place of Data Sets output, i use Sequential File outputs, the jobs are working fine in both 1 node and 4 node configuration.

Can anybody help me in this regard.

Appreciate Your Prompt Response.

Thanks & Regards
Pinkesh

vzoubov · Post by **vzoubov** » Sat Dec 20, 2003 12:37 pm

pkothana wrote:Hi,
I got some info on the problem I'm facing.

I have two jobs that are creating Data Sets as the output. After that one job merges these two data sets to create the final sequential file output.

When I run the jobs with One Node configuration, everything works fine. But when I run the jobs with 4 node configuration, the Merge Job Aborts with Irreconcilable Constraints Error.

If in place of Data Sets output, i use Sequential File outputs, the jobs are working fine in both 1 node and 4 node configuration.

Can anybody help me in this regard.

Appreciate Your Prompt Response.

Thanks & Regards
Pinkesh

Pinkesh,

Try to set the Preserve partitioning flag to Clear for your data sets. You'll find it on the Stage properties Advanced tab.

Vitali.

rdesu · Post by **rdesu** » Fri Oct 16, 2009 6:42 am

Thanks a ton Vitali.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 16, 2009 2:30 pm

Moderator: please move this thread to Enterprise Edition (parallel) forum

unnikrishnan Nair · Post by **unnikrishnan Nair** » Fri Apr 30, 2010 8:10 am

unni wrote:Thanks a ton Vitali.

DSXchange