Wednesday, August 16, 2017

FR_3085 ERROR: character is a null character, which is not allowed in a text input file

As mentioned on https://kb.informatica.com/solution/6/Pages/20698.aspx:

Solution
To avoid this error set one of the following PowerCenter Integration Service custom properties (for detailed steps refer to article 18015: HOW TO: Set the PowerCenter service Custom Properties):
  • FileRdrTruncateStringNull
  • FileRdrTreatNullCharAs
These parameters can be used to deal with invalid null characters in the source flat file as described below.

NOTE:

These parameters require PowerCenter 8.1.1 SP3 (or later).

VSAM

These parameters should only be used with ASCII (non-EBCDIC) flat file sources.
If the file is a mainframe VSAM file confirm the following in addition to the above:
  1. The file is not converted to text before reading in PowerCenter.
  2. The source definition type is VSAM.
    If it is flat file this error may occur.
  3. Use a Normalizer in the mapping.
  4. Change the source code page to EBCDIC .
More Information

FileRdrTruncateStringNull and FileRdrTreatNullCharAs

The FileRdrTruncateStringNull and FileRdrTreatNullCharAs PowerCenter Integration Service custom properties can be used to handle Null (binary) values in flat file sources.
  • If no flags are used then a row error is generated and row having null character is skipped from processing.
  • These flags cannot be used simultaneously.

FileRdrTruncateStringNull

If FileRdrTruncateStringNull is set to Yes, then column will be truncated at the first NULL character.

FileRdrTreatNullCharAs

If FileRdrTreatNullCharAs is set to a character, then the NULLs will be replaced with the character specified.
To set FileRdrTreatNullCharAs as a non-alphanumeric ('special') character (such as a space) use the octal representation character (such as \040 for space), and NULL will be replaced with the specified character.

Example

The octal representation for a space character is /040.
Set this parameter as follows so that nulls are replaced with spaces in the flat file:
FileRdrTreatNullCharAs=\040

NOTES

FileRdrTreatNullCharAs may cause a session to fail in PowerCenter 8.5.1 and 8.6.  PowerCenter 8.6 HotFix 3 or later is recommended. 
For more information refer to article 33016.
If FileRdrTreatNullCharAs an error message will be written to the session log.
For more information refer to article 31587

HEX OO Values

If the file contains NULL characters with HEX value of 00 you can remove these characters using a Hex Editor.
Use the replace option to replace null(00) with space or even nothing.
Use the following link to download Hex Editor XVI32 http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm

2 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete