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

hibernate.org | 3 months ago
  1. 0

    Hibernate Community • View topic - SubSelect in from clause

    hibernate.org | 3 months ago
    org.hibernate.NonUniqueResultException: query did not return a unique result: 27
  2. 0

    Exception with StudentStatus

    GitHub | 3 years ago | hirokiterashima
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  3. 0

    Investigate NonUniqueResultException posting student data

    GitHub | 5 years ago | geoffreykwan
    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

    Having a stage dependency condition such as this one: <variableCondition> <stageName>CIPreliminaryQuestionnaire</stageName> <variablePath>/Onyx/CIPreliminaryQuestionnaire/STAGE_STATUS/SH_CI/active</variablePath> <operator>ne</operator> <data> <type>BOOLEAN</type> <value class="boolean">true</value> </data> </variableCondition> Throws a org.hibernate.NonUniqueResultException when the participant has not yet answered the questionnaire. The full stack trace was: org.hibernate.NonUniqueResultException: query did not return a unique result: 4 at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at org.obiba.core.service.impl.hibernate.PersistenceManagerHibernateImpl.matchOne(PersistenceManagerHibernateImpl.java:82) at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy30.matchOne(Unknown Source) at org.obiba.onyx.quartz.core.service.impl.hibernate.QuestionnaireParticipantServiceHibernateImpl.isQuestionActive(QuestionnaireParticipantServiceHibernateImpl.java:85) 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:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy39.isQuestionActive(Unknown Source) at org.obiba.onyx.quartz.engine.variable.impl.DefaultQuestionToVariableMappingStrategy.getVariableData(DefaultQuestionToVariableMappingStrategy.java:205) at org.obiba.onyx.quartz.engine.QuartzModule.getVariableData(QuartzModule.java:213) at org.obiba.onyx.engine.variable.VariableDirectory.getVariableData(VariableDirectory.java:162) at org.obiba.onyx.engine.VariableStageDependencyCondition.isDependencySatisfied(VariableStageDependencyCondition.java:74) at org.obiba.onyx.engine.MultipleStageDependencyCondition.isDependencySatisfied(MultipleStageDependencyCondition.java:85) at org.obiba.onyx.engine.state.AbstractStageState.areDependenciesCompleted(AbstractStageState.java:93) at org.obiba.onyx.engine.state.AbstractStageState.onTransition(AbstractStageState.java:78) at org.obiba.onyx.engine.state.StageExecutionContext.onTransition(StageExecutionContext.java:219) at org.obiba.onyx.engine.state.StageExecutionContext.castEvent(StageExecutionContext.java:116) at org.obiba.onyx.engine.state.AbstractStageState.castEvent(AbstractStageState.java:99) at org.obiba.onyx.engine.state.AbstractStageState.onTransition(AbstractStageState.java:87) at org.obiba.onyx.engine.state.StageExecutionContext.onTransition(StageExecutionContext.java:219) at org.obiba.onyx.engine.state.StageExecutionContext.castEvent(StageExecutionContext.java:116) at org.obiba.onyx.engine.state.AbstractStageState.castEvent(AbstractStageState.java:99) at org.obiba.onyx.marble.engine.state.MarbleInProgressState.complete(MarbleInProgressState.java:47) at org.obiba.onyx.engine.state.StageExecutionContext.complete(StageExecutionContext.java:173) at org.obiba.onyx.engine.ActionType$2.act(ActionType.java:36) at org.obiba.onyx.core.service.impl.DefaultActiveInterviewServiceImpl.doAction(DefaultActiveInterviewServiceImpl.java:143) 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:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy45.doAction(Unknown Source) 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:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy34.doAction(Unknown Source) 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:597) at org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:416) at org.apache.wicket.proxy.$Proxy43.doAction(Unknown Source) at org.obiba.onyx.wicket.action.ActionWindow$2.onClose(ActionWindow.java:59) [...]

    JIRA | 8 years ago | Philippe Laflamme
    org.hibernate.NonUniqueResultException: query did not return a unique result: 4
  6. 0

    Steps to reproduce (run with onyx-1.0): 1) Import the attached database dump in MySql using the MySql administrator tool 2) Log in onyx using administrator/password 3) Receive a new participant 4) Refuse consent CRASH! Stack trace: 2009-02-20 15:11:47,171 - ERROR - apache.wicket.RequestCycle - query did not return a unique result: 4 org.hibernate.NonUniqueResultException: query did not return a unique result: 4 at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305) at org.obiba.core.service.impl.hibernate.PersistenceManagerHibernateImpl.matchOne(PersistenceManagerHibernateImpl.java:82) at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy74.matchOne(Unknown Source) at org.obiba.onyx.quartz.core.service.impl.hibernate.QuestionnaireParticipantServiceHibernateImpl.isQuestionActive(QuestionnaireParticipantServiceHibernateImpl.java:85) at sun.reflect.GeneratedMethodAccessor98.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy83.isQuestionActive(Unknown Source) at org.obiba.onyx.quartz.engine.variable.impl.DefaultQuestionToVariableMappingStrategy.getVariableData(DefaultQuestionToVariableMappingStrategy.java:205) at org.obiba.onyx.quartz.engine.QuartzModule.getVariableData(QuartzModule.java:213) at org.obiba.onyx.engine.variable.VariableDirectory.getVariableData(VariableDirectory.java:162) at org.obiba.onyx.engine.VariableStageDependencyCondition.isDependencySatisfied(VariableStageDependencyCondition.java:74) at org.obiba.onyx.engine.MultipleStageDependencyCondition.isDependencySatisfied(MultipleStageDependencyCondition.java:85) at org.obiba.onyx.engine.state.AbstractStageState.areDependenciesCompleted(AbstractStageState.java:93) at org.obiba.onyx.engine.state.AbstractStageState.onTransition(AbstractStageState.java:78) at org.obiba.onyx.engine.state.StageExecutionContext.onTransition(StageExecutionContext.java:219) at org.obiba.onyx.engine.state.StageExecutionContext.castEvent(StageExecutionContext.java:116) at org.obiba.onyx.engine.state.AbstractStageState.castEvent(AbstractStageState.java:99) at org.obiba.onyx.engine.state.AbstractStageState.onTransition(AbstractStageState.java:87) at org.obiba.onyx.engine.state.StageExecutionContext.onTransition(StageExecutionContext.java:219) at org.obiba.onyx.engine.state.StageExecutionContext.castEvent(StageExecutionContext.java:116) at org.obiba.onyx.engine.state.AbstractStageState.castEvent(AbstractStageState.java:99) at org.obiba.onyx.marble.engine.state.MarbleInProgressState.complete(MarbleInProgressState.java:47) at org.obiba.onyx.engine.state.StageExecutionContext.complete(StageExecutionContext.java:173) at org.obiba.onyx.engine.ActionType$2.act(ActionType.java:36) at org.obiba.onyx.core.service.impl.DefaultActiveInterviewServiceImpl.doAction(DefaultActiveInterviewServiceImpl.java:143) at sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy130.doAction(Unknown Source) at sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy78.doAction(Unknown Source) at sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:416) at org.apache.wicket.proxy.$Proxy127.doAction(Unknown Source) at org.obiba.onyx.wicket.action.ActionWindow$2.onClose(ActionWindow.java:59) at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow$WindowClosedBehavior.respond(ModalWindow.java:832) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297) at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:100) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1175) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1252) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1353) at org.apache.wicket.RequestCycle.request(RequestCycle.java:493) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:355) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:200) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source)

    JIRA | 8 years ago | Martin Boulanger
    org.hibernate.NonUniqueResultException: query did not return a unique result: 4

    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: 27

      at org.hibernate.impl.AbstractQueryImpl.uniqueElement()
    2. Hibernate
      CriteriaImpl.uniqueResult
      1. org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:789)
      2. org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
      2 frames