Aggragator Issue

[myukassign]

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.

[chulett]

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.

[satya99]

Before you push data into aggregator stage, Use a sort stage.

In sort stage you perform the sort operation

[myukassign]

Alrt!~

thanks for the reply

[chulett]

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?