I have connected Ignition to OSI PI Data Archive and Asset Framework Databases using JDBC drivers. All of the queries work perfectly fine within Vision but when attempting to add the queries within the report designer I receive the following error messages below. Any help would be appreciated as I’d really like to use Ignition to report on OSI PI Data.
The gateway indicates this error:
Gateway 13Nov2020 15:10:14 Error serializing response.
When viewing the database connection in the gateway the queries from Vision are shown but the Queries from the Report Designer are not present indicating they weren’t sent from Ignition to the database. It is also interesting that some queries work within the Report designer but others do not. For example changing a working query from Select to Select * will cause this error.
ExecutionException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Unable to read response from Gateway.
caused by GatewayException: Unable to read response from Gateway.
caused by org.xml.sax.SAXException: java.io.EOFException
caused by EOFException
Ignition v8.1.0 (b2020110211)
Java: Azul Systems, Inc. 11.0.7