Uploaded image for project: 'ONE'
  1. ONE
  2. ONE-32063

After team is added / edited / deleted in given Box, propagation of this change to sub-Boxes is done in a way that results in lower risk of simultaneous updates to sub-Boxes

    XMLWordPrintable

Details

    • Resources
    • BigPicture, BigPicture Enterprise, BigGantt
    • JIRA server, JIRA cloud
    • 3
    • 3
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18502"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}
    • Sprint 2021/04, Sprint 2021/05, Sprint 2021/06, Sprint 2021/07 SIW, Sprint 2021/08
    • PI2021/3
    • 0
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18807"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}

    Description

      When team is added / edited / deleted in given Box (e.g. in Program Box), such change has to be propagated to those sub-Boxes of given Box that are configured to automatically inherit upper-level teams (e.g. to Program Increments and to Iterations).

      If there is many such sub-Boxes and if several users want to access them at similar time, simultaneous update of sub-Boxes' teams may happen, which can result in error when accessing given sub-Box and in error in the logs pasted below. Fortunately, after refreshing the page with sub-Box, error disappears and one can work with it normally.

       

      This Story changes implementation of teams propagation algorithm, so that the risk of aforementioned error is substantially lower (although still not eliminated completely).

       

      Error in the logs:

      Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into public."AO_0456E7_TEAM_ALLOCATION" ("CREATE_DATE", "UPDATE_DATE", "ALLOCATION_TYPE", "BOX_ID", "TEAM_CODE", "TECH_UNIQUENESS2", "TEAM_ID", "TECH_UNIQUENESS1", "ID") values ('2021-05-10 17:01:58.717+02', '2021-05-10 17:01:58.717+02', 'A', 'ITER-100', 'TEAM_ALPHA', 'TEAM_ALPHA@ITER-100', 456, '456@ITER-100', 1110) was aborted: ERROR: duplicate key value violates unique constraint "u_ao_0456e7_team_al903671458"  Detail: Key ("TECH_UNIQUENESS1")=(456@ITER-100) already exists. 

      Attachments

        Issue Links

          People

            robert.lichman Robert Lichman
            robert.lichman Robert Lichman
            jakub.zygmunt Jakub Zygmunt , tomasz.jaskiewicz Tomasz Jaśkiewicz , martyna.turowska Martyna Turowska , mateusz.solowianiuk Mateusz Sołowianiuk , bartosz.drazewski Bartosz Drążewski , lukasz.panek Łukasz Panek , pawel.guz Pawel Guz , marcin.hareza Marcin Hareza , system.gerrit Gerrit , robert.lichman Robert Lichman
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: