Troubleshooting Informatica Error Messages and Resolution – Part 85

SQLServerF1

CMN_1645Error: Failed to get shared access to cache files <cache file name>. [dat/idx] for lookup <Lookup transformation>.
Cause:One session is trying to read from a cache file while another session is still writing to it.
Action:Wait until the first session completes, then run the session.

CMN_1646Error: Failed to get exclusive access to cache files <cache file name>. [dat/idx] for lookup <Lookup transformation>.
Cause:One session is trying to write to a cache file while another session is reading from it.
Action:Wait until the first session completes, then run the session.
CMN_1647Error: Failed to upgrade to exclusive access for cache files <cache file name> for lookup <Lookup transformation>.
Cause:A session is trying to write to a cache file while another session is reading from the file.
Action:Wait until the first session completes, and then run the session.
CMN_1649Error: Lookup table name <lookup table name> is too long. Maximum allowed length is <number>.
Cause:You exceeded the length allowed for the lookup table name.
Action:Reduce the length of the lookup table name.

CMN_1650A duplicate row was attempted to be inserted into a dynamic lookup cache <Lookup transformation name>. The dynamic lookup cache only supports unique condition keys.
Cause:You configured a Lookup transformation to use a dynamic lookup cache and the lookup table contains duplicate rows.
Action:Eliminate duplicate rows in the lookup table, or use a static cache.
CMN_1655Error: Lookup Transformations <transformation name> and <transformation name> have the same cache file name prefix <cache file name> but have different connect strings <connect string> vs. <connect string>.
Cause:Two Lookup transformations have different connect strings, but have the same cache file name.
Action:Make sure the connect strings match.
CMN_1656Error: Lookup Transformations <transformation name> and <transformation name> have the same cache file name prefix <cache file name> but only the latter has a query override <query>.
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.

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 *