I’ve been spending some time trying to fix this one on my own, but it looks like I will have to give in to the support system again.
In a given window in my application I have a reporting plugin and a date range selector. When the value of the date range selector is changed, I run a query to retrieve statistical calculations from historical data within that date range using MIN() AVG() STD() etc. However, since I started doing this I’ve come across random errors saying my datasource is faulted when trying to evaluate certain tags in SQLTags. Now, I will say that the query is rather massive (although the response time is about 10-50ms in MySQL query browser), and I am thinking that it’s causing some sort of timeout. After closing the 15 or 30 error boxes, the problem subsides and the application works fine.
Unfortunately I cannot predict when the error happens. I searched the forums and didn’t find any topics describing the issue, but I’m hoping it can be easily explained and just hasn’t been brought up yet.
Any feedback is greatly appreciated.