Troubleshooting Informatica Error Messages and Resolution – Part 393

SQLServerF1

TT_11024Port <port name>: Default value data conversion error.
Cause:The Integration Service encountered an error converting data to the user-specified default value for the named port. The Integration Service dropped the row and wrote it to the session log. If you enabled row error logging, the dropped row is written to the error log.
Action:See the session log or error log for the record, and related messages detailing the specifics of the error. You may need to change the default value for the named port.
TT_11041Failed to initialize transformation.
Cause:The Integration Service failed to prepare parameters for input and output ports of External Procedure transformations.
Action:Check the External Procedure transformation input and output parameters.

TT_11070User defined lookup override query <query> contains character(s) that is (are) not valid in the code page of the database connection. The invalid character starts at position <position of character> of the query.
Cause:You entered a lookup override query containing characters that are invalid in the lookup database connection code page.
Action:Change the lookup override query to contain characters included in the lookup database connection code page.
TT_11077The lookup query <lookup query> contains character(s) that is(are) not valid in the codepage of the database connection. The invalid character starts at position <character position> of the name.
Cause:The lookup query contains one or more characters that are not encoded in the lookup database code page.
Action:Identify the invalid character referenced in the session log. Edit the lookup query so that the Integration Service can convert it from the Integration Service code page to the lookup database code page without loss of data.
or
Cause:The lookup database uses a code page that is not supported by Informatica.
Action:Select a code page for the lookup database that is supported by Informatica and contains encoding for the lookup data character set.

TT_11078Stored procedure name <name of stored procedure> contains character(s) that is(are) not valid in the codepage of the database connection. The invalid character starts at position <character position> of the name.
Cause:The stored procedure name contains one or more characters that are not encoded in the stored procedure database code page.
Action:Identify the invalid character referenced in the session log. Edit the stored procedure name so that the Integration Service can convert it from the Integration Service code page to the stored procedure database code page without loss of data. Informatica recommends using 7-bit ASCII characters for all metadata. You can also configure the stored procedure database to use a code page that contains encoding for the stored 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 Informatica.
Action:Select a code page for the stored procedure database that is supported by Informatica and contains encoding for the stored procedure data 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 *