row out of sequence in aggregator

[sudhakar_viswa]

While running my server job i am getting the error i.e,row out of sequence.what is that and can any body will give the solution to this problem.

thanks,
sudhakar

[kumar_s]

Hi,
Is your input data to aggregator, sorted?
Pls post your full error log.

-Kumar

[kcshankar]

Hi sudhakar,
Welcome aboard.
Is there any Null Values in your input data.

regards
kcs

[ray.wurlod]

This error message usually arises when you have asserted on the input link of an Aggregator stage that the incoming data are sorted and it turns out that they are not sorted, or not sorted in the order you have specified.

Asserting "sorted" on the Aggregator input does not cause sorting to occur; it specifies that the data are known to be sorted, so that the Aggregator can use a more efficient memory-management algorithm.

[sudhakar_viswa]

Hi,

Thanks for your reply.I got this error.


FJ_COUPON_MAIN_copy..Aggregator_54: Row out of sequence
At row 4, link "ln_Read_Data1"
Row out of sequence


I have sent the data inorderly.And i have specified sort order is ascending or descending and sort is 1it is showing the error.I will give sample data


as000123
as000123
as001234
as000123
as001234

The thing is i will do group by this column,because i need only one id for each id.Those are as000123 and as001234.but it is showing error for 4th record.Give me reply asap.

bye sudhakar

[kwwilliams]

Your data is not sorted by your grouping column. The fourth value as000123 is less than your third value as000124. Place a sort stage in front of the aggregator stage and sort based on the columns that you will group by. this will alleviate your problem.

[chulett]

In other words, you lied to the Aggregator stage about the sort order and it is busting you for it.

[kumar_s]

Hi,

As all mentioned, Aggregator requires a sorted input.
Insert a explicit sort stage to sort the data, or use the inline sort option available aggregator.
Make sure you are sorting based on the key you aggregate.

-Kumar

[chulett]

No, it doesn't require sorted input, it just works better with it as long as you also tell it the input is sorted. And it matches the aggregation being done.

There is no 'inline sort option' available in the Aggregator.

[kumar_s]

Oops.. Again.... In line Sort option not available in Server edition.

But still for expected output of aggergation, is it not required that the input should be sorted based on the group by column

-Kumar

[chulett]

No. See previous answer.