Troubleshooting Informatica Error Messages and Resolution – Part 392

TT_11019Port <port name>: Default value is: ERROR <error message>.
Cause:The Integration Service encountered a null value while moving data into the named port and returned the user-specified error message because that port has been configured to return an error upon encountering null values.
Action:Change the default value so the Integration Service does not return an error when encountering null values.
or
Cause:An error occurred in the named port, and that port is configured to return the user-specified error message upon error.
Action:If you do not want an error message upon error, change the port default value.

TT_11020Port <port name>: Default value is: ABORT <error message>.
Same as TT_11019, except the session terminates.
TT_11021<transformation name>: Transformation error for output to transform…
Cause:The Integration Service encountered an error moving data from the first specified transformation to the second. The data that caused the error has been removed from the data flow and written to the session log. If you enabled row error logging, the data that caused the error 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.
TT_11022Port <port name>: Input data conversion error.
Cause:The Integration Service encountered an error converting data to the named port specified datatype. The data that caused the error has been removed from the data flow and written to the session log. If you enabled row error logging, the data that caused the error 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 port datatype to a datatype compatible with the previous transformation port.

TT_11023Port <port name>: Output data conversion error.
Cause:The Integration Service encountered an error converting data from the named port specified datatype. 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 port datatype to a datatype compatible with the previous transformation port

 

Leave a Reply

Your email address will not be published. Required fields are marked *