Data Entry Error

Support - Assistance technique
1

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

image

2

Hi

Could you include the log from your tomcat server? We need to see the full error.

···

On Tue, Apr 28, 2015 at 12:59 AM, Obaloluwa Adekola oadekola.mems@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Morten

3

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.

···

On Tue, Apr 28, 2015 at 2:47 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

Could you include the log from your tomcat server? We need to see the full error.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Abda Anne
Bamako (Mali)

–
Morten

On Tue, Apr 28, 2015 at 12:59 AM, Obaloluwa Adekola oadekola.mems@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

4

Did you guys try the very latest version of 2.18 / 2.18 live? there was a few updates last week

···

On Tue, Apr 28, 2015 at 10:01 AM, Abda ANNE girlajo@gmail.com wrote:

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.

–
Morten

Abda Anne
Bamako (Mali)

On Tue, Apr 28, 2015 at 2:47 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Hi

Could you include the log from your tomcat server? We need to see the full error.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Morten

On Tue, Apr 28, 2015 at 12:59 AM, Obaloluwa Adekola oadekola.mems@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

5

Hi Morten,

The error still persists after upgrading to the latest build of version 2.18.

What do you advise we do?

Abda, we are using PostgreSQL.

Regards,

···

On Tue, Apr 28, 2015 at 4:03 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

Did you guys try the very latest version of 2.18 / 2.18 live? there was a few updates last week

–

–
Morten

On Tue, Apr 28, 2015 at 10:01 AM, Abda ANNE girlajo@gmail.com wrote:

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@gmail.com wrote:

Hi

Could you include the log from your tomcat server? We need to see the full error.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Morten

On Tue, Apr 28, 2015 at 12:59 AM, Obaloluwa Adekola oadekola.mems@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Adekola Obaloluwa Emmanuel,
*IT/M&E Associate,
USAID/Nigeria,
Monitoring and Evaluation Management Services (MEMS) II,
17, Euphrates Street, Maitama, Abuja, Nigeria.
**Mobile1:**234 809 072 6621
**Mobile2:*234 903 030 4652

Website:new.nigeriamems.com