How to fix Jira Service Management StatusPage stuck load when in configuration
プラットフォームについて: Data Center - この記事は、Data Center プラットフォームのアトラシアン製品に適用されます。
このナレッジベース記事は製品の Data Center バージョン用に作成されています。Data Center 固有ではない機能の Data Center ナレッジベースは、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
要約
The StatusPage configuration gets stuck not allowing the plugin configuration
環境
8.20.8
診断
By running a Har file, a status 500 is presented as the call below:
Request URL: https://<jira-base-url/rest/statuspage/1.0/config/project/service_desk
Request Method:GET
Status Code:500
Remote Address: 171.15.43.83:80Going through the application log we can see the error:
2023-03-17 12:25:18,587-0300 http-nio-8080-exec-384 ERROR admin 745x6538866x6 w59hbr X.X.X.X,X.X.X.X /rest/statuspage/1.0/config/project/service_desk [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: null
java.lang.NullPointerException原因
The issue is caused due to invalid entries in the table AO_050302_STATFL_CONF, related to projects that no longer exist.
ソリューション
The solution is based in removing directly from the database the incorrect entries.
PLEASE READ: As with all recommendations made by Atlassian Support, please follow best practices for Change Management and make sure to test and validate these steps in a lower environment (staging, development, testing, etc) prior to rolling any changes into a Production environment, and only after backing up your system and data. This is to validate these changes and ensure that they will function well within your infrastructure prior to placing them in production.
1 - Execute the SQL query below and check if all the entries in the table AO_050302_STATFL_CONF are associated with projects that currently exist - if you find any entry related to a project that no longer exists, please remove that by running the SQL query (indicated below).
select * from "AO_050302_STATFL_CONF";2 - Stop Jira
3 - Run the SQL query to delete the invalid entry
delete from "AO_050302_STATFL_CONF" where "PROJECT_NAME"='<PROJECT_NAME>';Replace the <PROJECT_NAME> with the name of the Project that no longer exist
4 - Start Jira
5 - Run the Database Integrity Checker.
詳細情報
This article is relates to the Feature Request:
JSWSERVER-21696 - Getting issue details... STATUS