Installing PIM and IDQ on the same box

Conflicts between PIM and IDQ Developer leading to PIM service failure

If you’re running PIM and IDQ Developer on the same host and observe the stoppage of the Informatica PIM Server Windows service after DQ rule execution with a similar message:

Connecting to server ‘hpm-single-server’ (protocol: HLR-TCP, server: localhost, port:1721) broken.

Example of bad configured Windows environment variables:

IMF_CPP_RESOURCE_PATH= C:\Informatica\9.5.1\clients\DeveloperClient\bin

INFA_RESOURCES=C:\Informatica\9.5.1\clients\DeveloperClient\bin

In the PIM Desktop client the error looks like the server terminates connection and the console.log contains:

ERROR | wrapper | 2014/10/14 04:17:32 | JVM exited unexpectedly.

STATUS | wrapper | 2014/10/14 04:17:33 | Automatic JVM Restarts disabled. Shutting down.

STATUS | wrapper | 2014/10/14 04:17:33 | <-- Wrapper Stopped

The solution is to unset the following Windows environment variables: INFA_RESOURCES and IMF_CPP_RESOURCE_PATH.

If you’re getting DQ Rules failed with the following error:

Error message: The rule 'RULENAME' could not be executed due to an error. The execution of mapping [MAPPINGNAME] failed. [com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] DTM error in initDTM]

You have to unset IMF_CPP_RESOURCE_PATH Windows environment variable.

After unsetting variables you have to restart the Informatica PIM Server service to let the changes take effect. Then you will be able to execute the DQ Rules successfully.

Data Quality related problems during server start or Data Quality Execution

When installing the server or setup a workspace for the SDK, ensure that the installation folder itself is as short as possible.
Otherwise this can lead to server crashes or errors during server startup or during execution of data quality rule mapplets because of some internal plugins and working folders as sub folder of the installation path exceed the length of 255 characters.
Errors of this kind may look like this:

EXCEPTION_UNCAUGHT_CXX_EXCEPTION (0xe06d7363) at pc=0x00007ffa4e169129, pid=4928, tid=0x0000000000005078
#
# JRE version: OpenJDK Runtime Environment (Zulu 8.38.0.13-CA-win64) (8.0_212-b04) (build 1.8.0_212-b04)
# Java VM: OpenJDK 64-Bit Server VM (25.212-b04 mixed mode windows-amd64 compressed oops)
# Problematic frame:
# C  [KERNELBASE.dll+0x39129]

java.lang.AssertionError: ProblemLog contains errors: null: The rule 'rule mapplet name' could not be executed due to an error. 
The execution of mapping [rule mapplet name] failed. [com.informatica.sdk.dtm.ExecutionException: 
[EdtmExec_00007] Parser Transform could not load the dictionary [Dictionary name]]