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

hibernate.org | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Hibernate Community • View topic - SubSelect in from clause

    hibernate.org | 8 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 | 6 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

    1 unregistered visitors
    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