2020-11-24 - Critical update for JiraServer and JiraDataCenter with MSSQL database

The problem affects BigPicture/BigGantt data only.
All data stored in Jira is safe.

We have released a critical update for BigPicture and BigGantt for Server and Data Center. The update fixes a severe bug we've recently identified.
Symptoms:
- Data in Boxes cannot be displayed
Error triggers:
- Clicking on the “Fix Integrity Errors” button at (Jira Admin > Manage Apps > BigPicture > Technical Configuration > Advanced)
- Removal of any Box from BigPicture/BigGantt
Possible consequences:
- Irreversible loss of data that has no representation in Jira:

Basic tasks – tasks created in BigPicture/BigGantt, with no representation in Jira
Artificial links – links created in BigPicture/BigGantt, with no representation in Jira

Who is affected?

Jira Server and Jira Data Center customers using the MSSQL Database and BigPicture/BigGantt versions 8.0.10 and 8.0.11

What actions need to be taken?

We recommend upgrading the plugin to 8.0.12 ASAP - BigPicture 8.0.12 Release notes / BigGantt Release notes

Using the affected versions i.e. BigPicture/BigGantt 8.0.10 and BigPicture/BigGantt 8.0.11 may lead to irreversible data loss.

Do you have to take any action if the above criteria are not met in your case?

No.

What actions need to be taken if the above criteria are met?

Update BigPicture/BigGantt to version 8.0.12 ASAP
Contact SoftwarePlant Support to help you test if the data loss problem has already occurred in your case

Keep reading if you are willing to test the problem yourself.

Use the following SQL query to test if the problem has affected your instance(please replace AO_0456E7 with AO_8AC478_ if you are using BigGantt):

Select count(*) from AO_0456E7_PROPERTY where SCOPE_LEVEL1 = 'boxWbsId';

If the SQL returns more than 0, it means that the problem has not occurred.
In that case, updating BigPicture/BigGantt to version 8.0.12 is enough to secure your instance.

If the SQL shows 0 records, it indicates that the problem has caused data loss in your instance already. In such case, please contact SoftwarePlant Support and share the results of the following SQL queries:

Select * from AO_0456E7_WBS_CONFIG; 
Select * from AO_0456E7_PROPERTY where SCOPE_LEVEL1 = 'boxWbsId'; 
Select * from AO_0456E7_WBS_SUB_WBS_FIELDS; 
Select * from AO_0456E7_WBS_NODE; 
Select * from AO_0456E7_BOX_NODE; 
Select * from AO_0456E7_T_CORE_TASK;

and the latest database backup of all the plugin database tables with the following prefix:

BigPicture users: AO_0456E7_

BigGantt users: AO_8AC478_

If you are affected and do not have a backup

Should you fail to have the relevant backup there is still a possibility to recover major parts of the lost data, but unfortunately partial irreversible data loss may have occurred.
Please see this article for Atlassian's recommendations regarding database backup in case you need guidelines to provide the data mentioned in point 5 above.

BigPicture Suite

Support for Atlassian Server Products (and apps like BigPicture) has ended in February 2024.