Troubleshooting Informatica Error Messages and Resolution – Part 95

SQLServerF1_Header_Small

CMN_1784Connect string [connection name in Location Information property] too long. Maximum length allowed is <maximum length>.
Cause:In the Location Information session property for a Lookup transformation, you specified a database connection name that is too long.
Action:Edit the database connection name in either the Relational or Application Connection Browser.

CMN_1785Lookup SQL override [Lookup transformation] has references to mapping parameters or variables that cannot be resolved correctly.
Cause:You referenced a mapping parameter or variable in the lookup SQL override, but the Integration Service could not resolve the parameter or variable to text.
Action:Edit the lookup SQL override and verify you spelled the mapping parameter or variable correctly. Also, verify you declared the mapping parameter or variable in the mapping.
CMN_1786Error: Failed to update row for Lookup [Lookup transformation].
Cause:The Integration Service failed to update the row in the dynamic lookup cache.
Action:Check the session log for related error messages.
CMN_1796An error was encountered while writing prior message(s) to this log file. Those messages may be lost. Please check for available disk space.
Cause:The Integration Service encountered an error when writing to the server log file, most likely because the machine that hosts the server log file ran out of disk space. Any messages related to the task the Integration Service was performing at the time may have been lost.
Action:Check the available space on the machine that hosts the server log file.

CMN_1800Error: Lookup <Lookup transformation name> with cache file name prefix <prefix name> is setup for <number of partitions> partitions but another Lookup <Lookup transformation name> with the same cache file name prefix is setup for <number of partitions> partitions.
Cause:You configured two Lookup transformations in a mapping to share a named cache, but you configured only one transformation for cache partitioning. The Integration Service cannot share a partitioned cache with a non-partitioned cache.
Action:Edit the session properties and configure either both Lookup transformations with a hash auto-keys partition point or neither with a hash auto-keys partition point.
or
Action:Edit the mapping so that the Lookup transformations do not share a cache.
or
Cause:You configured two Lookup transformations in separate target load order groups to share a named cache, but you configured a different number of partitions for the target load order groups.
Action:Edit the session properties and configure the same number of partitions for each Lookup transformation.
or
Action:Edit the mapping so that the Lookup transformations do not share a cache.

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 *