Troubleshooting Informatica Error Messages and Resolution – Part 380

SQLServerF1

TM_6188Session sort order <sort order name> is incompatible with the Informatica Server’s codepage <code page name>.
Cause:You configured a session using a PowerCenter Client configured for relaxed data code page validation, but the Integration Service is configured to validate data code pages.
Action:If you want to run sessions using relaxed sort order selection, configure the Integration Service for relaxed data code page validation.
or
Action:If you want to validate data code pages and session sort order, configure the PowerCenter Client to validate data code pages and configure the session to use a sort order that is compatible with the Integration Service code page.

TM_6190ERROR: Could not uniquely determine relational connection or application connection that is used as $Source or $Target for a lookup or stored procedure transformation.
Cause:You specified either the $Source or $Target variable in the Location Information property in a Lookup transformation. The mapping has more than one relational source or relational target database connection.
Action:On the General Options settings in the Properties tab of the session properties, enter a database connection for either $Source Connection Value or $Target Connection Value.
or
Cause:You specified either the $Source or $Target variable in the Connection Information property in a Stored Procedure transformation. The mapping has more than one relational source or relational target database connection.
Action:On the General Options settings in the Properties tab of the session properties, enter a database connection for either $Source Connection Value or $Target Connection Value.

TM_6200Error: Session Log path exceeds limits of <session log path limit> characters <session log path>.
Cause:The session log path you specified is longer than the session log path limit.
Action:Enter a session log path that is within the session log path limit. You may need to specify a different directory or shorten the length of the name of the log file.

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 *