← Back to team overview

dhis2-users team mailing list archive

Re: Data Entry Error

 

Hello,
I've been facing the same issue with 2.18 live. Someone suggested that it
might related to database engine: it happens with h2 and MySQL but not
PostgreSQL.

-----------------
Abda Anne
Bamako (Mali)

On Tue, Apr 28, 2015 at 2:47 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> Hi
>
> Could you include the log from your tomcat server? We need to see the full
> error.
>
> --
> Morten
>
> On Tue, Apr 28, 2015 at 12:59 AM, Obaloluwa Adekola <
> oadekola.mems@xxxxxxxxx> wrote:
>
>> Hi,
>>
>> What possibly could be the cause of this error message when trying to
>> enter data for a particular dataset in a specific period? The same dataset
>> accepts data for other periods. This error comes up when the complete
>> button is clicked for a particular period.
>>
>> Below is the error message (highlighted in yellow) and attached is a
>> screenshot.
>>
>> Many thanks.
>>
>> HTTP Status 500 - Request processing failed; nested exception is
>> org.hibernate.NonUniqueResultException: query did not return a unique
>> result: 2
>>
>> type Exception report
>>
>> message Request processing failed; nested exception is
>> org.hibernate.NonUniqueResultException: query did not return a unique
>> result: 2
>>
>> description The server encountered an internal error that prevented it
>> from fulfilling this request.
>>
>> exception
>>
>> org.springframework.web.util.NestedServletException: Request processing
>> failed; nested exception is org.hibernate.NonUniqueResultException: query
>> did not return a unique result: 2
>>
>> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
>>
>> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
>>
>> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>> net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:202)
>> net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:180)
>>
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>>
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>>
>> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>>
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>>
>> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>>
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>>
>> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>>
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References