org.hibernate.NonUniqueResultException

query did not return a unique result: 2

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web39

  • via Unknown by Meryam Belhiah,
  • via Unknown by Meryam Belhiah,
  • via Unknown by Martin Boulanger,
  • Stack trace

    • org.hibernate.NonUniqueResultException: query did not return a unique result: 2 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:86) at sun.reflect.GeneratedMethodAccessor50.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 $Proxy37.matchOne(Unknown Source) at org.obiba.onyx.ruby.magma.TubeValueSetBeanResolver.resolveParticipantTubeRegistration(TubeValueSetBeanResolver.java:96) at org.obiba.onyx.ruby.magma.TubeValueSetBeanResolver.resolveRegisteredParticipantTubes(TubeValueSetBeanResolver.java:106) at org.obiba.onyx.ruby.magma.TubeValueSetBeanResolver.resolve(TubeValueSetBeanResolver.java:60) at org.obiba.magma.beans.BeanValueTable.resolve(BeanValueTable.java:58) at org.obiba.magma.beans.BeanValueTable.access$000(BeanValueTable.java:19) at org.obiba.magma.beans.BeanValueTable$1.resolve(BeanValueTable.java:43) at org.obiba.magma.beans.BeanPropertyVariableValueSource.getValue(BeanPropertyVariableValueSource.java:58) at org.obiba.magma.support.AbstractValueTable.getValue(AbstractValueTable.java:85) at org.obiba.magma.support.AbstractValueTableWrapper.getValue(AbstractValueTableWrapper.java:38) at org.obiba.magma.datasource.fs.DatasourceCopier.copy(DatasourceCopier.java:106) at org.obiba.onyx.engine.variable.export.OnyxDataExport.internalExport(OnyxDataExport.java:150) at org.obiba.onyx.engine.variable.export.OnyxDataExport.exportInterviews(OnyxDataExport.java:105) at org.obiba.onyx.engine.variable.export.OnyxDataExport$$FastClassByCGLIB$$c7571da3.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) 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.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at org.obiba.onyx.engine.variable.export.OnyxDataExport$$EnhancerByCGLIB$$615f3280.exportInterviews(<generated>) at org.obiba.onyx.engine.variable.export.OnyxDataExport$$FastClassByCGLIB$$c7571da3.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.apache.wicket.proxy.LazyInitProxyFactory$CGLibInterceptor.intercept(LazyInitProxyFactory.java:319) at WICKET_org.obiba.onyx.engine.variable.export.OnyxDataExport$$EnhancerByCGLIB$$eea36e4f.exportInterviews(<generated>) at org.obiba.onyx.webapp.participant.page.ParticipantSearchPage$ActionFragment$3$1.onYesButtonClicked(ParticipantSearchPage.java:538) at org.obiba.onyx.wicket.reusable.ConfirmationDialog$1.onClose(ConfirmationDialog.java:45) at org.obiba.onyx.wicket.reusable.Dialog$7.onClose(Dialog.java:373) at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow$WindowClosedBehavior.respond(ModalWindow.java:936) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:299) at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1428) at org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:479) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:312) 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.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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitor2 times, last one