Troubleshooting Informatica Error Messages and Resolution – Part 92


CMN_1767 Failed to ftell file <filename>: Error Msg <error message>.
Cause:Operating system error.
Action:Contact your internal technical support.
CMN_1768 Failed to truncate file <filename>: Error Msg <error message>.
Cause:The Integration Service could not truncate the specified cache file.
Action:Check the additional error message for more information.

CMN_1769Inconsistent recovery cache.
Cause:The Integration Service cannot run the session enabled for recovery because the recovery cache file does not contain valid data.
Action:Delete all recovery cache files associated with the session and run the session with recovery disabled to create a new cache file. To determine which recovery cache file is associated with the session, compare the time at which the file was last modified with the time the session failed. If the times are the approximately the same, you can associate the cache file with the session.
You can also refer to the cache file names to determine which files are associated with the session. Recovery cache file names use the following format:
pmgmd_metadata_<repository ID>_<workflow ID>_<folder ID>_<session ID>_<transformation ID>_<partition ID>_<group ID>_<checkpoint ID>_<sequence number>.dat
For example, in the following file name, the session ID is 102:
Use the REP_LOAD_SESSIONS MX View on the repository database to determine the name of the session associated with the session ID. You can use REP_LOAD_SESSIONS to view information about reusable sessions.

CMN_1770 Recovery cache consumer is registered more than once.
Cause:Internal error.
Action:Contact Informatica Technical Support.
CMN_1771The connection [database connection] specified is ambiguous. The connection name exists in both relational and application connections.
Cause:In the Location Information session property for a Lookup transformation, or the Connection Information session property for a Stored Procedure transformation, you specified a database connection name that exists as both a Relational and Application database connection. When the Integration Service runs the session, it cannot determine which connection to use.
This might occur when you specify the database connection name for the transformation in the Designer and then create a session using the mapping. Or, this might occur when you type the connection name in the session property.
Action:In the session properties, select the correct database connection name for the Lookup or Stored Procedure transformation.

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 *