Exec Dashboard - Failing request for summary endpoint
Summary
The summary endpoint request is failing for the current month to date.
On page load we make multiple requests to both the time_summary
and summary
endpoints for the previous 3 months of data, these seem to be successfully completing, but the final request for data for the month to date (start of current month until today) is failing.
The request fails with the json response message “There is too much data to calculate. Please change your selection.”
Steps to reproduce
- Navigate to the executive dashboard
- The request may or may not fail
- Refresh the page until the request fails
Example Project
What is the current bug behavior?
The API request fails and data is not loaded
Relevant logs and/or screenshots
Screenshot | Video |
---|---|
Screen_Recording_2022-12-02_at_11.53.57_am |
Solution
Force the execution of the query to be ordered in a way which is more performant. Isolate this to VSA.
- load the group hierarchy
- load all projects in the hierarchy
- load issues by the previously loaded projects + apply the given filters (date range)
Edited by Brandon Labuschagne