Jira Data Center: Resolve Announcement Banner Issues via Database
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
Summary
After modifying the contents of Jira's Announcement Banner, pages do not load properly, making it impossible to reach the page to edit the content of the Announcement Banner.
This article provides steps to resolve these rendering issues in Jira Data Center caused by Announcement Banner changes using database commands
Diagnosis
Recent changes to the Announcement Banner are causing rendering issues across all Jira pages.
Cause
The Announcement Banner content is causing all Jira pages to malfunction.
Solution
- Stop the Jira Data Center instance
- Backup database
To resolve the issue, execute the SQL commands below. Ensure you have the necessary permissions and understand the implications of these changes:
DELETE from propertytext WHERE ID = (select id from propertyentry where property_key='jira.alertheader'); DELETE from propertystring where ID = (select id from propertyentry where property_key='jira.alertheader.visibility'); DELETE from propertyentry where property_key in ('jira.alertheader','jira.alertheader.visibility');
The above SQL commands will remove the contents of the Announcement Banner.- Start Jira