XML parse error 103

msa02

Hi all,
Again I need your help guys!
I'm extracting data from an excel spreadsheet and writing that into an xml file. Then doing datadeploy from xml to db. Although the data gets inserted but if I look at the datadeploy logs, I see this error:
**ERROR**:TXmlTupleProducer 103 SAX parse exception at line 79 column 94: Reference must end with ';'.
This error comes up wherever there are special characters in the xml file like & = or spaces etc.

Can somebody help me out fix this problem please!!!

Migrateduser

You're problem specifically is the ampersand. The ampersand is a special character in XML which introduces an entity (either a reference to a user defined entity or one of the built in entities). All entities must end with a semicolon. There are five built in entities: &, ", &apos, < and >

Thus, if you need an ampersand in your xml, replace it with the & entity.

Cheers
Rob Huffstedtler