Trying to reach Signals on a table whose records are constantly changing (deleted as well)
Hi guys, I have a question. I have Signals running on a view. The table behind this view is a buffer table and whose records are deleted once we are done with the process.
I see some cases that Signals are detected at some point, but when I try to open Signals, I receive some errors, I can not see the Signals.
An example error: Error retrieving results
An error occurred retrieving the results from the database. Please check the SQL syntax and try again.I remember that Signals are only stored as definitions (like query of a Signal etc) and whenever we try to open a Signal, that query is executed and all related charts etc are generated from scratch. Do I remember correctly?
My theory, is that I got a Signal, but when I try to reach that Signal, the relevant data is deleted from the table and my query is not returning any results since data is gone.
Can this be the case here?
System InformationApplication Version:8.0.4Build:20191216Java Version:1.8.0_252Operating System:Linux 4.19.112+ (amd64)