Whoops Error opening Epic Status Report or Program Increment grid if story points sum exceeds the max value in Jira Align
Summary
The solution presented in this article is related to the Whoops Error page when trying to open Status report page > Epics > Select an epic or also filtering by Portfolio >Program Increment Grid.
Environment
Jira Align
Diagnosis
Generic Whoops error page:
Cause
This issue happens when there are many Stories with points of effort extremely high, therefore exceeding the max amount of sum(points), this value exceeds the limit of int data type a value in the database, bigger than 2147483647, namely, causing the Themes and PI grids to crash. Due to this, the Whoops error page is shown.
Solution
Identify the stories that have a high number of Efforts by running the following API call using the swagger:
GET /align/api/2/Features
Filter: EffortPoints gt 10.000
Therefore, decrease the value of stories' effort points listed from the result of the API.