Project gadget throws internal server error
症状
The Projects gadget on dashboard shows the following error:
And the error below appears in the application server log files:
com.sun.jersey.server.impl.application.WebApplicationImpl onException
SEVERE: Internal server error
com.atlassian.jira.exception.DataAccessException: Error occurred while retrieving user with id 'akhan'.
at com.atlassian.jira.project.ProjectImpl.getUser(ProjectImpl.java:154)
at com.atlassian.jira.project.ProjectImpl.getLead(ProjectImpl.java:58)
at com.atlassian.jira.gadgets.system.ProjectGadgetResource.getProjectDataNoPermissionCheck(ProjectGadgetResource.java:383)
at com.atlassian.jira.gadgets.system.ProjectGadgetResource.generate(ProjectGadgetResource.java:283)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
原因
The project which the gadget was configured for has a lead which was already deleted from the users table, causing an invalid reference. Trying to delete the lead for the project through the user interface will not work as well.
ソリューション
データベースの変更を行う場合は 必ず事前にバックアップを取得してください。可能な場合はテスト サーバーで変更を試すことをおすすめします。
It is necessary to change the the entry lead on the project table, to match a valid user on your system.
Backup your JIRA database.
Jira をシャットダウンします。
Run the query below to identify which user is set as the lead for the project (you will need to replace the project name on it):
SELECT lead FROM project WHERE pname = 'PROJECT NAME GOES HERE';- Replace the returned row with an active user on JIRA which has the necessary permissions on the project.
最終更新日 2018 年 11 月 8 日
Powered by Confluence and Scroll Viewport.