[ONE-28436] Upgrade from BP7 to BP8 may fail with unique constraint violated on table box_favourite and result in 'BigPicture crash on loading' - BigPicture Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Done
Affects Version/s: prod/bigpicture/jiraserver/2020/09/22/8.0.0, prod/bigpicture/jiracloud/2020/10/01/17_40, prod/biggantt/jiraserver/2020/10/20/8.0.4
Fix Version/s: prod/bigpicture/jiraserver/2020/10/29/8.0.7, prod/biggantt/jiraserver/2020/10/29/8.0.7, prod/bigpicture/jiracloud/2020/11/02/15_25, prod/biggantt/jiracloud/2020/11/09/11_25
Component/s: None
Labels:
- UpgradeTask
- support-verified

Team:
Boxes
Product:

BigPicture, BigGantt
Host platform:

JIRA server, JIRA cloud
Customer Rank:
9
Total Customer Rank:
10
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":

17 minutes, 48 seconds

Open

Piotr Duźniak

2020-10-23 12:53 - 2020-10-23 13:10 (17 minutes, 43 seconds)

2020-12-17 14:33 - 2020-12-17 14:34 (5 seconds)

Total (17 minutes, 48 seconds)

Time "In Progress":

2 days, 2 hours, 57 minutes, 43 seconds

Time "In Review":

3 minutes, 52 seconds

Time "Waiting for Merge":

20 minutes, 8 seconds

Time "Waiting for Release":

1 day, 16 hours, 31 minutes, 18 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";}

Prerequisites:
Use an incorrect user format in the PROPERTY table.

Reproduction steps:
Upgrade the app from ver 7 to ver 8.

Actual result:
The BoxFavourite Upgrade Task fails during the update. Crash on installation on loading.
Upgrade Task number:
BPJS: 58
BPJC: 51

Expected result:
Installation successful.

Workaround:
N/A

SoftwarePlant People involved:: Kamil Harasimiuk , Mateusz Wyzinski , Jenkins , Maciej Bukrewicz (Inactive) , Paweł Wasiak , Radosław Rachuba , Gerrit , Krzysztof Łuczak