Troubleshooting Informatica Error Messages and Resolution – Part 379

SQLServerF1

TM_6111Warning! The data cache size for a session is recommended not to exceed <number> bytes. The specified data cache size is <number> bytes.
Cause:The data cache size for the session exceeded the recommended size.
Action:Verify the data cache size in the session properties.
TM_6112Warning! The buffer block size for a DTM is recommended not to exceed <number> bytes. The specified buffer block size is <number> bytes.
Cause:The buffer block size for the Data Transformation Manager exceeded the recommended size.
Action:Verify the buffer block size in the session properties.

TM_6154Error in setting session sort order: <sort order>.
Cause:You selected a sort order that is invalid with the code page.
Action:Select a valid sort order for the selected code page.
TM_6157Error parsing stored procedure call text <stored procedure>.
Cause:The Integration Service cannot parse the stored procedure text. There might be a syntax error in the stored procedure.
Action:Check the syntax of the stored procedure. Test the stored procedure in the database. Then run the session again.
TM_6159Error executing stored procedure… [return value from database] [error message from database].
Cause:The context for executing the stored procedure might be invalid.
Action:Verify the stored procedure in the database. Check the database error messages for further explanations.

TM_6186Stored procedure call text <call text> contains character(s) that is(are) not valid in the codepage of the stored procedure database connection. The invalid character starts at position <character position> of the query.
Cause:The stored procedure call text for a pre-target or post-target stored procedure contains one or more characters that are not in the character set of the stored procedure database code page.
Action:Identify the invalid character referenced in the session log. Edit the call text so that the stored procedure call text contains characters encoded in the character sets of both the Integration Service code page and the stored procedure database code page.
You can also configure the stored procedure database to use a code page that contains encoding for the store procedure data character set and is compatible with the Integration Service code page.
or
Cause:The stored procedure database uses a code page that is not supported by PowerCenter.
Action:Select a code page for the stored procedure database that is supported by PowerCenter and contains encoding for the stored procedure database character set.

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 *