I have created a dynamic report with start and End date,
Sometimes when I choose a start data,
I'am getting this error:
Exception: Error running query:
Function binding query [Alarm Status]@5000ms
On: Details Window.Root Container.AlarmData
caused by GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out
caused by BindingException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out
caused by GatewayException: Read timed out
caused by SocketTimeoutException: Read timed out
Ignition v8.1.27 (b2023042509)
Java: Azul Systems, Inc. 11.0.18
what it mean ?
There is no "Report Component" in Ignition.
- Vision has a Report Viewer component. Add "vision" tag to your question.
- Perspective has a Report Viewer component. Add "perspective" tag to your question.
- There is also the Reporting module. Add "reporting" tag to your question.
From your screenshot it looks like you are using the Vision Report Viewer.
It looks like your query is either taking too long or the database is not responding.
If it is a query then please post the formatted SQL code.
Also, please tell if it is a named query.
hello @Transistor I'am using Nersted query
I'am using nerted Query.
SELECT turbine.id_turbine AS ID_TURBINE,
turbine.localisation,
turbine.etat,
turbine.marque,
turbine.vitesse
FROM turbine
SELECT control.date_control,
equipe_technique.code_acces,
equipe_technique.role,
equipe_technique.priorite,
control.date_next_control,
control.details_control
FROM control,
equipe_technique
WHERE equipe_technique.id_responsable = control.id_responsable AND
control.date_control IS NOT NULL AND control.date_control BETWEEN ? AND ? AND
control.id_control = ?
