Troubleshooting Informatica Error Messages and Resolution – Part 93


CMN_1772Guaranteed Message Delivery cache directory <directory name> does not exist.
Cause:The Integration Service cannot find the cache file directory for message recovery.
Action:Verify that the cache file directory exists. Specify the correct path to the cache file directory in the session properties. If the cache file directory does not exist, create a directory and specify a directory path in the session properties.
CMN_1773Error: Logical connection [database connection] in cache header file [lookup cache file.dat] used by Lookup [Lookup transformation name] is either an invalid connection or it exists in both Relational and Application type connections.
Cause:In a cached Lookup transformation in the Designer, you specified a database connection name that exists as both a Relational and Application database connection in the Workflow Manager. When the Integration Service runs the session, it cannot determine which connection to use.
Action:In the session properties, select the correct database connection name for the Lookup transformation. Or, you can enter “Relational:” before the connection name if it is a Relational connection, or type “Application:” before the connection name if it is an Application connection.
CMN_1774Error: Logical connection [database connection] in Lookup [Lookup transformation name] is either an invalid connection or it exists in both Relational and Application type connections.
Same as CMN_1773.
CMN_1775Recovery cache directory <directory name> is invalid.
Cause:The name for the recovery cache folder is not valid.
Action:From the Properties settings on the sources tab in the session properties, specify a valid path for the recovery cache folder.
CMN_1777The connection [database connection name] specified can not run SQL query; hence can not be used as a lookup or stored procedure connection.
Cause:For a Lookup or Stored Procedure transformation, you selected an Application database connection type that is not a relational database.
Action:Select a Relational database connection, or select an Application database connection based on a relational database, such as a PeopleSoft connection.

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 *