Troubleshooting Informatica Error Messages and Resolution – Part 76

SQLServerF1_Header_Small

CMN_1063ERROR: Multiple match found in lookup.
Cause:In a Lookup transformation, you specified the Lookup Policy on Multiple Match option to return this error message when encountering multiple occurrences of data.
Action:If you do not want an error message when multiple matches occur in the lookup table, change the Lookup Policy on Multiple Match option.
CMN_1064Error in lookup SQL statement prepare.
Same as CMN_1055.

CMN_1065Error in lookup SQL statement execute.
Same as CMN_1055.
CMN_1066Error in lookup SQL statement fetch.
Same as CMN_1055.
CMN_1075ERROR: Data overflow.
Cause:A numeric data overflow occurred. One of the rows exceeded the declared precision in the target column. The Integration Service writes that row to the session reject file, and sometimes to the session log, depending on the session tracing level. If you enabled row error logging, the Integration Service writes the row to the error log.
Action:Check the session reject file or error log to find the row. If this is a recurring error, you may want to change the precision of the target transformation column.
CMN_1076Error creating database connection.
Cause:The configuration parameters for the database may be incorrect.
Action:Check the database connection defined in the Workflow Manager.
or
Cause:The database or network may be down.
Action:Make sure they are both up before running the session again.

CMN_1077Lookup table not found in the database.
Cause:The lookup table may have been deleted or renamed since the mapping was last saved.
Action:Check the name of the lookup table in the mapping and in the database. Make sure the names match.
CMN_1078Error accessing synchronization object.
Cause:Internal error.
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.

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 *