Page 1 of 1

irreconcilable constraints

Posted: Thu Mar 15, 2007 3:43 pm
by laxmi_etl
Hi,

Can anybody tell me why I am getting the fallowing error

main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel APT_DBExportOperator in oracle_Enterprise_12.
The number of partitions is already constrained to 2,
but an eSame partitioned input virtual dataset produced by
sequential APT_TransformOperatorImplV15S1_jobname_Transformer_1 in Transformer_1 has 1.
This step has 4 datasets:
ds0: {/u01/Ascential/dev/michaels/tld/PosTrans2.ds
[pp] ->eCollectAny
op0[1p] (sequential Copy_of_PosTrans2Ds)}
ds1: {op0[1p] (sequential Copy_of_PosTrans2Ds)
[pp] ->eCollectAny
op1[1p] (sequential APT_TransformOperatorImplV15S1_Loadosrans_Transformer_1 in Transformer_1)}
ds2: {op1[1p] (sequential APT_TransformOperatorImplV15S1_Loadosrans_Transformer_1 in Transformer_1)
[pp] eSame<>eCollectAny
op2[2p] (parallel APT_DBExportOperator in oracle_Enterprise_12)}
ds3: {op2[2p] (parallel APT_DBExportOperator in oracle_Enterprise_12)
eAny>eCollectAny
op3[] (parallel APT_NZWriteSubOperator in oracle_Enterprise_12)}
It has 4 operators:
op0[1p] {(sequential Copy_of_PosTrans2Ds)
}
op1[1p] {(sequential APT_TransformOperatorImplV15S1_Loadosrans_Transformer_1 in Transformer_1)
}
op2[2p] {(parallel APT_DBExportOperator in oracle_Enterprise_12)
}
op3[] {(parallel APT_NZWriteSubOperator in oracle_Enterprise_12)

Posted: Thu Mar 15, 2007 5:28 pm
by DSguru2B
Did you try searching ?
Do an exact search on keywords "irreconcilable constraints"

Posted: Thu Mar 15, 2007 9:32 pm
by ray.wurlod
... and you'll find your duplicate post - please delete it before anyone replies to it.

Posted: Fri Mar 16, 2007 12:43 am
by boppanakrishna
hi ,
Better try keeping the Partitioning method to "Clear" in the stage which you are getting this

Thanks
Boppana