Troubleshooting Informatica Error Messages and Resolution – Part 427

WRT_8244Error outputting row # [row number] for output file [flat file target]. The row was rejected.
Cause:The Integration Service encountered an error outputting the row to the flat file target, and wrote the row in the reject file. The Integration Service may have rejected the row for one of the following reasons:
−The target is a fixed-width file, and the field width for a datetime column is not large enough to accommodate the datetime value, including the datetime format.
−The target is a fixed-width file, and the field width for a numeric column is not large enough for the numeric value, including the decimal and thousand separator.
Action:Edit the target definition in the Designer, and verify you configure the precision and field width to accommodate the total length of the target column.

WRT_8246Error: External loader is not supported for direct flat files. Target instance [target instance name].
Cause:In the session properties, you chose an external loader connection for a target based on a flat file target definition. This might have happened if you chose an external loader connection for a target based on a relational target definition and then in the Designer, you changed the relational target definition to a flat file definition.
Action:In the Designer, change the flat file target definition to a relational target definition. You can only choose an external loader connection when the target is based on a relational target definition.
WRT_8247Error: Cannot run in bulk mode for a test load for connection [target name].
Cause:In the session properties, you configured the Integration Service to perform a test load and you chose bulk mode for a relational target.
Action:Choose Normal for the target load type. You can perform a test load for relational targets when you configure a session for normal mode. If you configure the test load session for bulk mode, the session fails.

WRT_8250Target (test load not supported for this target type): <target name> (Instance Name: [target instance name]).
Cause:In the session properties, you configured the Integration Service to perform a test load, but the Integration Service does not perform a test load on some of the targets in the mapping.
Action:None. The Integration Service only performs a test load on relational targets.

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 *