irreconcilable constraints

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
laxmi_etl
Charter Member
Charter Member
Posts: 117
Joined: Thu Sep 28, 2006 9:10 am

irreconcilable constraints

Post 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)
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Did you try searching ?
Do an exact search on keywords "irreconcilable constraints"
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... and you'll find your duplicate post - please delete it before anyone replies to it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
boppanakrishna
Participant
Posts: 106
Joined: Thu Jul 27, 2006 10:05 pm
Location: Mumbai

Post by boppanakrishna »

hi ,
Better try keeping the Partitioning method to "Clear" in the stage which you are getting this

Thanks
Boppana
Post Reply