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



    • Tree
    • BigPicture, BigGantt
    • JIRA server, JIRA cloud, Trello
    • $i18n.getText("admin.common.words.hide")
      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";}
    • 1 hour, 25 minutes, 25 seconds
    • 1 day, 16 hours, 28 minutes, 39 seconds
    • 2 days, 8 hours, 58 minutes, 26 seconds
    • 1 day, 2 hours, 2 minutes, 44 seconds
    • 23 minutes
    • 6 seconds
    • 1 day, 16 hours, 21 minutes, 12 seconds
    • $i18n.getText("admin.common.words.hide")
      var cfToHide1 = document.getElementById("rowForcustomfield_21302"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_19201"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19300"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_19301"); if(cfToHide4){cfToHide4.style.display="none";} var cfToHide5 = document.getElementById("rowForcustomfield_19302"); if(cfToHide5){cfToHide5.style.display="none";} var cfToHide6 = document.getElementById("rowForcustomfield_19303"); if(cfToHide6){cfToHide6.style.display="none";} var cfToHide7 = document.getElementById("rowForcustomfield_19204"); if(cfToHide7){cfToHide7.style.display="none";} var cfToHide8 = document.getElementById("rowForcustomfield_19205"); if(cfToHide8){cfToHide8.style.display="none";}


      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)


      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.




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