I am trying to send out a weekly report using the reporting module. We have multiple customers so each customer will be sent their own report. This Monday was the first time of sending them out. I noticed that 3 of the 6 customers had two of the queries fail and as a result had xy charts and tables that displayed ‘No data’. All the reports use the same queries.
I was able to repeat this by pressing the ‘Run selected action immediately’ button, but it seems only the first time that I press it does the error occur. After that the queries execute and the data looks as expected. I will attach the Error popup that I get in the designer. ‘oee_performance’ is a table valued function in the database and ‘recipe_downtime’ is a view
Any ideas what could be causing this inconsistent bug?