Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-28249

Links of JIRA Issues in Confluence Workbox Notification do not get updated when JIRA base URL has changed

      Steps to reproduce:
      1. Install JIRA and Confluence and configure the base URL (with context path) for example to:
      2. Create an application link between Confluence and JIRA
      3. Create a new issue in JIRA and then comment on the issue
      4. With a successful application link integration, you'll received notification of the comment in Confluence Workbox
      5. Click on the notification and you'll be directed to the issue e.g. http://10.60.1.80:8525/jira/browse/TST-56118
      6. Change JIRA context path/base URL to http://10.60.1.80:8525/jira1
      7. Re-configure application link between Confluence and JIRA with the new base URL
      8. Add a new comment on the existing issue in JIRA
      9. With a successful application link integration, you'll received notification of the new comment in Confluence Workbox
      10. Click on the notification and you'll not be successfully redirected to the issue because it was trying to redirect you to http://10.60.1.80:8525/jira/browse/TST-56118. Noticed that the context path does not reflect the new context path which is supposed to be "jira1"
      11. Clicking on the previous JIRA issue notification in Confluence Workbox also will not redirect you to the correct link as it was still pointing to the old base URL

      My assumption was that this URL must have been stored somewhere in the database and updating the URL manually from the database would work as a workaround. I've checked on Confluence AO_9412A1_AONOTIFICATION table but JIRA notifications are not stored in an absolute path but instead like this:

      /browse/TST-56118
      /browse/BB-870
      /browse/NCLIS-358
      

      I then looked into Confluence BANDANA table for application link configuration (assuming that Confluence take the base URL from the configured application link) and it appears that the new JIRA base URLs (both Application URL & Display URL) are stored correctly in the database:

      bandanakey bandanavalue
      applinks.admin.781ddc6c-b497-38d7-8fc3-aad86127c262.display.url <string>http://10.60.1.80:8525/jira1</string>
      applinks.admin.781ddc6c-b497-38d7-8fc3-aad86127c262.rpc.url <string>http://10.60.1.80:8525/jira1</string>

      Where does this URL stored or taken from?

            [CONFSERVER-28249] Links of JIRA Issues in Confluence Workbox Notification do not get updated when JIRA base URL has changed

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2896596 ] New: CONFSERVER Bug Workflow v4 [ 2988887 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2787950 ] New: JAC Bug Workflow v3 [ 2896596 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2735265 ] New: JAC Bug Workflow v2 [ 2787950 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400723 ] New: JAC Bug Workflow [ 2735265 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2300410 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400723 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2234506 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2300410 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2197004 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2234506 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1927272 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2197004 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1728621 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1927272 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1685729 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1728621 ]

              etom edith (Inactive)
              hsuhailah Hanis Suhailah (Inactive)
              Affected customers:
              3 This affects my team
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5m
                  5m