Thursday, May 29, 2008

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

Quote: 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? " " 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\Paramet ers\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."

4 comments:

Brian Egge said...

I'm running 8.6.1, and am getting this error. I tried adding the property and restarting, but I'm still not successful. Any other ideas?

Shankar Prasad - Data Science & Artificial Intelligence said...

Try this.... Go to property of union transformation, select "No" option from drop down for "Is partitionable" and un-check the "Required single thread Per Partition".

Girija Sankar said...
This comment has been removed by the author.
Girija Sankar said...

Hi select "No" option from drop down for "Is partitionable" and un checking the "Required single thread Per Partition" please recreate the session. That should resolve the issue.