TM_6281 error on Sorted Aggregator

[MacLeod72]

Good morning-

I have created a session in which I have added an aggregator. When I select the "Sorted Input" property, I get the following error:

TM_6281: Partitioning option license required to run sessions with user-defined partition points.

When I de-select the "Sorted Input" property, it runs fine but it spends needless time caching my entire table to file. Does anyone know why this might be happening and/or a possible resolution?

Thanks in advance,

--Rob

 

[MacLeod72]

I apologize; I forgot to mention that I am using Informatica 7.1.3.

Thanks!

--Rob

 

[MacLeod72]

I again apologize; I forgot to check the knowledge base. In case anyone else encounters this:

To run a PowerCenter session with a sorted Aggregator transformation set the server parameter AggSupprtWithNoPartLic to "Yes" as follows:

Unix
Using a text editor open the PowerCenter server configuration (pmserver.cfg) file.

Add the following entry to the end of the file:

AggSupprtWithNoPartLic = Yes

Re-start the PowerCenter server (pmserver).

Windows
To set this parameter on Windows refer to article 11486

(article 11486)
To add a PowerCenter Server parameter (that is not in the server configuration dialog) on Windows enter it in the registry as follows:

Click Start, click Run, type regedit, click OK.
Go to the following registry key:
HKEY_LOCAL_MACHINE\ SYSTEM\CurrentControlSet\Services\PowerMart\Parameters\Configuration

On the Edit menu, point to New, and then click String Value.
Enter the String Value "SERVER_PARAMETER".
Go to Edit > Modify.
Enter "VALUE" and then click OK
Re-start the PowerCenter server (Informatica Service).
Where SERVER_PARAMETER is the name of the parameter and VALUE is the setting of the parameter.

Sorry!

--Rob