| |
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):
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:
| |
| |
FileRdrTruncateStringNull and FileRdrTreatNullCharAs
The FileRdrTruncateStringNull and FileRdrTreatNullCharAs PowerCenter Integration Service custom properties can be used to handle Null (binary) values in flat file sources.
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:
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 |
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:
Subscribe to:
Post Comments (Atom)
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete