Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"TE_7072/TE_7073 Aggregate Error: Expecting keys to be descending/ascending" running a PowerCenter session with an Aggregator transformation
Problem Description

When running a PowerCenter session with an Aggregator transformation, one of the following errors occur:

TE_7072 Aggregate Error: Expecting keys to be descending

TE_7073 Aggregate Error: Expecting keys to be ascending

Cause
This issue occurs when you select the Sorted Input option in an Aggregator transformation. However, the data entering the Aggregator transformation is not sorted. When this option is enabled the source records must be ordered before they are sent to the Aggregator.
Solution

To resolve this issue, sort the data before the Aggregator transformation, or clear the Sorted Input option. You can sort the data using the Sorted Ports option in the Source Qualifier transformation, or you can use an SQL override with an ORDER BY clause.

More Information

After reading the second row, if the value of the field (marked as a group by port in the Aggregator) in the first row is less than the value in the second row, then the Aggregator transformation will assume the data is in ascending order, otherwise it assumes the data is in descending order.
If the field value in the third row is not in the same order as that which the Aggregator has determined after reading two records, then this error occurs.

Using the Oracle DESC keyword

A session with a Source Qualifier containing the following SQL override may still fail with this error if the Aggregator groups on more than just COL4:

SELECT * FROM EMP
ORDER BY COL1, COL2, COL3, COL4 DESC

Although the SQL in the SQL override appears correct, if the source is in an Oracle database it needs to be of the following form:

SELECT * FROM EMP
ORDER BY COL1 DESC, COL2 DESC, COL3 DESC, COL4 DESC

This will sort all the columns in descending order.

Applies To
Product: PowerCenter
Problem Type:
User Type: Developer
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference
For more information, see PowerCenter Transformation Guide > "Aggregator Transformation" > "Using Sorted Input"
Attachments
Last Modified Date:6/13/2011 4:05 AMID:10954
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)