I have a large sql query (by large I mean it’s pulling data from 20 tables and joining it) that has been working great until particular point. The query pulls 15 minutes of data to perform calculations. I’ve been having trouble completing calculations for a specific time period and the query is taking over 90seconds and then ALWAYS crashes the client, where as it usually takes about 2 seconds to complete. The only thing about the data that I’ve noticed is that there is a duplicate timestamp for 2 consecutive values.
I’ve put in try/except in an attempt to handle the error if there is one but it does not seem to even throw an exception, just crashes the client.
My question is: Can the problem be this duplicate timestamp? How can I handle that inside the query or prevent Ignition from crashing entirely?
This is the only 15 minute set of data out of about 500,000+ records that is crashing the client.
Anyone run into a sql query crashing their client?