row out of sequence in aggregator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
row out of sequence in aggregator
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
thanks,
sudhakar
i need to know datastage
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
i am giving some more specification regarding row out of seq
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
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
i need to know datastage
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: i am giving some more specification regarding row out of
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.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com