Unable to view or open a review - Your request was unable to be processed - NullPointerException

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

A review cannot be viewed and results in an error on screen after clicking on it - "Your request was unable to be processed". The following error appears in the log fisheye.out:

2013-04-01 00:09:06,399 ERROR - Exception "javax.servlet.ServletException: javax.el.ELException: java.lang.NullPointerException" (javax.servlet.ServletException) while processing "/cru/TEST_PROJECT-224" (Referer:"null")
javax.servlet.ServletException: javax.servlet.ServletException: javax.el.ELException: java.lang.NullPointerException
    ...
Caused by: javax.servlet.ServletException: javax.el.ELException: java.lang.NullPointerException
    
    ... 100 more
Caused by: javax.el.ELException: java.lang.NullPointerException
    
    ... 175 more
Caused by: java.lang.NullPointerException
    ... 190 more

診断

Run the following database queries and post the results in a comment on this ticket:

This query will return a cru_review_id for the review:

select * from cru_revpermaid t where t.cru_proj_key='TEST_PROJECT' and t.cru_number=224;


Next, run the following query with the previously acquired cru_review_id:

select t.cru_participant_id, cru_user, cru_author from 
cru_review_participant t where 
t.cru_review_id=<CRU_REVIEW_ID_HERE>;

 

Sample result:

cru_participant_id cru_user cru_author
160135 95  
160132 254  
160137 285  
160131 286  
160134 287  
160136 484  
160133 488  

 

原因

The author field will be blank and thus the reason for the NullPointerException. To work around this we can temporarily assign an author to the review or delete the hung review manually.

 

ソリューション

You can assign any of the users to be the author:
  • Make a backup of the database.
  • You can find a user's number by querying the table with their username using the following query:
select cru_user_id from cru_user where cru_user_name='<user_name_here>';
  • Then, match the user with cru_participant_id and run this command to set the author to TRUE:
update cru_review_participant set cru_author=1 where cru_participant_id=<CRU_PARTICIPANT_ID>;
最終更新日 2018 年 11 月 2 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.