Remove the Jira server announcement banner through the 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
Symptoms
After modifying the contents of JIRA's Announcement Banner, pages are not loading properly, making it impossible to reach the page to edit the contents of the Announcement Banner.
Diagnosis
The Announcement Banner was recently changed, causing all pages in JIRA to not render properly.
Cause
Contents in the Announcement Banner may cause all pages in JIRA to become useless.
Resolution
- Stop JIRA
- Backup database
Run the following SQL to remove the contents of the Announcement Banner:
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