Troubleshooting Informatica Error Messages and Resolution – Part 144

SQLServerF1_Header_Small

FR_3064Warning: Last row in file is not complete.
Cause:The last row in the fixed-width file contains empty columns. The Integration Service skips the last row.
Action:Verify the last row in the source file contains valid data.

FR_3065Row <row number>, field <column name>: Invalid number – <column data>. The row will be skipped.
Cause:The source file contains string data in a numeric column. The Integration Service skips the row.
Action:Verify the row in the source file contains valid data.
FR_3066Error: Date format string has at least one character decimal value=<number> that is not in Latin1 codepage in ASCII data movement mode.
Cause:The date format string for a datetime column contains a character that is not in 7-bit ASCII.
Action:In the Designer, edit the flat file source definition using 7-bit ASCII characters for the datetime column format string.
FR_3067Row <row number>, field <column name>: Invalid date – <column data>. The row will be skipped.
Cause:The source file contains invalid data in a datetime column. The Integration Service skips the row.
Action:Verify the row in the source file contains valid data.

FR_3068Invalid date format provided <date format>.
Cause:Internal error.
Action:Contact Informatica Technical Support.
FR_3069Error: The character ‘<character>’ is used as a delimiter and a thousands separator for field <column name>.
Cause:In the Designer, you specified the same character as both the file delimiter and as the thousands separator for the specified numeric column.
Action:Verify the source file contains different characters for the thousands separators and column delimiters. Edit the source definition in the Source Analyzer, or import it again.
FR_3070Error: The character ‘<character>’ is used as a delimiter and a decimal separator for field <column name>.
Cause:In the Designer, you specified the same character as both the file delimiter and as the decimal separator for the specified numeric column.

Action:Verify the source file contains different characters for the decimal separator and column delimiter. Edit the source definition in the Source Analyzer, or import it again.

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 *