Page 1 of 1

AGGR Warning

Posted: Fri Apr 15, 2005 9:15 am
by ds_is_fun
Im running DB2 as source and the PX job has a aggregator stage. I have turned the run time column propagation off.
It still gives me this error
AGGR1: When checking operator: User inserted sort "AGGR1.INPUT_REC4_Sort" does not fulfill the sort requirements of the downstream operator "APT_SortedGroup2Operator in AGGR1"
Thanks!

Posted: Sun Apr 17, 2005 4:14 am
by roy
Hi,
It was alread covered, do a search.

Posted: Sun Apr 17, 2005 10:48 am
by rcil
Here I am trying to give some ideas and not sure where it solves your problem.

Is your source and Agg have the same sort order? If it is not match the sorting columns and sort the order on both and try see if it works.

Good Luck