•  
      request #14986 report can throw a fatal error when db is inconsistent
    Infos
    #14986
    Marie Ange Garnier (marieange)
    2021-05-14 09:40
    2020-06-16 10:58
    16236
    Details
    report can throw a fatal error when db is inconsistent
    2020-06-16T07:49:46+00:00 [18500] [error] Caught exception: Tracker does not exist:
    #0 /usr/share/tuleap/plugins/agiledashboard/include/Planning/PlanningFactory.class.php(447): PlanningFactory->getPlanningTracker(Object(Planning))
    #1 /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Planning/NearestPlanningTrackerProvider.class.php(63): PlanningFactory->getPlanningsByBacklogTracker(Object(Tracker))
    #2 /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Planning/NearestPlanningTrackerProvider.class.php(50): AgileDashboard_Planning_NearestPlanningTrackerProvider->getPlanningTrackersInRightOrder(Object(Tracker), Object(Tracker_HierarchyFactory))
    #3 /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Milestone/MilestoneReportCriterionOptionsProvider.class.php(70): AgileDashboard_Planning_NearestPlanningTrackerProvider->getNearestPlanningTracker(Object(Tracker), Object(Tracker_HierarchyFactory))
    #4 /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/Milestone/MilestoneReportCriterionProvider.class.php(67):

    This fatal error occurs when a planning is deleted, but db has remains of previous configuration
    SELECT *
    FROM plugin_agiledashboard_planning AS p
    INNER JOIN plugin_agiledashboard_planning_backlog_tracker AS b ON p.id = b.planning_id
    WHERE p.group_id = 1234

    +------+-----------------+----------+---------------------+-----------------+-------------+-------------+------------+
    | id | name | group_id | planning_tracker_id | backlog_title | plan_title | planning_id | tracker_id |
    +------+-----------------+----------+---------------------+-----------------+-------------+-------------+------------+
    | 12 | Sprint Planning | 1234 | 0 | Release Backlog | Sprint Plan | 5678 | 91011 |
    +------+-----------------+----------+---------------------+-----------------+-------------+-------------+------------+
    Agile Dashboard
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Marie Ange Garnier (marieange)
    Closed
    2020-06-19
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    As this problem does not happen often and as we do not have an easy way to restore the configuration to a standard on (need to know which tracker is used as release, and it's this configuration who is broken), we have chosen to not do a forgeupgrade who delete the aflsy entries

    • Status changed from Under implementation to Closed
    • Connected artifacts
    • Close date set to 2020-06-19