DSXchange

Hi, I have executed a job and encountered this error. Hope you guys out there can help me out. I have no idea what it is talking about. Someone help!!

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

Hi,

From your error message I think your database table partition and datastage partition are not same. Just change the partition type to DB2 if your database is DB2 otherwise use "Hash" partition. Don't use "Same".

Regards
Amitava