Troubleshooting Informatica Error Messages and Resolution – Part 140

SQLServerF1

FR_3029Delimited file attribute error: escape character cannot be the same as quote character.
Cause:You specified the same quote mark for the escape character and the optional quotes character in a delimited flat file source.
Action:Specify a different escape or quote character.
FR_3030Delimited file attribute error: delimiters cannot contain quote character.
Cause:One of the delimiters is the selected quote character.
Action:Specify a delimiter other than the quote character.

FR_3031Delimited file attribute error: delimiters cannot contain escape character.
Cause:One of the delimiters is the specified escape character.
Action:Specify a delimiter other than the escape character.
FR_3032Delimited file attribute error: must specify at least one delimiter.
Cause:You have not specified a delimiter.
Action:Specify a delimiter.
FR_3033Delimited file reader: Warning! Missing matching quote character in column <column name> of file <file name>. Reading till the end of line for the column.
Cause:There is a missing closing quote in the specified column.
Action:Review the file and add a closing quote character where appropriate.

FR_3034Delimited file reader: Warning! Skipped extra character(s) after the closing quote of column <column name> in file <file name>.
Cause:There are additional characters after the closing quote delimiter in the specified column. The Integration Service did not read the extra characters.
Action:Look in the source file to verify if the skipped characters are intended to be a part of the column. If so, import the file into the Source Analyzer again.
FR_3035Error opening file NULL. Operating system error message.
Cause:Internal error while reading from a source file.
Action:Contact Informatica Technical Support.
FR_3036Error: Escape character <escape character value> is not in Latin1 code page in ASCII data movement mode.
Cause:You configured the Integration Service to run in ASCII mode. The file source code page is Latin1, and you selected an escape character for the file source that is not valid in the Latin1 code page.
Action:Select an escape character that is valid in the Latin1 code page.

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 *