One Star

The reference to entity "lt" must end with the ';' delimiter.

Hi All,
I am getting below error while loading xml file in a table:
Exception in component tFileInputXML_1
org.dom4j.DocumentException: Error on line 51 of document : The reference to entity "lt" must end with the ';' delimiter. Nested exception: The reference to entity "lt" must end with the ';' delimiter.
How to find out this?
Any help?
Thanks
Chin
5 REPLIES
One Star

Re: The reference to entity "lt" must end with the ';' delimiter.

Search the xml for lt and find the one without the ; or with a space between lt and ; or try loading it into a browser and see where it says the error is.
One Star

Re: The reference to entity "lt" must end with the ';' delimiter.

Hi,
I made required changes in my source xml file and run it. But still I am getting below error:
Exception in component tFileInputXML_1
org.dom4j.DocumentException: Error on line 46 of document : The reference to entity "lt" must end with the ';' delimiter. Nested exception: The reference to entity "lt" must end with the ';' delimiter.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.dom4j.io.SAXReader.read(SAXReader.java:365)

My source xml here:
<?xml version="1.0" encoding="UTF-8"?>
<emp-document file="EMP33504B1.xml" dtd-version="v1.3 2005-01-01" lang="fr">
<personal-data id="biblio" lang="fr">
<emp-reference>
<emp-id>
<country>FR</country>
<emp-number>33504</emp-number>
<dept>ITE</dept>
<join-date>20120801</join-date>
</emp-id>
</emp-reference>
<personal-reference appl-type="SINGLE">
<emp-id>
<country>FR</country>
<emp-number>34599</emp-number>
<date>20120203</date>
</emp-id>
</personal-reference>
<insurance-claims>
<insurance-claim>
<country>US</country>
<doc-number>611/204,641</doc-number>
<date>20090710</date>
</insurance-claim>
</insurance-claims>
<parties>
<employees>
<employee sequence="1">
<addressbook>
<name>POWELL, Rick, C.</name>
</addressbook>
</employee>
<employee sequence="2">
<addressbook>
<name><</name>
</addressbook>
</employee>
<employee sequence="3">
<addressbook>
<name>snm/></name>
</addressbook>
</employee>
<employee sequence="4">
<addressbook>
<name>GLOECKLER, Markus</name>
</addressbook>
</employee>
<employee sequence="5">
<addressbook>
<name><</name>
</addressbook>
</employee>
<employee sequence="6">
<addressbook>
<name>snm/></name>
</addressbook>
</employee>
<employee sequence="7">
<addressbook>
<name>BULLER, Benyamin</name>
</addressbook>
</employee>
<employee sequence="8">
<addressbook>
<name><</name>
</addressbook>
</employee>
<employee sequence="9">
<addressbook>
<name>snm/></name>
</addressbook>
</employee>
<employee sequence="10">
<addressbook>
<name>SHAO, Rui</name>
</addressbook>
</employee>
<employee sequence="11">
<addressbook>
<name><</name>
</addressbook>
</employee>
<employee sequence="12">
<addressbook>
<name>snm/></name>
</addressbook>
</employee>
</employees>
</parties>
</personal-data>
</emp-document>

Please help me out.
Thanks
Chin
One Star

Re: The reference to entity "lt" must end with the ';' delimiter.

It seems to be getting confused with this bit or any of the other sequences like it.
<employee sequence="11">
<addressbook>
<name><</name>
</addressbook>
</employee>
<employee sequence="12">
<addressbook>
<name>snm/></name>
</addressbook>
</employee>

I don't have any problem reading this data in 5.0.2.
One Star

Re: The reference to entity "lt" must end with the ';' delimiter.

Hi Janhess,
I am using version Talend 4.0.3.
What is the solution for this?.
Thanks
Chin
One Star

Re: The reference to entity "lt" must end with the ';' delimiter.

Raise it as a bug.