Troubleshooting Informatica Error Messages and Resolution – Part 96

CMN_1801Error: Lookup <Lookup transformation name> and Lookup <Lookup transformation name> with cache file name prefix <prefix name> are setup for partitioned cache but have condition columns in different order.
Cause:You added hash auto-keys partition points to two Lookup transformations that are configured to share a named cache, but the condition columns for the transformations do not match. When you use cache partitioning with a named cache, the condition columns in the Lookup transformations must be identical and in the same order.
Action:Remove the hash auto-keys partition points from the Lookup transformations.
Action:Configure the Lookup transformations with identical condition columns. Verify that they are in the same order.

CMN_1802ERROR: Some cache files with name prefix [name prefix] for Lookup [Lookup transformation name] are missing or invalid.
Cause:You ran a session with multiple partitions that uses a named persistent lookup cache, but the Integration Service cannot access some of the cache files.
Action:Verify the Integration Service can access all cache files for each partition. Or, remove all existing persistent named cache files and run the session again. If all named persistent cache files do not exist, the Integration Service rebuilds the persistent cache files.
CMN_1804Cache cannot be empty when running in recovery mode.
Cause:You enabled recovery for a session. The session failed during the session run. Before you started the recovery session, the cache was emptied. This is not allowed.
Action:When a session configured for recovery fails, make sure that the cache is not emptied before starting the recovery session.

CMN_1806 Failed to get information for file <cache file>. Error message: <error message>.
Cause:The Integration Service could not read the recovery cache file.
Action:See the additional error message for more information.

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 *