Troubleshooting Informatica Error Messages and Resolution – Part 99


CMN_1927Error: Unable to set null character.
Cause:Internal error.
Action:Contact Informatica Technical Support.
CMN_1928External loader error. Upsert is not valid for target instance [target definition name] since update is not valid for the target.
Cause:The Integration Service cannot perform upserts on the Teradata target table.
Action:Verify the target table has a primary key and that the primary key column in the target definition is connected to an upstream transformation.

CMN_1929External loader error [error message].
Cause:The Integration Service cannot generate the Teradata control file because some control file option values are missing, such as the TPDID value.
Action:Edit the external loader connection in the session and enter a value for all options.
CMN_1986Service <service name> encountered an error while communicating with Licensing Service: <error code and message>.
Cause:The service encountered an error while communicating with the Licensing Service.
Action:See the additional error message for more information.
CMN_1989Service <service name> is not licensed to execute on node <node name>.
Cause:The service is not licensed to run on the operating system of the node.
Action:Get a license to run the service on the operating system.
Action:Configure the service to run on a different node that has the appropriate license.

CMN_2005Unable to create log file <log file name>: <error>.
Cause:The log directory is not valid or does not have enough disk space.
Action:Verify the path and the directory for $PMWorkflowLogDir and $PMSessionLogDir in the Integration Service configuration, workflow properties, and session properties. The user who starts the Informatica Service on the node must have permissions to write to the directory.
Action:Create a small file in the log directory to ensure that you are not out of disk space.

Above are list of Informatica Error Messages or Warnings received while performing certain operation against Informatica related products.

What are Informatica Error Messages?

Informatica error codes are a set of error codes for use by all Informatica products. Every Informatica error message returned by Informatica, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

SQLServerF1 Team
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *