Hi all,
I am using an XML stage and a Column Importer stage to load data into a Netezza table. I am receiving this warning:
XML_39,0: 2014-09-30 17:11:41,456 Warn [XML_Parser] []
Start XML Validation Errors (Only first error reported for any path in the schema):
Path: [Schema_Node, SOPDataLoad, Records, R, R]
CDIER0007E: An error occurred while reading input: language=XML, cause=javax.xml.stream.XMLStreamException: An invalid XML character (Unicode: 0xffffffff) was found in the element content of the document., systemId=null, line number=454, column number=80, step=XML_Parser, source=C:\LOAD_DATA.txt.
End XML Validation Errors
Any idea why I'm getting this warning?
Thanks guys.
Help, XML parsing warning
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 34
- Joined: Thu Aug 28, 2014 8:48 pm
- Location: United States
Re: Help, XML parsing warning
It seems like you are getting some hex value from source which your default NLS setting is unable to read it.default NLS setting will be UTF-8.This occurs because of two different code pages with source and Datastage and target.