JIRA Issues Macro: $exceptionMessage displays on page in Confluence
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
JIRA issues macro is showing error '$exceptionMessage' for some users.
Cause
After moving Confluence from Atlassian Cloud to a Atlassian Server environment, there is a corruption to the OAuth tokens being used in the database.
Resolution
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.
- Backup the Confluence database.
- Delete the existing application link.
- Shutdown Confluence.
Run the following query on the Confluence database:
DELETE FROM BANDANA WHERE BANDANAKEY LIKE '%oauth%';- Start Confluence.
- Recreate the application link.
- Verify that the application link is working properly for users.