Troubleshooting Informatica Error Messages and Resolution – Part 87

SQLServerF1

CMN_1661Error: Output column <column name> of Lookup <transformation name> (that is trying to find one to share) was not found in Lookup <transformation name> (with existing cache) even though they have the same cache file name prefix <cache file 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.

CMN_1662Error: Output column <column name> of Lookup <transformation name> (that is trying to find one to share) was not found in condition or output columns of Lookup <transformation name> (with existing cache) even though they have the same cache file name prefix <cache file name>.
Cause:The second Lookup transformation uses a subset of output columns of the first Lookup transformation. However, the second Lookup transformation needs to update the cache. The number of output 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.
CMN_1663Error: The number <number> of output columns of Lookup <transformation name> is different from <number> Lookup <transformation name> even though they have the same cache file name prefix <cache file name> and <cache file name> needs to be refreshed / updated.
Cause:The second Lookup transformation uses a subset of output columns of the first Lookup transformation. However, the second Lookup transformation needs to refresh the cache. The number of output 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.

CMN_1664Error: Out of sequence IDs to generate for port <port name> of Lookup <transformation name> for insertion.
Cause:You reached the limit of unique sequence IDs that can be generated for inserting rows in the dynamic lookup cache.
Action:Check the value of this port in the rows that are used to initialize the lookup cache. Try to modify the value.

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 *