Data Warehouse API jobs reporting in_progress after completion
Hi,
We have various accounts set up using the Data Warehouse v1.4 API, with which we create data warehouse reports programmatically and retrieve the status of these reports until the report is complete, at which point we download the report. This works well a majority of the time, but we've noticed that reports created via API during certain periods will return an in_progress status indefinitely, despite the report created showing as completed in the Data Warehouse UI. It seems like the API is "losing" the jobs and never updating the status upon completion.
Most of the reports we are submitting complete within 3 minutes according to the UI, but will continue to report in_progress for 12+ hours, which is the point we give up checking on our end. This has happened for hundreds of requests across at least 7 accounts this week.
These blips seem to occur 1-2 times per week and for a few hours each blip it appears. We're looking for any insight into whether there's any ongoing API issues we should be aware or and if there's any way to increase the reliability, as these issues impact automated reporting processes. If there's a process where I need to submit an engineering ticket, I would be happy to.
Thank you!