Friday, May 30, 2008

Administration Console hangs when logging in using host name

Administration Console hangs when logging in using host name
Problem Description
The Administration Console is displayed however after entering the user name and password, the page appears to hang. Domain will be running and accessible by command line tools such as infatest .
Domain may be accessed using localhost and not the machine host name is entered into Administration Console URL.

Cause
The fact that the Administration Console can be accessed via the localhost string indicates there is a fault with DNS. PowerCenter will use DNS to check back on host names and IP addresses.
Solution
To resolve this issue identify which machines on the network are acting as DNS servers and check their configuration ensuring that entries for machines used by PowerCenter (database server, client machines, PowerCenter nodes) are correct.
Applies To
PowerCenter 8.1.x

PowerCenter 8.5

Thursday, May 29, 2008

HOW TO: Set the PowerCenter service Custom Properties
Solution
To add an undocumented PowerCenter parameter (Integration Service or Repository Service Custom Property ) do the following in the Informatica PowerCenter (8.1.x or 8.5.x) Administration Console:
Stop the Integration Service (or Repository Service).
Select the Integration Service (or Repository Service).
Under the Properties tab, click Edit in the Custom Properties section.
Under Name enter the name of the undocumented parameter.
Example:
XMLinUTF8
Enter the value for the parameter under Value .
Example:
AggSupprtWithNoPartLic = Yes
Click OK .
Start the Integration Service (or Repository Service

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."