org.hibernate.NonUniqueResultException: query did not return a unique result: 2

runawfe | erickv | 6 years ago
  1. 0

    WS & CancelProcess Bots Configurations.

    runawfe | 6 years ago | erickv
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  2. 0

    you basically end up with two different stored paths with the same path. stack trace when loading a review with with one of these invalid stored paths: [java] ERROR - Problem getting previous revisions [java] org.hibernate.NonUniqueResultException: query did not return a unique result: 2 [java] at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) [java] at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) [java] at com.cenqua.crucible.model.managers.StoredPathManager.findStoredPath(StoredPathManager.java:29) [java] at com.cenqua.crucible.model.managers.FileRevisionManager.findRevision(FileRevisionManager.java:115) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:367) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:363) [java] at com.cenqua.crucible.view.RevInfoDO.annotateFileHistory(RevInfoDO.java:120) [java] at com.cenqua.crucible.view.RevInfoDO.processFileRevisions(RevInfoDO.java:77) [java] at com.cenqua.crucible.view.RevInfoDO.<init>(RevInfoDO.java:58) [java] at com.cenqua.crucible.view.FRXDO$AnnotatedFileHistory.getRevInfoDO(FRXDO.java:108) [java] at com.cenqua.crucible.view.FRXDO.getCanProvideAnnotatedFileHistory(FRXDO.java:1017) [java] at sun.reflect.GeneratedMethodAccessor344.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:585) [java] at javax.el.BeanELResolver.getValue(BeanELResolver.java:293) [java] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) [java] at com.sun.el.parser.AstValue.getValue(AstValue.java:138) [java] at com.sun.el.parser.AstAnd.getValue(AstAnd.java:54) [java] at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206) [java] at org.apache.jasper.runtime.PageContextImpl.evaluateExpression(PageContextImpl.java:1001) [java] at org.apache.jsp.tag.web.review.frxControls_tag._jspx_meth_c_if_4(org.apache.jsp.tag.web.review.frxControls_tag:494) [java] at org.apache.jsp.tag.web.review.frxControls_tag.doTag(org.apache.jsp.tag.web.review.frxControls_tag:175) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_rev_frxControls_0(org.apache.jsp.tag.web.review.reviewPage_tag:5585) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_forEach_32(org.apache.jsp.tag.web.review.reviewPage_tag:5528) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_when_9(org.apache.jsp.tag.web.review.reviewPage_tag:5495) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_choose_6(org.apache.jsp.tag.web.review.reviewPage_tag:5461) [java] at org.apache.jsp.tag.web.review.reviewPage_tag.doTag(org.apache.jsp.tag.web.review.reviewPage_tag:937) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspx_meth_rev_reviewPage_0(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:145) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:118) [java] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) [java] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) [java] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:159) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) [java] at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143) [java] at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208) [java] at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:49) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) [java] at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:224) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:145) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) [java] at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129) [java] at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:59) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) [java] at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [java] at org.mortbay.jetty.Server.handle(Server.java:324) [java] at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) [java] at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865) [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) [java] at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) [java] at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [java] at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) [java] at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)

    Atlassian JIRA | 7 years ago | Geoff Crain [Atlassian]
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  3. 0

    One particular user gets following error in UI (as seen in attachment). Seems that this error does not affect other users but there are also errors in the logs with similar text but without reference to any particular user. Server log about error: ERROR - /cru/CRLBO-648/edit-changelog/~author=ildar/Product/ javax.el.ELException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at javax.el.BeanELResolver.getValue(BeanELResolver.java:298) at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) at com.sun.el.parser.AstValue.getValue(AstValue.java:138) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:62) at com.sun.el.parser.AstNot.getValue(AstNot.java:59) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206) at org.apache.jasper.runtime.PageContextImpl.evaluateExpression(PageContextImpl.java:1001) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_5(edit_005fselectRevisions_jsp.java:2869) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_choose_3(edit_005fselectRevisions_jsp.java:2842) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_4(edit_005fselectRevisions_jsp.java:2780) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_choose_2(edit_005fselectRevisions_jsp.java:2744) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_3(edit_005fselectRevisions_jsp.java:2715) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspService(edit_005fselectRevisions_jsp.java:544) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:159) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143) at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208) at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:224) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:145) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129) at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:59) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451) Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) at com.cenqua.crucible.model.managers.StoredPathManager.findStoredPath(StoredPathManager.java:29) at com.cenqua.crucible.model.managers.FileRevisionManager.findRevision(FileRevisionManager.java:88) at com.cenqua.crucible.model.managers.FileRevisionManager.createRevision(FileRevisionManager.java:37) at com.cenqua.crucible.revision.managers.DefaultContentManager.makeCrucibleRevision(DefaultContentManager.java:414) at com.cenqua.crucible.explorers.RepositoryChangelogExplorer.buildChangeSetDO(RepositoryChangelogExplorer.java:63) at com.cenqua.crucible.explorers.RepositoryChangelogExplorer.getChangesets(RepositoryChangelogExplorer.java:42) at com.cenqua.crucible.actions.create.EditChangelogAction.initChangesets(EditChangelogAction.java:95) at com.cenqua.crucible.actions.create.EditChangelogAction.getExplorer(EditChangelogAction.java:58) 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:585) at javax.el.BeanELResolver.getValue(BeanELResolver.java:293) ... 143 more

    Atlassian JIRA | 7 years ago | Paavo Nugin
    javax.el.ELException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    you basically end up with two different stored paths with the same path. stack trace when loading a review with with one of these invalid stored paths: [java] ERROR - Problem getting previous revisions [java] org.hibernate.NonUniqueResultException: query did not return a unique result: 2 [java] at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) [java] at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) [java] at com.cenqua.crucible.model.managers.StoredPathManager.findStoredPath(StoredPathManager.java:29) [java] at com.cenqua.crucible.model.managers.FileRevisionManager.findRevision(FileRevisionManager.java:115) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:367) [java] at com.cenqua.crucible.revision.managers.DefaultContentManager.getLazyCrucibleRevision(DefaultContentManager.java:363) [java] at com.cenqua.crucible.view.RevInfoDO.annotateFileHistory(RevInfoDO.java:120) [java] at com.cenqua.crucible.view.RevInfoDO.processFileRevisions(RevInfoDO.java:77) [java] at com.cenqua.crucible.view.RevInfoDO.<init>(RevInfoDO.java:58) [java] at com.cenqua.crucible.view.FRXDO$AnnotatedFileHistory.getRevInfoDO(FRXDO.java:108) [java] at com.cenqua.crucible.view.FRXDO.getCanProvideAnnotatedFileHistory(FRXDO.java:1017) [java] at sun.reflect.GeneratedMethodAccessor344.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:585) [java] at javax.el.BeanELResolver.getValue(BeanELResolver.java:293) [java] at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) [java] at com.sun.el.parser.AstValue.getValue(AstValue.java:138) [java] at com.sun.el.parser.AstAnd.getValue(AstAnd.java:54) [java] at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206) [java] at org.apache.jasper.runtime.PageContextImpl.evaluateExpression(PageContextImpl.java:1001) [java] at org.apache.jsp.tag.web.review.frxControls_tag._jspx_meth_c_if_4(org.apache.jsp.tag.web.review.frxControls_tag:494) [java] at org.apache.jsp.tag.web.review.frxControls_tag.doTag(org.apache.jsp.tag.web.review.frxControls_tag:175) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_rev_frxControls_0(org.apache.jsp.tag.web.review.reviewPage_tag:5585) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_forEach_32(org.apache.jsp.tag.web.review.reviewPage_tag:5528) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_when_9(org.apache.jsp.tag.web.review.reviewPage_tag:5495) [java] at org.apache.jsp.tag.web.review.reviewPage_tag._jspx_meth_c_choose_6(org.apache.jsp.tag.web.review.reviewPage_tag:5461) [java] at org.apache.jsp.tag.web.review.reviewPage_tag.doTag(org.apache.jsp.tag.web.review.reviewPage_tag:937) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspx_meth_rev_reviewPage_0(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:145) [java] at org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.crucible.review.monolithic.review_jsp:118) [java] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) [java] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) [java] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:159) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) [java] at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143) [java] at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208) [java] at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:49) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186) [java] at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) [java] at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) [java] at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273) [java] at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) [java] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [java] at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) [java] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:224) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) [java] at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) [java] at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:145) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) [java] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) [java] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) [java] at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129) [java] at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) [java] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:59) [java] at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) [java] at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) [java] at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) [java] at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) [java] at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [java] at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) [java] at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) [java] at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) [java] at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [java] at org.mortbay.jetty.Server.handle(Server.java:324) [java] at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) [java] at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865) [java] at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) [java] at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) [java] at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [java] at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) [java] at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451)

    Atlassian JIRA | 7 years ago | Geoff Crain [Atlassian]
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  6. 0

    One particular user gets following error in UI (as seen in attachment). Seems that this error does not affect other users but there are also errors in the logs with similar text but without reference to any particular user. Server log about error: ERROR - /cru/CRLBO-648/edit-changelog/~author=ildar/Product/ javax.el.ELException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at javax.el.BeanELResolver.getValue(BeanELResolver.java:298) at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) at com.sun.el.parser.AstValue.getValue(AstValue.java:138) at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:62) at com.sun.el.parser.AstNot.getValue(AstNot.java:59) at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206) at org.apache.jasper.runtime.PageContextImpl.evaluateExpression(PageContextImpl.java:1001) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_5(edit_005fselectRevisions_jsp.java:2869) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_choose_3(edit_005fselectRevisions_jsp.java:2842) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_4(edit_005fselectRevisions_jsp.java:2780) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_choose_2(edit_005fselectRevisions_jsp.java:2744) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspx_meth_c_when_3(edit_005fselectRevisions_jsp.java:2715) at org.apache.jsp.WEB_002dINF.jsp.crucible.create.edit_005fselectRevisions_jsp._jspService(edit_005fselectRevisions_jsp.java:544) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:159) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114) at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143) at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208) at com.cenqua.crucible.interceptors.ReviewInterceptor.intercept(ReviewInterceptor.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.cenqua.crucible.interceptors.CruciblePermissionInterceptor.intercept(CruciblePermissionInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.cenqua.crucible.interceptors.HasCrucibleInterceptor.intercept(HasCrucibleInterceptor.java:27) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1208) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.crucible.filters.CrucibleFilter.doFilter(CrucibleFilter.java:118) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:224) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:334) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at com.cenqua.fisheye.web.filters.TotalityFilter.doFilter(TotalityFilter.java:145) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81) at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:129) at com.cenqua.fisheye.web.filters.CustomIncludableGzipFilter.doFilter(CustomIncludableGzipFilter.java:21) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.ProductInfoFilter.doFilter(ProductInfoFilter.java:36) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at com.cenqua.fisheye.web.filters.UpfrontFilter.doFilter(UpfrontFilter.java:59) at org.mortbay.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1200) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:387) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:451) Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811) at com.cenqua.crucible.model.managers.StoredPathManager.findStoredPath(StoredPathManager.java:29) at com.cenqua.crucible.model.managers.FileRevisionManager.findRevision(FileRevisionManager.java:88) at com.cenqua.crucible.model.managers.FileRevisionManager.createRevision(FileRevisionManager.java:37) at com.cenqua.crucible.revision.managers.DefaultContentManager.makeCrucibleRevision(DefaultContentManager.java:414) at com.cenqua.crucible.explorers.RepositoryChangelogExplorer.buildChangeSetDO(RepositoryChangelogExplorer.java:63) at com.cenqua.crucible.explorers.RepositoryChangelogExplorer.getChangesets(RepositoryChangelogExplorer.java:42) at com.cenqua.crucible.actions.create.EditChangelogAction.initChangesets(EditChangelogAction.java:95) at com.cenqua.crucible.actions.create.EditChangelogAction.getExplorer(EditChangelogAction.java:58) 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:585) at javax.el.BeanELResolver.getValue(BeanELResolver.java:293) ... 143 more

    Atlassian JIRA | 7 years ago | Paavo Nugin
    javax.el.ELException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.hibernate.NonUniqueResultException

      query did not return a unique result: 2

      at org.hibernate.impl.AbstractQueryImpl.uniqueElement()
    2. Hibernate
      AbstractQueryImpl.uniqueResult
      1. org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820)
      2. org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
      2 frames
    3. ru.runa.wf
      JbpmExecutionServiceBean.getStateVariableMap
      1. ru.runa.wf.logic.JbpmExecutionLogic.getTaskDeadline(JbpmExecutionLogic.java:1285)
      2. ru.runa.wf.logic.JbpmExecutionLogic.fillTokenVariableMap(JbpmExecutionLogic.java:1190)
      3. ru.runa.wf.logic.JbpmExecutionLogic.getStateVariableMap(JbpmExecutionLogic.java:841)
      4. ru.runa.wf.service.impl.ejb.JbpmExecutionServiceBean.getStateVariableMap(JbpmExecutionServiceBean.java:235)
      4 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    5. JBoss Application Server Server
      StatelessSessionContainer$ContainerInterceptor.invoke
      1. org.jboss.invocation.Invocation.performCall(Invocation.java:359)
      2. org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
      2 frames
    6. JBoss Application Server Connector
      CachedConnectionInterceptor.invoke
      1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
      1 frame
    7. JBoss Application Server Server
      AbstractInterceptor.invoke
      1. org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
      2. org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
      3. org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
      4. org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
      5. org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
      6. org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
      7. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
      8. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
      9. org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:111)
      9 frames
    8. ru.runa.jboss
      CachingLogicInterceptor.invoke
      1. ru.runa.jboss.interceptor.CachingLogicInterceptor.invoke(CachingLogicInterceptor.java:23)
      1 frame
    9. JBoss Application Server Server
      StatelessSessionProxy.invoke
      1. org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
      2. org.jboss.ejb.Container.invoke(Container.java:960)
      3. org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
      4. org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
      4 frames
    10. Unknown
      $Proxy164.getStateVariableMap
      1. $Proxy164.getStateVariableMap(Unknown Source)
      1 frame