Troubleshooting Informatica Error Messages and Resolution – Part 77

CMN_1079WARNING: Lookup table contains no data.
Cause:The lookup table specified in your mapping contains no data because you specified an invalid lookup table.
Action:Make sure your mapping contains the correct name of the lookup table.
Cause:The lookup table specified in your mapping is empty.
Action:Import or enter the correct data for your lookup table.

CMN_1082ERROR: Invalid lookup condition.
Cause:In a Lookup transformation, the lookup condition is invalid or blank.
Action:Correct the invalid lookup condition.
CMN_1083Error encountered encrypting password…
Cause:Internal error.
Action:Contact Informatica Technical Support.
CMN_1086<Transformation name>: Number of error exceeded threshold number.
Cause:The specified transformation reached the error threshold.
Action:Examine the incoming data and the transformation configuration to locate the problem, then correct the problem. Or increase the error threshold.
CMN_1087ERROR: PowerMart Username not specified.
Cause:You did not specify a user name in the Administration Console.
Action:Enter a valid value for user name.

CMN_1088ERROR: PowerMart Password is not specified.
Cause:You did not specify a password in the Administration Console.
Action:In the Administration Console, enter a valid value for Password. Passwords must be in 7-bit ASCII.
CMN_1089ERROR: Invalid lookup connect string.
Cause:A Lookup transformation contains an invalid location for its lookup table.
Action:Check the location of the lookup table, and then enter the correct location in the Lookup transformation.
CMN_1093ERROR: Invalid join condition supplied.
Cause:A Joiner transformation in your mapping specifies an invalid join condition.
Action:Make sure the condition for each Joiner transformation in the session contains at least one valid join.

Cause:If each Joiner transformation uses valid conditions, you may have repository inconsistencies.
Action:Contact Informatica Technical Support.

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.

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 *