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

BigPicture 7.x.x migration to 8.x.x - Gantt Column View fails due to too long field name

    XMLWordPrintable

    Details

    • Team:
      Tree
    • Product:
      BigPicture, BigGantt
    • Host platform:
      JIRA server, JIRA cloud, Trello
    • Hide Fields:
      $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";}
    • Time in "OPEN":
      1 hour, 25 minutes, 25 seconds
    • Time "In Progress":
      1 day, 16 hours, 28 minutes, 39 seconds
    • Time "In Review":
      2 days, 8 hours, 58 minutes, 26 seconds
    • Time "In QA Review":
      1 day, 2 hours, 2 minutes, 44 seconds
    • Time "In Test Scenario Review":
      23 minutes
    • Time "Waiting for Merge":
      6 seconds
    • Time "Waiting for Release":
      1 day, 16 hours, 21 minutes, 12 seconds

      Description

      Steps to reproduce

      • Install BigPicture version 7.x.x
      • Open any existing program box configurations. 
      • Go to Gantt Column Views.
      • Create a new one with a name longer than 240 symbols. 
      • Go to Manage apps and install newest BigPicture version from the marketplace (version 8.x.x)
      • Go to Overview/Home and click to start the Upgrade Task (UT) process (which is a process that modifies the database scheme of the add-on). 
      • When UT process is finished go to Gantt Column Views in the previously used Program Box

      Observed result
      Upgrade Task process is finished with fail. There is a screen with information about "BigPicture loading crashed. 

      Below are some stack traces from logs. 

      Oct 07 14:29:00 CEST 2020, Upgrade failed!!!!, stage = 36@DML
      com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library (...)
      org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
      

      or

      Caused by: com.softwareplant.util.storage.dbupgrade.domain.exceptions.DatabaseUpgradeTaskExecutionException: Upgrade task stage: 66@DML failed
      

      Expected result
      BigPicture migration from version 7.x.x to 8.x.x is finished with success. In Gantt Column View there is previously created a view with name as before migration.

        Attachments

          Activity

            People

            Assignee:
            dariusz.dudek Dariusz Dudek
            Reporter:
            dmytro.sagai Dmytro Sagai (Inactive)
            SoftwarePlant People involved:
            grzegorz.duzy Grzegorz Duży , system.jenkins Jenkins , katarzyna.rajchert Katarzyna Rajchert , dariusz.dudek Dariusz Dudek , piotr.polanski Piotr Polański , system.gerrit Gerrit , dmytro.sagai Dmytro Sagai (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: