Unable to view a review - query did not return a unique result: 2

お困りですか?

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

コミュニティに質問

症状

Viewing a review will have an error.

atlassian-fisheye-<date>.log に次のメッセージが表示される。

2013-09-26 09:34:00,341 INFO  [btpool0-128 ] fisheye.app TotalityFilter-logCause - Cause: query did not return a unique result: 2
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
	at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:868)
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:859)
	at com.cenqua.crucible.model.managers.impl.DefaultReviewManager.getReviewByPermaId(DefaultReviewManager.java:835)
	at com.atlassian.crucible.actions.ReviewBaseAction.getReview(ReviewBaseAction.java:201)

診断

Run the following SQL query to check if there is more than one result:

SELECT * FROM cru_revpermaid WHERE LOWER(cru_proj_key)='<project_key>' AND cru_number=<review_number>; 

原因

There are two projects with the same lowercase project key.

ソリューション

Edit the Project Key at Administration > Project Settings > Projects > Edit Crucible Settings for one of the project with the same lowercase project key so that it will have different lowercase project key.

最終更新日 2016 年 3 月 30 日

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

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