Development panel shows incorrect Bamboo build or deployment summary
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When viewing the development panel, the status summary of builds or deployments appears outdated. For example, we may see "1 build failed" even if the build details show all successful builds.
Diagnosis
Diagnostic Steps
You can confirm whether the Development Panel for a given issue – such as Jira-123 – is affected with a SQL query run in your Jira database. The following example is written for PostgreSQL:
1
2
3
4
5
6
7
8
9
10
select d."JSON"
from propertyentry a
join propertystring b on a.id=b.id
join "AO_575BF5_DEV_SUMMARY" d
on SUBSTR(a.property_key,16,36) = d."PROVIDER_SOURCE_ID"
join jiraissue i on d."ISSUE_ID" = i.id
join project p on p.id = i.project
where b.propertyvalue like '%bamboo'
and p.pkey = 'Jira' -- replace with the jira project key
and i.issuenum = 123; -- replace with the jira issue numberThe result will show output like the following (formatted for readability) :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
{
"value": {
"targets": {
"Jira-123": [
{
"type": {
"id": "build"
},
"objects": [
{
"lastUpdated": 1568392329550,
"buildCount": 2,
"planKey": "TEST-TEST",
"status": "SUCCESS"
}
]
},
{
"type": {
"id": "deployment-environment"
},
"objects": [
{
"projectUrl": "https://my.bamboo.url/deploy/viewDeploymentProjectEnvironments.action?id=1343489",
"project": "TEST",
"id": 1474561,
"position": 0,
"title": "dev",
"projectId": 1343489,
"url": "https://my.bamboo.url/deploy/viewEnvironment.action?id=1474561",
"status": "NOT_DEPLOYED"
},
{
"projectUrl": "https://my.bamboo.url/deploy/viewDeploymentProjectEnvironments.action?id=1343489",
"project": "TEST",
"id": 1474562,
"position": 1,
"title": "qa",
"projectId": 1343489,
"url": "https://my.bamboo.url/deploy/viewEnvironment.action?id=1474562",
"status": "DEPLOYED"
}
]
}
]
}
},
"expiry": 9223371721494776000
}If this detail does not match what is in Bamboo and the open development panel details, please read on.
Cause
The root cause of the issue is not known, but the database entries that store the development panel details may not always get successfully repopulated, leading to this outdated data.
Workaround
As a workaround, please:
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Run the following query to retrieve the "ID" to delete
1 2 3 4 5 6 7 8 9select d."ID" from propertyentry a join propertystring b on a.id=b.id join "AO_575BF5_DEV_SUMMARY" d on SUBSTR(a.property_key,16,36) = d."PROVIDER_SOURCE_ID" join jiraissue i on d."ISSUE_ID" = i.id join project p on p.id = i.project where b.propertyvalue like '%bamboo' and p.key = 'Jira' -- replace with your jira issue key and i.issuenum = 123; -- replace with your jira issue numberDelete the row returned by the query above
1DELETE from "AO_575BF5_DEV_SUMMARY" where "ID" = [the id from step 1];Refresh the Jira issue between 10 and 20 minutes after the row was deleted, so Jira will request new information from Bamboo
To verify whether the change took effect, please run the Diagnosis query again, and compare the result to Bamboo.
Was this helpful?