We have a report that takes ~30 minutes to run in the UI. The report itself is only 1-2 pages of data, but is composed of a large amount of aggregate data.
I'm scheduling the report to run using the /rest_v2/reportExecutions endpoint, then polling every minute to wait for the report to complete.
For about 20 minutes the job has a status of "execution". After that I receive a 404 / resource.not.found response.
I know what you're going to say - fix your queries.
While a developer works on that, is there a way to configure the server to keep things around longer?
A secondary question - where is the output of 'reportExecutions' jobs cached?