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.