dhis2-devs team mailing list archive

Thread
Date
[Bug 1188925] Re: Error in aggregation query builder expression

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: Ibrohim Kholmatov <ibrohimkhan@xxxxxxxxx>
Date: Tue, 11 Jun 2013 12:00:33 -0000
Reply-to: Bug 1188925 <1188925@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: dhis2
     Assignee: (unassigned) => Lars Helge Øverland (larshelge)

** Description changed:

  It seems that a bug is in the new version of DHIS2 (v12, build 11138). In the aggregation query builder expression we try making expression like:
  Age <=5
  (where AGe is a DE of type numeric). The system shows warning, that means an error happened. If we try an expression
- Age<="5", it works. 
+ Age<="5", it works.
  We verify and are sure that our DE is of type Numric, and we need it numeric. In the previous version (v11, build 10445) it perfectly works
+ 
+ here is log from tomcat:
+ 
+ * ERROR 2013-06-11 13:58:15,327 Error while executing action (ExceptionInterceptor.java [http-apr-8080-exec-10])
+ org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT '49' as dataelementid, '43' as categoryoptioncomboid, ou.organisationunitid as sourceid, '0' as periodid,'DHIS-SYSTEM' as comment, '201302' as periodIsoDate,'Гипатит Б' as dataelementname, '(5-9, Female)' as categoryoptioncomboname, ou.name as organisationunitname,  count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE  EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=63  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value ='Гепатит Б'  ) AND   EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=75  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value ='Female'  ) AND   EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=20  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value  >= 5  ) AND   EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=20  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value  <= 9 ) GROUP BY ou.organisationunitid, ou.name]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying >= integer
+   Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
+   Position: 1925
+ 	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
+ 	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
+ 	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
+ 	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
+ 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
+ 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
+ 	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
+ 	at org.hisp.dhis.caseaggregation.jdbc.JdbcCaseAggregationConditionManager.getAggregateValue(JdbcCaseAggregationConditionManager.java:189)
+ 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
+ 	at sun.reflect.NativeMethodAccessorImpl.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:317)
+ 	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
+ 	at $Proxy91.getAggregateValue(Unknown Source)
+ 	at org.hisp.dhis.caseaggregation.DefaultCaseAggregationConditionService.getAggregateValue(DefaultCaseAggregationConditionService.java:195)
+ 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
+ 	at sun.reflect.NativeMethodAccessorImpl.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:317)
+ 	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
+ 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
+ 	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
+ 	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
+ 	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
+ 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
+ 	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
+ 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
+ 	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
+ 	at $Proxy92.getAggregateValue(Unknown Source)
+ 	at org.hisp.dhis.caseentry.action.caseaggregation.CaseAggregationResultAction.execute(CaseAggregationResultAction.java:232)
+ 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
+ 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
+ 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
+ 	at java.lang.reflect.Method.invoke(Unknown Source)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
+ 	at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:112)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:103)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:135)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)
+ 	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:109)
+ 	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
+ 	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
+ 	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:546)
+ 	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
+ 	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
+ 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
+ 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
+ 	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
+ 	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
+ 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
+ 	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
+ 	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
+ 	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
+ 	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
+ 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
+ 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
+ 	at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)
+ 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
+ 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
+ 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
+ 	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
+ 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
+ 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
+ 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
+ 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
+ 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
+ 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
+ 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
+ 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
+ 	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
+ 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
+ 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
+ 	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
+ 	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
+ 	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)
+ 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
+ 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
+ 	at java.lang.Thread.run(Unknown Source)
+ Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying >= integer
+   Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
+   Position: 1925
+ 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
+ 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
+ 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
+ 	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
+ 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
+ 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
+ 	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
+ 	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
+ 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
+ 	... 121 more
  
  Best regards
  Ion

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

Title:
  Error in aggregation query builder expression

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  It seems that a bug is in the new version of DHIS2 (v12, build 11138). In the aggregation query builder expression we try making expression like:
  Age <=5
  (where AGe is a DE of type numeric). The system shows warning, that means an error happened. If we try an expression
  Age<="5", it works.
  We verify and are sure that our DE is of type Numric, and we need it numeric. In the previous version (v11, build 10445) it perfectly works

  here is log from tomcat:

  * ERROR 2013-06-11 13:58:15,327 Error while executing action (ExceptionInterceptor.java [http-apr-8080-exec-10])
  org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT '49' as dataelementid, '43' as categoryoptioncomboid, ou.organisationunitid as sourceid, '0' as periodid,'DHIS-SYSTEM' as comment, '201302' as periodIsoDate,'Гипатит Б' as dataelementname, '(5-9, Female)' as categoryoptioncomboname, ou.name as organisationunitname,  count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE  EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=63  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value ='Гепатит Б'  ) AND   EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=75  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value ='Female'  ) AND   EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=20  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value  >= 5  ) AND   EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstageinstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.programstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=20  AND _psi.organisationunitid in (23)  AND _pi.programid = 24 AND _psi.executionDate>='2013-02-01' AND _psi.executionDate <= '2013-02-28'  AND _psi.programstageid = 25 AND _pdv.value  <= 9 ) GROUP BY ou.organisationunitid, ou.name]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying >= integer
    Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
    Position: 1925
  	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
  	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
  	at org.hisp.dhis.caseaggregation.jdbc.JdbcCaseAggregationConditionManager.getAggregateValue(JdbcCaseAggregationConditionManager.java:189)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.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:317)
  	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
  	at $Proxy91.getAggregateValue(Unknown Source)
  	at org.hisp.dhis.caseaggregation.DefaultCaseAggregationConditionService.getAggregateValue(DefaultCaseAggregationConditionService.java:195)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.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:317)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
  	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  	at $Proxy92.getAggregateValue(Unknown Source)
  	at org.hisp.dhis.caseentry.action.caseaggregation.CaseAggregationResultAction.execute(CaseAggregationResultAction.java:232)
  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  	at java.lang.reflect.Method.invoke(Unknown Source)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
  	at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:112)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:103)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:135)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)
  	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:109)
  	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
  	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
  	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:546)
  	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
  	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
  	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
  	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
  	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
  	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
  	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
  	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
  	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
  	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  	at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)
  	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
  	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
  	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
  	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
  	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
  	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)
  	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  	at java.lang.Thread.run(Unknown Source)
  Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying >= integer
    Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
    Position: 1925
  	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
  	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  	... 121 more

  Best regards
  Ion

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

[Bug 1188925] [NEW] Error in aggregation query builder expression
From: Ion Stanciu, 2013-06-08