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