I am getting the folloing error while using aggragate stage. CAn you tell me how can I give sort number and sort order for multiple column without getting error?
The error I am getting is like below
Agragator..Aggregator_1: Row out of sequence
At row 3, link "DSLink3"
Row out of sequence
I am doing the following.
Step 1: I have a sequential file source with 3 columns
Name Place Population
Arun Italy 10000
John America 5000
Step 2: I mentioned Name as Key in the Sequntial file source
Step 3: In the aggragator input page I put liek the the folloing.
Column Sort SortOrder Key
Name 1 ascending checked
Place 2 ascending unchecked
Population 3 ascending unchekcked
Step 4: In the aggragator output stage i put the folloing
Column group derivation Key
Name Checked name checked
Place Checked Place unchecked
Population unchekcked Avg(Population) unchekced
Step 5: Run and I am getting error above.
Aggragator Issue
Moderators: chulett, rschirm, roy
Row out of Sequence means the Sort order you asserted in the stage does not match the sort order of the incoming data. You are aware that with those settings you are telling the stage how the incoming data is sorted, not asking it to "sort" it in that order, yes?
If your incoming data is not sorted in a manner that supports the aggregation / grouping being done, then remove all of that 'sort' information from the stage.
If your incoming data is not sorted in a manner that supports the aggregation / grouping being done, then remove all of that 'sort' information from the stage.
Last edited by chulett on Wed Jul 30, 2008 9:49 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
You don't need to introduce a Sort stage into your job but you do need to understand how your data is (or isn't) sorted and how that relates to the Sort settings in the Aggregator stage, especially when compared to the grouping being done.
What was your resolution?![Confused :?](./images/smilies/icon_confused.gif)
What was your resolution?
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers