My Oracle Support Banner

"XML Parsing Error: not well-formed" Generated trying to Export Data from OTM that Contains the '&' Symbol (Doc ID 2250500.1)

Last updated on JULY 15, 2020

Applies to:

Oracle Transportation Management - Version 6.3.7 to 6.4.2 [Release 6.3 to 6.4]
Information in this document applies to any platform.

Symptoms

When the '&' symbol is used in a field, like the location name, agent description and many others in OTM, the data will no longer be able to be exported to the UI using the CSV Export feature.

The following in an example of the typical error that would be generated.

XML Parsing Error: not well-formed
Location: http://<your server>.com:<your port>/GC3/glog.integration.servlet.CSVUtilServlet/1490307560383?ct=NjI1MjAxODc5NDUwNTczNzI5NA%3D%3D&bcKey=MTQ5MDMwNzU2MDM4Njow
Line Number 18, Column 19:"KAW.AMP","AMP","&",,,,,"USA",,,,,"America/Denver",,,,,,,,"N","N","N",,"N","U",,,,,,"N",,,"KAW","KAW.ADMIN","20170323220522","KAW.ADMIN","20170323221307",,,,,,,"N",,"N",,,,,,,"N",,,,,,,,,"N",,,,,"N",1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Y",
------------------^

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.