After upgrading PowerCenter client from 8.6.1 any HotFix to 9.0.1 HotFix 2, SAP plug-ins are inaccessible and the following appears:
Error: Failed to Load DLL: pmsapr3plg.dll for Plug-in: PC_BAPI, vendor Informatica %1 is not a valid Win32 application. Error: Failed to Load DLL: pmsapbw.dll for Plug-in: PC_BAPI, vendor Informatica %1 is not a valid Win32 application.
This issue occurs when Dll registration reference in the Windows Registry is not complete.
Running PWX_SAP.reg to re-register the Dlls does not resolve the issue. PWX_SAP.reg adds the following values to the Windows registry:
[HKEY_LOCAL_MACHINE\SOFTWARE\Informatica\PowerMart Client Tools\9.0.1\Plugins\Informatica]"PC_BAPI"="sapbapidsaiclnt.dll""PC_OHS"="sapohsdsai.dll""PC_SAPR3"="pmsapr3plg.dll""PC_SAPBW"="pmsapbwc.dll"
During the upgrade. An issue may occur during unregistering of 8.6.1 dlls and register of 9.0.1 dlls.
To resolve the issue that occurs while unregistering 8.6.1 dlls and registering 9.0.1 dlls , do the following:
1. Ensure that the following PowerExchange for SAP dlls exist in the <PowerCenter installation directory>\client\bin directory:
05/18/2004 12:00AM 8,495,104 icudt26l.dll11/12/2010 09:55AM 8,847,360 icudt34.dll05/05/2006 12:00AM 606,208 icuin26.dll11/12/2010 09:55AM 843,776 icuin34.dll05/05/2006 12:00AM 528,384 icuuc26.dll11/12/2010 09:55AM 946,176 icuuc34.dll03/20/2006 12:00AM 5,210,112 librfc32.dll08/17/2005 12:00AM 5,619,712 librfc32u.dll08/17/2005 12:00AM 94,208 libsapu16vc71.dll08/17/2005 12:00AM 217,088 libsapucum.dll
If any dll is missing, please refer to the documentation PowerExchange for SAP NetWeaver User Guide for PowerCenter > Getting Started with PowerExchange for SAP NetWeaver > Installing and Configuring PowerExchange for SAP NetWeaver > Installing the SAP RFC SDK Libraries to get the dll's
2. Remove entries from Windows Registry (a full registry backup is recommended)
2.1 Open Windows Registry editor using Start>Run>Regedit. 2.2 Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Informatica\PowerMart Client Tools 2.3 If 8.6.1 folder exists, right-click and delete it. 2.4 From the 9.0.1\Plugins\Informatica folder, delete the following entries:
"PC_BAPI"="sapbapidsaiclnt.dll" "PC_OHS"="sapohsdsai.dll" "PC_SAPR3"="pmsapr3plg.dll" "PC_SAPBW"="pmsapbwc.dll"
3. Run PWX_SAP.reg again from <PowerCenter installation directory>\Client\bin.
4. Start PowerCenter Designer tool and verify if SAP plug-ins are accessible.
What can we do to improve this information (2000 or fewer characters)