dhis2-devs team mailing list archive

[Muhammad Tauqeer Ikram <tauqeerikram@xxxxxxxxxxx>]

Public bug reported:

[+] Exception (org.hibernate.exception.GenericJDBCException): Function "DATE" not found; SQL statement: select psi.programstageinstanceid, p.phonenumber, prm.templatemessage, p.firstname, p.middlename, p.lastname, org.name as orgunitName ,pg.name as programName, ps.name as programStageName, psi.duedate,(DATE(now()) - DATE(psi.duedate) ) as days_since_due_date,psi.duedate from patient p INNER JOIN programinstance pi ON p.patientid=pi.patientid INNER JOIN programstageinstance psi ON psi.programinstanceid=pi.programinstanceid INNER JOIN program pg ON pg.programid=pi.programid INNER JOIN programstage ps ON ps.programstageid=psi.programstageid INNER JOIN organisationunit org ON org.organisationunitid = p.organisationunitid INNER JOIN patientreminder prm ON prm.programstageid = ps.programstageid WHERE pi.completed=false and p.phonenumber is not NULL and p.phonenumber != '' and prm.templatemessage is not NULL and prm.templatemessage != '' and pg.type=1 and prm.daysallowedsendmessage is not null and psi.executiondate is null and ( DATE(now()) - DATE(psi.duedate) ) = prm.daysallowedsendmessage [90022-166] 
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) 
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) 
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) 
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) 
org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) 
sun.proxy.$Proxy146.executeQuery(Unknown source) 
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) 
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499) 
org.hisp.dhis.program.hibernate.HibernateProgramStageInstanceStore.getSendMesssageEvents(HibernateProgramStageInstanceStore.java:304) 
org.hisp.dhis.program.DefaultProgramStageInstanceService.getSendMesssageEvents(DefaultProgramStageInstanceService.java:274) 
sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
java.lang.reflect.Method.invoke(Unknown source) 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) 
sun.proxy.$Proxy61.getSendMesssageEvents(Unknown source) 
org.hisp.dhis.mobile.action.ShowSentSMSAction.execute(ShowSentSMSAction.java:106) 
sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
java.lang.reflect.Method.invoke(Unknown source) 
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) 
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) 
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:113) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) 
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510) 
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:432) 
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322) 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184) 
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155) 
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) 
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119) 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) 
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) 
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) 
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) 
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) 
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440) 
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) 
org.mortbay.jetty.Server.handle(Server.java:326) 
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) 
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926) 
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) 
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) 
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) 
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) 
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) 
[+] Caused by (org.h2.jdbc.JdbcSQLException): Function "DATE" not found; SQL statement: select psi.programstageinstanceid, p.phonenumber, prm.templatemessage, p.firstname, p.middlename, p.lastname, org.name as orgunitName ,pg.name as programName, ps.name as programStageName, psi.duedate,(DATE(now()) - DATE(psi.duedate) ) as days_since_due_date,psi.duedate from patient p INNER JOIN programinstance pi ON p.patientid=pi.patientid INNER JOIN programstageinstance psi ON psi.programinstanceid=pi.programinstanceid INNER JOIN program pg ON pg.programid=pi.programid INNER JOIN programstage ps ON ps.programstageid=psi.programstageid INNER JOIN organisationunit org ON org.organisationunitid = p.organisationunitid INNER JOIN patientreminder prm ON prm.programstageid = ps.programstageid WHERE pi.completed=false and p.phonenumber is not NULL and p.phonenumber != '' and prm.templatemessage is not NULL and prm.templatemessage != '' and pg.type=1 and prm.daysallowedsendmessage is not null and psi.executiondate is null and ( DATE(now()) - DATE(psi.duedate) ) = prm.daysallowedsendmessage [90022-166] 
org.h2.message.DbException.getJdbcSQLException(DbException.java:329) 
org.h2.message.DbException.get(DbException.java:169) 
org.h2.message.DbException.get(DbException.java:146) 
org.h2.command.Parser.readJavaFunction(Parser.java:2122) 
org.h2.command.Parser.readFunction(Parser.java:2174) 
org.h2.command.Parser.readTerm(Parser.java:2476) 
org.h2.command.Parser.readFactor(Parser.java:2046) 
org.h2.command.Parser.readSum(Parser.java:2033) 
org.h2.command.Parser.readConcat(Parser.java:2006) 
org.h2.command.Parser.readCondition(Parser.java:1871) 
org.h2.command.Parser.readAnd(Parser.java:1852) 
org.h2.command.Parser.readExpression(Parser.java:1844) 
org.h2.command.Parser.readTerm(Parser.java:2558) 
org.h2.command.Parser.readFactor(Parser.java:2046) 
org.h2.command.Parser.readSum(Parser.java:2033) 
org.h2.command.Parser.readConcat(Parser.java:2006) 
org.h2.command.Parser.readCondition(Parser.java:1871) 
org.h2.command.Parser.readAnd(Parser.java:1852) 
org.h2.command.Parser.readExpression(Parser.java:1844) 
org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1757) 
org.h2.command.Parser.parseSelectSimple(Parser.java:1789) 
org.h2.command.Parser.parseSelectSub(Parser.java:1684) 
org.h2.command.Parser.parseSelectUnion(Parser.java:1527) 
org.h2.command.Parser.parseSelect(Parser.java:1515) 
org.h2.command.Parser.parsePrepared(Parser.java:405) 
org.h2.command.Parser.parse(Parser.java:279) 
org.h2.command.Parser.parse(Parser.java:251) 
org.h2.command.Parser.prepareCommand(Parser.java:217) 
org.h2.engine.Session.prepareLocal(Session.java:415) 
org.h2.engine.Session.prepareCommand(Session.java:364) 
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1111) 
org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:70) 
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) 
sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
java.lang.reflect.Method.invoke(Unknown source) 
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) 
org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) 
sun.proxy.$Proxy146.executeQuery(Unknown source) 
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) 
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499) 
org.hisp.dhis.program.hibernate.HibernateProgramStageInstanceStore.getSendMesssageEvents(HibernateProgramStageInstanceStore.java:304) 
org.hisp.dhis.program.DefaultProgramStageInstanceService.getSendMesssageEvents(DefaultProgramStageInstanceService.java:274) 
sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
java.lang.reflect.Method.invoke(Unknown source) 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) 
sun.proxy.$Proxy61.getSendMesssageEvents(Unknown source) 
org.hisp.dhis.mobile.action.ShowSentSMSAction.execute(ShowSentSMSAction.java:106) 
sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
java.lang.reflect.Method.invoke(Unknown source) 
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) 
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) 
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:113) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) 
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100) 
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) 
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510) 
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:432) 
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322) 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184) 
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155) 
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) 
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119) 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) 
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) 
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) 
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) 
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) 
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440) 
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) 
org.mortbay.jetty.Server.handle(Server.java:326) 
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) 
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926) 
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) 
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) 
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) 
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) 
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1126005

