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

UT131 - BigPicture crashes during update from 8.0.x to 8.1.x due to invalid operators usen in MSSQL db

    XMLWordPrintable

Details

    • No
    • Agile
    • 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/18
    • PI2021/5
    • 39 seconds
    • 22 hours, 25 minutes, 17 seconds
    • 0
    • 4 hours, 23 minutes, 41 seconds
    • 1 hour, 14 minutes, 48 seconds
    • 3 minutes, 38 seconds
    • 3 weeks, 1 day, 15 hours, 13 minutes, 58 seconds

    Description

      Prerequisites:
      BP 8.0.X installed, MSSQL db

      Reproduction steps:

      1. Update BP to 8.1 line.

      Actual result:
      BP crashes during update tasks due to wrong operators used in sub-scope synchronization.

      Expected result:
      BP upgrades to 8.1 successfully, all Upgrade Tasks are finished, sub-scope synchronization is preserved.

      Workaround:
      N/A

      Developer's note:
      The data types ntext and nvarchar are incompatible in the equal to operator. In Microsoft Sql Server strings are stored as nvarchar.

      Attachments

        Activity

          People

            krzysztof.dudek Krzysztof Dudek
            mateusz.barys Mateusz Barys
            system.jenkins Jenkins , jakub.lisicki Jakub Lisicki , martyna.turowska Martyna Turowska , krzysztof.dudek Krzysztof Dudek , robert.wlodarczyk Robert Włodarczyk , system.gerrit Gerrit , mateusz.barys Mateusz Barys
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: