topic Re: invalid XML character. in Talend Studio

invalid XML character.

Anonymous — Mon, 04 Mar 2013 11:25:50 GMT

I am getting below error while loading data into the database.
Exception in component tFileInputXML_5
org.dom4j.DocumentException: Error on line 67 of document : Character reference "&#x14" is an invalid XML character. Nested exception: Character reference "&#x14" is an invalid XML character.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
how to resolve this.
Thanks

Re: invalid XML character.

Anonymous — Tue, 05 Mar 2013 02:31:25 GMT

Hi,
You can review the related forum to get the suggestion: https://community.talend.com/t5/Design-and-Development/Unable-to-use-tFileInputXML/td-p/73056
Best regards
Sabrina

Re: invalid XML character.

janhess — Tue, 05 Mar 2013 09:13:40 GMT

You will need to replace all the 2&#x14" with "".

Re: invalid XML character.

Anonymous — Tue, 05 Mar 2013 16:56:32 GMT

I am import xml data to mysql DB by using tInputFileXML
I am getting an error:
Exception in component tFileInputXML_5
org.dom4j.DocumentException: Error on line 67 of document : Character reference "&#x14" is an invalid XML character. Nested exception: Character reference "&#x14" is an invalid XML character.

As advise earlier I replaced it as "". When I open XML in browser, An invalid character was found in text content. Error processing resource.
I checked my xml file, it contains spanish characters like as "GONZÁLEZ , 11%, TAMAÑO etc "
Advice me to sort out this error
Thanks
Chin

Re: invalid XML character.

Anonymous — Wed, 06 Mar 2013 03:29:41 GMT

Hi,
If your source xml data is not a xml-formed file. http://stackoverflow.com/questions/6362926/xml-syntax-validation-in-java
Before using the tFileInputxml to read it, you need delete that line from the xml file. for exmaple:
tFileInputFullLine---tFilterRow--tFileOutputDelimited
|
onsubjobok
|
tFileInputXML---tLogRow
For more details, please see my screenshots.
Best regards
Sabrina