Title:
  I have experienced error in getting list of sent messages

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  [+] Exception (org.hibernate.exception.GenericJDBCException): Function "DATE" not found; SQL statement: select psi.programstageinstanceid, p.phonenumber, prm.templatemessage, p.firstname, p.middlename, p.lastname, org.name as orgunitName ,pg.name as programName, ps.name as programStageName, psi.duedate,(DATE(now()) - DATE(psi.duedate) ) as days_since_due_date,psi.duedate from patient p INNER JOIN programinstance pi ON p.patientid=pi.patientid INNER JOIN programstageinstance psi ON psi.programinstanceid=pi.programinstanceid INNER JOIN program pg ON pg.programid=pi.programid INNER JOIN programstage ps ON ps.programstageid=psi.programstageid INNER JOIN organisationunit org ON org.organisationunitid = p.organisationunitid INNER JOIN patientreminder prm ON prm.programstageid = ps.programstageid WHERE pi.completed=false and p.phonenumber is not NULL and p.phonenumber != '' and prm.templatemessage is not NULL and prm.templatemessage != '' and pg.type=1 and prm.daysallowedsendmessage is not null and psi.executiondate is null and ( DATE(now()) - DATE(psi.duedate) ) = prm.daysallowedsendmessage [90022-166] 
  org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) 
  org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) 
  org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) 
  org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) 
  org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) 
  sun.proxy.$Proxy146.executeQuery(Unknown source) 
  org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) 
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) 
  org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) 
  org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499) 
  org.hisp.dhis.program.hibernate.HibernateProgramStageInstanceStore.getSendMesssageEvents(HibernateProgramStageInstanceStore.java:304) 
  org.hisp.dhis.program.DefaultProgramStageInstanceService.getSendMesssageEvents(DefaultProgramStageInstanceService.java:274) 
  sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
  sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
  sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
  java.lang.reflect.Method.invoke(Unknown source) 
  org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) 
  org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
  org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
  org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) 
  sun.proxy.$Proxy61.getSendMesssageEvents(Unknown source) 
  org.hisp.dhis.mobile.action.ShowSentSMSAction.execute(ShowSentSMSAction.java:106) 
  sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
  sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
  sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
  java.lang.reflect.Method.invoke(Unknown source) 
  com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) 
  com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:113) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) 
  com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) 
  org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510) 
  org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:432) 
  org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322) 
  org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) 
  org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184) 
  org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155) 
  org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) 
  org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 
  org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
  org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119) 
  org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) 
  org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
  org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) 
  org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) 
  org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) 
  org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) 
  org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440) 
  org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) 
  org.mortbay.jetty.Server.handle(Server.java:326) 
  org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) 
  org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926) 
  org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) 
  org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) 
  org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) 
  org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) 
  org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) 
  [+] Caused by (org.h2.jdbc.JdbcSQLException): Function "DATE" not found; SQL statement: select psi.programstageinstanceid, p.phonenumber, prm.templatemessage, p.firstname, p.middlename, p.lastname, org.name as orgunitName ,pg.name as programName, ps.name as programStageName, psi.duedate,(DATE(now()) - DATE(psi.duedate) ) as days_since_due_date,psi.duedate from patient p INNER JOIN programinstance pi ON p.patientid=pi.patientid INNER JOIN programstageinstance psi ON psi.programinstanceid=pi.programinstanceid INNER JOIN program pg ON pg.programid=pi.programid INNER JOIN programstage ps ON ps.programstageid=psi.programstageid INNER JOIN organisationunit org ON org.organisationunitid = p.organisationunitid INNER JOIN patientreminder prm ON prm.programstageid = ps.programstageid WHERE pi.completed=false and p.phonenumber is not NULL and p.phonenumber != '' and prm.templatemessage is not NULL and prm.templatemessage != '' and pg.type=1 and prm.daysallowedsendmessage is not null and psi.executiondate is null and ( DATE(now()) - DATE(psi.duedate) ) = prm.daysallowedsendmessage [90022-166] 
  org.h2.message.DbException.getJdbcSQLException(DbException.java:329) 
  org.h2.message.DbException.get(DbException.java:169) 
  org.h2.message.DbException.get(DbException.java:146) 
  org.h2.command.Parser.readJavaFunction(Parser.java:2122) 
  org.h2.command.Parser.readFunction(Parser.java:2174) 
  org.h2.command.Parser.readTerm(Parser.java:2476) 
  org.h2.command.Parser.readFactor(Parser.java:2046) 
  org.h2.command.Parser.readSum(Parser.java:2033) 
  org.h2.command.Parser.readConcat(Parser.java:2006) 
  org.h2.command.Parser.readCondition(Parser.java:1871) 
  org.h2.command.Parser.readAnd(Parser.java:1852) 
  org.h2.command.Parser.readExpression(Parser.java:1844) 
  org.h2.command.Parser.readTerm(Parser.java:2558) 
  org.h2.command.Parser.readFactor(Parser.java:2046) 
  org.h2.command.Parser.readSum(Parser.java:2033) 
  org.h2.command.Parser.readConcat(Parser.java:2006) 
  org.h2.command.Parser.readCondition(Parser.java:1871) 
  org.h2.command.Parser.readAnd(Parser.java:1852) 
  org.h2.command.Parser.readExpression(Parser.java:1844) 
  org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1757) 
  org.h2.command.Parser.parseSelectSimple(Parser.java:1789) 
  org.h2.command.Parser.parseSelectSub(Parser.java:1684) 
  org.h2.command.Parser.parseSelectUnion(Parser.java:1527) 
  org.h2.command.Parser.parseSelect(Parser.java:1515) 
  org.h2.command.Parser.parsePrepared(Parser.java:405) 
  org.h2.command.Parser.parse(Parser.java:279) 
  org.h2.command.Parser.parse(Parser.java:251) 
  org.h2.command.Parser.prepareCommand(Parser.java:217) 
  org.h2.engine.Session.prepareLocal(Session.java:415) 
  org.h2.engine.Session.prepareCommand(Session.java:364) 
  org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1111) 
  org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:70) 
  com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) 
  sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
  sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
  sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
  java.lang.reflect.Method.invoke(Unknown source) 
  org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) 
  org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) 
  sun.proxy.$Proxy146.executeQuery(Unknown source) 
  org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) 
  org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) 
  org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) 
  org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499) 
  org.hisp.dhis.program.hibernate.HibernateProgramStageInstanceStore.getSendMesssageEvents(HibernateProgramStageInstanceStore.java:304) 
  org.hisp.dhis.program.DefaultProgramStageInstanceService.getSendMesssageEvents(DefaultProgramStageInstanceService.java:274) 
  sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
  sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
  sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
  java.lang.reflect.Method.invoke(Unknown source) 
  org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) 
  org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
  org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) 
  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) 
  org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) 
  sun.proxy.$Proxy61.getSendMesssageEvents(Unknown source) 
  org.hisp.dhis.mobile.action.ShowSentSMSAction.execute(ShowSentSMSAction.java:106) 
  sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source) 
  sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source) 
  sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source) 
  java.lang.reflect.Method.invoke(Unknown source) 
  com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) 
  com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:113) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) 
  com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100) 
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) 
  org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) 
  org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510) 
  org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:432) 
  org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322) 
  org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) 
  org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) 
  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) 
  org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184) 
  org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155) 
  org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) 
  org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 
  org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
  org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119) 
  org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) 
  org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) 
  org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) 
  org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) 
  org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) 
  org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) 
  org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440) 
  org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) 
  org.mortbay.jetty.Server.handle(Server.java:326) 
  org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) 
  org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926) 
  org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) 
  org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) 
  org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) 
  org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) 
  org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1126005/+subscriptions