Informatica PowerCenter Installation Known Issues and Solution

  ETL Admin

Since we published the article on informatica installation and configuration, we have been getting questions on different installation issues. So here we thought of writing an article with a consolidated list of issues faced during the installation.  This will be a live article and will be updated as and when we get new issues from the readers.

Database driver event...Error occurred loading library [pmora8.dll]

Cause

This error occurs when the Oracle client installed in the Windows machine is 32-bit and PowerCenter is 64-bit.

Solution

To resolve this issue re-install the Oracle client 64 bit on the machine where PowerCenter 64-bit server is running.

To check which version you use, run TNSPING.

For Oracle 10g, you should have: 32 bits Oracle

C:\oracle\product\10.2.0\client_1\BIN>tnsping
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 04-J┌N-2
008 08:52:08

PowerCenter Informatica Services does not start on Windows

Cause

This issue is caused because the User specified during the installation is not Part of Operating System and Log on as a Service privilege and the user is not part of the Administrator Group.

Solution

Confirm that the Windows user specified in This Account has the following privileges:

• Act as Part of the Operating System 
• Log on as a Service 

by doing the following:

1. Go to Start > Settings > Control Panel > Administrative Tools > Local Security Policy . 
2. Select Local Policies > User Rights Assignment . 
3. Add the user to Act as Part of the Operating System and Log on as a Service.

ERROR: "This installation package can not be opened.." when installing PowerCenter 9.x

Cause

This issue occurs because of the native zip extraction package on Windows, which results in an incomplete extraction with large files or big file names.

Solution

To resolve this issue, use another zip utility such as WinZip, Peazip, or WinRar to unzip the installation package.

ERROR: "Unable to handle request because repository content do not exist" when starting the Integration service

Cause

This error occurs when the PowerCenter Repository Service is running on Exclusive Mode

Solution

To resolve this issue, change the Repository to run on the Normal Mode and restart both the Repository and Integration Services.

Please let us know about any new issues you come across during the Informatica PowerCenter Installation. We wil be more than happy to help you.

Share with your friends