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

JIRA | Daryl Armstrong | 4 years ago
  1. 0

    Step to reproduce: 1) Start and complete all the stages of an interview 2) Start a second interview 3) Complete the consent All other stages are skipped, but they should not. 4) Export the data of both interviews. You will get the following crash: 2009-05-21 10:53:54,259 - ERROR - able.export.OnyxDataExport - Error exporting data to destination DCC:query did not ret urn a unique result: 2 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(PersistenceManagerHibernateImp l.java:82) at sun.reflect.GeneratedMethodAccessor28.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 $Proxy31.matchOne(Unknown Source) at org.obiba.onyx.marble.core.service.impl.ConsentServiceImpl.getConsent(ConsentServiceImpl.java:34) at org.obiba.onyx.marble.engine.MarbleModule.getVariableData(MarbleModule.java:106) at org.obiba.onyx.engine.variable.VariableDirectory.getVariableData(VariableDirectory.java:165) at org.obiba.onyx.engine.variable.VariableDirectory.getParticipantData(VariableDirectory.java:124) at org.obiba.onyx.engine.variable.export.OnyxDataExport.exportCompletedInterviews(OnyxDataExport.java:139) 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:70 0) 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$$8e7132e5.exportCompletedInterviews(<ge nerated>) 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:318) at WICKET_org.obiba.onyx.engine.variable.export.OnyxDataExport$$EnhancerByCGLIB$$bc0a71de.exportCompletedIntervi ews(<generated>) at org.obiba.onyx.webapp.participant.page.ParticipantSearchPage$ActionFragment$3$1.onClose(ParticipantSearchPage .java:510) 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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.j ava:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:378) 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.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520) 2009-05-21 10:53:54,275 - ERROR - page.ParticipantSearchPage - Error on data export. 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(PersistenceManagerHibernateImp l.java:82) at sun.reflect.GeneratedMethodAccessor28.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 $Proxy31.matchOne(Unknown Source) at org.obiba.onyx.marble.core.service.impl.ConsentServiceImpl.getConsent(ConsentServiceImpl.java:34) at org.obiba.onyx.marble.engine.MarbleModule.getVariableData(MarbleModule.java:106) at org.obiba.onyx.engine.variable.VariableDirectory.getVariableData(VariableDirectory.java:165) at org.obiba.onyx.engine.variable.VariableDirectory.getParticipantData(VariableDirectory.java:124) at org.obiba.onyx.engine.variable.export.OnyxDataExport.exportCompletedInterviews(OnyxDataExport.java:139) 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:70 0) 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$$8e7132e5.exportCompletedInterviews(<ge nerated>) 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:318) at WICKET_org.obiba.onyx.engine.variable.export.OnyxDataExport$$EnhancerByCGLIB$$bc0a71de.exportCompletedIntervi ews(<generated>) at org.obiba.onyx.webapp.participant.page.ParticipantSearchPage$ActionFragment$3$1.onClose(ParticipantSearchPage .java:510) 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.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.j ava:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:378) 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.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

    JIRA | 8 years ago | Martin Boulanger
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Some participants have more than one entry in table onyx.participant_tube_registration. For example if I run the request: select interview_id, count(id) c, tube_set_name from participant_tube_registration group by interview_id order by c; I may have count(id)=2. So Onyx throws an error when exporting participants data, rolls back the transaction and CARTaGENE doesn't receive any data. For the moment, I found 6 participants with this problem. The additional entry in table participant_tube_registration is always associated with barcode=<participant_barcode>0101 in table registered_participant_tube. Error log : 2010-05-17 22:12:21,593 - ERROR - page.ParticipantSearchPage - Error on data export. 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)

    JIRA | 7 years ago | Meryam Belhiah
    org.hibernate.NonUniqueResultException: query did not return a unique result: 2
  4. 0

    Some participants have more than one entry in table onyx.participant_tube_registration. For example if I run the request: select interview_id, count(id) c, tube_set_name from participant_tube_registration group by interview_id order by c; I may have count(id)=2. So Onyx throws an error when exporting participants data, rolls back the transaction and CARTaGENE doesn't receive any data. For the moment, I found 6 participants with this problem. The additional entry in table participant_tube_registration is always associated with barcode=<participant_barcode>0101 in table registered_participant_tube. Error log : 2010-05-17 22:12:21,593 - ERROR - page.ParticipantSearchPage - Error on data export. 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)

    JIRA | 7 years ago | Meryam Belhiah
    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
      CriteriaImpl.uniqueResult
      1. org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820)
      2. org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
      2 frames
    3. org.obiba.core
      PersistenceManagerHibernateImpl.matchOne
      1. org.obiba.core.service.impl.hibernate.PersistenceManagerHibernateImpl.matchOne(PersistenceManagerHibernateImpl.java:86)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      3. java.lang.reflect.Method.invoke(Unknown Source)
      3 frames