I'm hoping someone can shed some light on an issue I'm having with automated report generation.
I have an App that is used just to generate reports for another App.
On the 4th day of the month it calculates a bunch of scores for the previous month, this works perfectly. On the 5th day of the month these scores are then updated into another table which has a formula that calculates other scores. This also works perfectly.
On the 6th day of the month, an automation runs to build a monthly report for multiple customers that is very complex with lots of data using SELECT() from multiple tables and references, pie charts and bar graphs, using SNAPSHOT(LINKTOFILTEREDVIEW), plus a whole lot of other info. The reports are usually about 10 or more pages long.
The reports work, but some months they run, and other months they don't. The months when they don't run, there is no info in the Appsheet Monitoring to indicate an error or anything. They just don't run.
If I manually run them, sometimes they run, other times they don't. If I adjust the database manually so only one customer report at a time is generated, it usually runs successfully. (I'm using a TRUE/FALSE filter condition to specify which rows of the table to use - so it's easy to manually have just one customer selected).
I'm making the assumption that the report generation is timing out and failing. Is there any way to extend the time out? Or am I on the wrong track? My reports generate at odd times too, like 9:23am Australian EST, which I read was the best approach to take, rather than on the hour.
When I ran them separately today. monitoring shows the 1st customer report took 113 seconds to complete and 2nd Customer took 84 seconds to complete. So the total time was about 3 minutes and 17 seconds.
Any advice, suggestions or assistance would be appreciated.
Thanks, John.
LinkedIn
Twitter
