Development panel shows incorrect Bamboo build or deployment summary

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

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:

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.key = 'Jira' -- replace with the jira project key
  and i.issuenum = 123; -- replace with the jira issue number

The result will show output like the following (formatted for readability) :

{
  "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 performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  1. Run the following query to retrieve the "ID" to delete

    select 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 number
  2. Delete the row returned by the query above

    DELETE from "AO_575BF5_DEV_SUMMARY" where "ID" = [the id from step 1];
  3. 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.

Description

Jira Development panel Build or Deployment summary shows outdated information

ProductJira, Bamboo
Last modified on Nov 23, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.