Troubleshooting Informatica Error Messages and Resolution – Part 86

CMN_1657Error: Lookup Transformations <transformation name> and <transformation name> have the same cache file name prefix <cache file name> but have different override strings <override string> vs. <override string>.
Cause:Two Lookup transformations have different query overrides, but have the same cache file name.
Action:If you want to share the cache, use the same query override. If you do not want to share the cache, change the cache file name for one of the Lookup transformations.

CMN_1658Error: Lookup Transformations <transformation name> and <transformation name> have the same cache file name prefix <cache file name> but correspond to different tables <table name> vs. <table name>.
Cause:Two Lookup transformations use different lookup tables, but have the same cache file name.
Action:If you want to share the cache, the lookup table names must match. If you do not want to share the cache, change the cache file name for one of the Lookup transformations.
CMN_1659Error: Condition column <column name> of Lookup <transformation name> (with existing cache) was not found in Lookup <transformation name> (that is trying to find one to share) even though they have the same cache file name prefix <cache file name>.
Cause:When you have multiple Lookup transformations in a mapping, the first lookup creates a cache file. The second lookup tries to use the same cache file, but cannot because the condition does not match. Because both lookups use the same cache file name, the second lookup cannot create a new cache file.
Action:If you do not want to share the cache, change the cache file name for one of the lookups. If you want to share the cache, make sure the shared transformations use the same ports in the lookup conditions.

CMN_1660Error: The number <number> of condition columns of Lookup <transformation name> is different from <number> Lookup <transformation name> even though they have the same cache file name prefix <prefix name> and <cache file name> needs to be refreshed / updated.
Cause:The second Lookup transformation uses a subset of condition columns of the first Lookup transformation. However, the second Lookup transformation needs to refresh the cache. The number of condition columns must be the same.
Action:If you do not want to share the cache, change the cache file name for one of the Lookup transformations. If you want to share the cache, make sure the shared transformations use the same ports in the lookup conditions.

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 *