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.

Last modified on Mar 30, 2016

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

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