need to remove jira announcement banner

[Mark Redd]

I recently made a change to the announcement banner and believe that I did not properly close a tag, which has lead to the rest of the page (any jira page) not displaying properly. It looks like there is a fix here:

https://confluence.atlassian.com/jirakb/remove-the-jira-server-announcement-banner-through-the-database-429916703.html

However, that does not appear to be accurate for the version of Jira (8.6.1) in our test environment. Specifically, I get an error stating "Invalid object name 'propertyentry'." 

Does anyone know the proper SQL query to execute for this version?

[Niranjan]

Hi @Mark Redd - Not sure if you have fixed it. Do you still need to remove/update the banner? If so, try accessing it directly from UI with the link

<Your instance URL>/secure/admin/EditAnnouncementBanner!default.jspa

Update the banner from this page.

This may work.

[Mark Redd]

I believe I found it but will explain here for anyone with a similar issue.

I'm not sure if it's because we initially started with the demp database and migrated to SQL server, but propertyentry becomes jiraschema.propertyentry, for example.