Ignition Version: 7.9.12
Gateway PC: CentOS Linux 7. Zulu 8.40
MySQL on the Gateway PC Version: 5.7.27
Client PC: Windows 10. Zulu 8.38
The problem I’m facing is that no named queries are working. I even have a named query that doesn’t have any parameters defined. I can browse my database tables just fine in the Database Query Browser.
Here’s a query that works in the Database Query Browser, but not as a Named Query:
SELECT UUID()
For Client Permissions, I’ve enabled ‘Legacy Database Access’ and added the required client roles. All Database Connections are valid. I have this same project setup in a few other locations and they work perfectly fine.
In the ignition.sh file, RUN_AS_USER = ac2admin. Same as hostname. In /etc/systemd/system/Ignigiont-Gateway.service
the User=ac2admin. Not sure that helps.
Here’s my error message:
Unable to read response from Gateway.
Compact
GatewayException: Unable to read response from Gateway.
caused by org.xml.sax.SAXParseException; lineNumber: 3; columnNumber: 11; The end-tag for element type "Response" must end with a '>' delimiter.
Ignition v7.9.12 (b2019070213)
Java: Azul Systems, Inc. 9.0.7.2
Full
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:341)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:445)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:273)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:268)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:894)
at com.inductiveautomation.ignition.designer.db.namedquery.workspace.NamedQueryTestingPanel$5$1.doInBackground(NamedQueryTestingPanel.java:321)
at com.inductiveautomation.ignition.designer.db.namedquery.workspace.NamedQueryTestingPanel$5$1.doInBackground(NamedQueryTestingPanel.java:300)
at java.desktop/javax.swing.SwingWorker$1.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.desktop/javax.swing.SwingWorker.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: org.xml.sax.SAXParseException; lineNumber: 3; columnNumber: 11; The end-tag for element type "Response" must end with a '>' delimiter.
at java.xml/com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at java.xml/com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.getResponse(GatewayInterface.java:443)
... 11 more
Ignition v7.9.12 (b2019070213)
Java: Azul Systems, Inc. 9.0.7.2