Troubleshooting Informatica Error Messages and Resolution – Part 89

CMN_1683Error: Static Lookup <lookup> needs to delete a cache file <cache file name> that was created by a Dynamic Lookup <transformation name> in an earlier TLOG using different parameters.
Cause:In a previous target load order group in a mapping, a dynamic Lookup transformation created a cache file. A static Lookup transformation uses the same cache file name and cannot delete it.
Action:Use unique cache file names for the transformations.

CMN_1684Error: Dynamic Lookup <transformation name> needs to delete a cache file <cache file name> that was created by a Static Lookup <transformation name> in an earlier TLOG using different parameters.
Cause:In a previous target load order group in a mapping, a static Lookup transformation created a cache file. A dynamic Lookup transformation uses the same cache file name and cannot delete it.
Action:Use unique cache file names for the transformations.
CMN_1686Error allocating <number of bytes requested> in memory for cache transformation: <transformation name>.
Cause:You specified a cache size larger than the system can allocate.
Action:Either reduce cache size for the transformation or increase virtual memory available in the machine.
CMN_1687Error: Cache not enabled for Dynamic Lookup transformation <transformation name>.
Cause:In the session, you disabled caching for a Lookup transformation that you configured to use as a dynamic cache.
Action:If you configure a Lookup transformation with a dynamic cache, you must enable caching in the session.

CMN_1689Failed to allocate <number> bytes from process memory for [DTM Buffer Pool].
Cause:There is insufficient process memory.
Action:Reduce the DTM buffer pool size, or free system resources.
CMN_1691Cache expects port <port name> but cache file has it in a different data type and cannot be used. A new cache file will be created.
Cause:Two Lookup transformations are configured to share a lookup cache, but the datatypes of the cached columns in the Lookup transformations do not match.
Action:If you are using a named cache, verify that the caching structures match. If you are using an unnamed cache, verify that the caching structures are compatible.

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.

Thanks,
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 *