[ONE-37871] UT131 - BigPicture crashes during update from 8.0.x to 8.1.x due to invalid operators usen in MSSQL db - BigPicture Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Done
Affects Version/s: prod/bigpicture/jiraserver/2021/08/03/10/35/8.1.3, prod/biggantt/jiraserver/2021/08/03/10/35/8.1.3, prod/bigpictureenterprise/jiraserver/2021/08/03/10/35/8.1.3
Fix Version/s: prod/bigpicture/jiraserver/2021/09/17/10/00/8.1.5, prod/biggantt/jiraserver/2021/09/17/10/00/8.1.5, prod/bigpictureenterprise/jiraserver/2021/09/17/10/00/8.1.5, prod/bigpicture/jiracloud/2021/09/22/12/40, prod/biggantt/jiracloud/2021/09/22/12/40, prod/bigpictureenterprise/jiracloud/2021/09/22/12/40, prod/biggantt/jiracloud/2021/10/25/09/30, prod/bigpictureenterprise/jiracloud/2021/10/25/09/30, prod/bigpicture/jiracloud/2021/10/25/09/30, prod/bigpictureenterprise/jiraserver/2021/12/10/12/30/8.2.0, prod/bigpicture/jiraserver/2021/12/10/12/30/8.2.0, prod/biggantt/jiraserver/2021/12/10/12/30/8.2.0
Component/s: None
Labels:
- UpgradeTask
- support-verified

Regression:
No
Team:
Agile
Product:

BigPicture, BigPicture Enterprise, BigGantt
Host platform:

JIRA server, JIRA cloud
Customer Rank:
4
Total Customer Rank:
4
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";}

Sprint:
Sprint 2021/18
Program Increment:
PI2021/5

Time in "OPEN":

39 seconds

Time "In Progress":

22 hours, 25 minutes, 17 seconds

In Progress

Mateusz Barys

2021-08-16 14:49 - 2021-08-17 09:14 (18 hours, 24 minutes, 52 seconds)

Total (18 hours, 24 minutes, 52 seconds)

Krzysztof Dudek (Inactive)

2021-08-17 09:14 - 2021-08-17 13:07 (3 hours, 52 minutes, 57 seconds)

2021-08-23 10:02 - 2021-08-23 10:09 (7 minutes, 28 seconds)

Total (4 hours, 25 seconds)

Time "In Review":

0

Time "In QA Review":

4 hours, 23 minutes, 41 seconds

In QA Review

Krzysztof Dudek (Inactive)

2021-08-17 13:07 - 2021-08-17 15:15 (2 hours, 8 minutes, 21 seconds)

2021-08-23 07:46 - 2021-08-23 10:02 (2 hours, 15 minutes, 20 seconds)

Total (4 hours, 23 minutes, 41 seconds)

Time "In Test Scenario Review":

1 hour, 14 minutes, 48 seconds

In Test Scenario Review

Krzysztof Dudek (Inactive)

2021-08-17 15:15 - 2021-08-17 16:05 (50 minutes, 3 seconds)

2021-08-23 10:09 - 2021-08-23 10:34 (24 minutes, 45 seconds)

Total (1 hour, 14 minutes, 48 seconds)

Time "Waiting for Merge":

3 minutes, 38 seconds

Waiting for Merge

Krzysztof Dudek (Inactive)

2021-08-17 16:05 - 2021-08-17 16:07 (1 minute, 8 seconds)

2021-08-23 10:34 - 2021-08-23 10:35 (37 seconds)

Total (1 minute, 45 seconds)

Jakub Zygmunt (Inactive)

2021-08-17 16:07 - 2021-08-17 16:08 (1 minute, 53 seconds)

Total (1 minute, 53 seconds)

Time "Waiting for Release":

3 weeks, 1 day, 15 hours, 13 minutes, 58 seconds

Waiting for Release

Jakub Zygmunt (Inactive)

2021-08-17 16:08 - 2021-08-23 07:46 (3 days, 15 hours, 37 minutes, 55 seconds)

Total (3 days, 15 hours, 37 minutes, 55 seconds)

Krzysztof Dudek (Inactive)

2021-08-23 07:46 - 2021-08-23 07:46 (7 seconds)

2021-08-23 10:35 - 2021-09-17 10:11 (2 weeks, 4 days, 23 hours, 36 minutes, 2 seconds)

Total (2 weeks, 4 days, 23 hours, 36 minutes, 9 seconds)

Hide Fields Statistics:

$i18n.getText("admin.common.words.hide")

$i18n.getText("admin.common.words.show")
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";}

Description

Prerequisites:
BP 8.0.X installed, MSSQL db

Reproduction steps:

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

Assignee:: Krzysztof Dudek (Inactive)

Reporter:: Mateusz Barys

SoftwarePlant People involved:: Jenkins , Jakub Lisicki (Inactive) , Martyna Turowska , Krzysztof Dudek (Inactive) , Robert Włodarczyk , Gerrit , Mateusz Barys

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2021-08-16 14:49

Updated:: 2022-02-02 03:40

Resolved:: 2021-08-23 10:35