I have a table running a simple query.
SELECT*FROM alarms_r1 where date between time and time
I noticed while working that the table was encountering an error as shown below.
On: Alarms.Root Container.Table.data
caused by GatewayException: Unable to read response from Gateway.
caused by org.xml.sax.SAXParseException; lineNumber: 31; columnNumber: 43; An invalid XML character (Unicode: 0x1) was found in the element content of the document.
I narrowed it down to 2 db entries that were causing the error.
The entries are of type string, and they contained “PS79 PROGRAM NOT MATCH” and “BG79 PROGRAM NOT MATCH”
When I edited the db and put a space in to make the entries “PS 79 PROGRAM NOT MATCH” and “BG 79 PROGRAM NOT MATCH” the error stopped? What is up with that??