dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #04022
Re: Tracker Problem
Thanks Tran.
I try it again in following steps but *not worked*
1. export xml metadata
2. I download 2.13 from the site on 28 feb from (
http://www.dhis2.org/downloads)
3. replace it with my previous war file and deployed
4. metadata imported
5. some missing part of person data created again according to user
guideline
6. try to create query builder in it ,but it is still not working
7. Similar error reported as
* ERROR 2014-03-02 10:48:54,455 Error while executing action
(ExceptionIntercept
or.java [http-apr-8084-exec-7])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
gram
mar [
SELECT '0' as dataelementid, '0' as categoryoptioncomboid, ou.organisationu
nitid as sourceid, '0' as periodid,'DHIS-SYSTEM' as comment, '201403' as
periodI
soDate,'dataelementname' as dataelementname, 'optioncomboid' as
categoryoptionco
mboname, ou.name as organisationunitname, count (distinct(pi.patientid) )
as va
lue FROM programinstance as pi INNER JOIN patient p on
p.patientid=pi.patienti
d INNER JOIN programstageinstance psi ON
pi.programinstanceid=psi.programinstan
ceid INNER JOIN organisationunit ou ON
ou.organisationunitid=psi.organisationun
itid WHERE EXISTS ( SELECT * FROM patientdatavalue _pdv inner join
programstag
einstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid
JOIN p
rograminstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE
psi.pro
gramstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=40 AND
_
psi.organisationunitid in (0) AND _pi.programid = 1 AND
_psi.executionDate>='
2014-03-02' AND _psi.executionDate <= '2014-03-02' AND _psi.programstageid
= 1
AND _pdv.value is not null ) GROUP BY ou.organisationunitid, ou.name]
jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Yo
u have an error in your SQL syntax; check the manual that corresponds to
your My
SQL server version for the right syntax to use near 'distinct(pi.patientid)
) as
value FROM programinstance as pi INNER JOIN patien' at line 1
- Two errors i found are marked in red 1st extra space 2nd no space
- I tested it on
- *Crome* as browser ,
- Database *MySQL Server 5.1*
- Java *jdk1.7.0_04*
- server *apache-tomcat-7.0.50*
- Aggregation Query Builder Management *screen shot *and full* log
file *attach
here
On Fri, Feb 28, 2014 at 2:57 PM, Tran Chau <tran.hispvietnam@xxxxxxxxx>wrote:
> HI Sumudu,
>
> I fixed it for 2.13. Please test it on your site again. Thank you.
>
> Best regards,
> ------------------------------------------------
> Châu Thu Trân
> HISP Viet Nam
> Email: tran.hispvietnam@xxxxxxxxx
>
>
> On Tue, Feb 25, 2014 at 3:07 PM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>wrote:
>
>> *Dear All,*
>> *I am Sumudu from Sri lanka, my research interest in health information
>> management system, new to dhis and try to customize dhis to Mental health
>> unit . i had customized aggregate part with out a problem. But when i try
>> to aggregate and pass patient data by tracker to my aggregate part, it was
>> not work properly *
>>
>> - *My dhis version is 2.13*
>> - *Database Mysql*
>>
>> *When i try on sample as mention in user_manual (26.2.1.8.2. Sample of
>> person aggregation)*
>>
>> - *Aggregation Query Builder Management test condition shows as "Run
>> fail"*
>>
>>
>>> - *Error show as follows*
>>>
>>> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
>> SQL gram
>> mar [SELECT '0' as dataelementid, '0' as categoryoptioncomboid,
>> ou.organisationu
>> nitid as sourceid, '0' as periodid,'DHIS-SYSTEM' as comment, '201402' as
>> periodI
>> soDate,'dataelementname' as dataelementname, 'optioncomboid' as
>> categoryoptionco
>> mboname, ou.name as organisationunitname, count (distinct(pi.patientid)
>> ) as va
>> lue FROM programinstance as pi INNER JOIN patient p on
>> p.patientid=pi.patientid
>> INNER JOIN organisationunit ou ON
>> ou.organisationunitid=p.organisationunitid
>> WHERE EXISTS (SELECT _p.patientid FROM patient _p WHERE _p.patientid =
>> pi.patie
>> ntid AND gender ='M' ) GROUP BY ou.organisationunitid, ou.name]; nested
>> exceptio
>> n is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have
>> an erro
>> r in your SQL syntax; check the manual that corresponds to your MySQL
>> server ver
>> sion for the right syntax to use near 'distinct(pi.patientid) ) as value
>> FROM p
>> rograminstance as pi INNER JOIN patient' at line 1
>>
>>>
>>> - * Aggregation Query Builder Management screen shot attach here *
>>>
>>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help : https://help.launchpad.net/ListHelp
>>
>>
>
nnMar 02, 2014 10:18:08 AM org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.29 using APR version 1.4
.8.
Mar 02, 2014 10:18:08 AM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], ra
ndom [true].
Mar 02, 2014 10:18:09 AM org.apache.catalina.core.AprLifecycleListener initializ
eSSL
INFO: OpenSSL successfully initialized (OpenSSL 1.0.1e 11 Feb 2013)
Mar 02, 2014 10:18:10 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-8084"]
Mar 02, 2014 10:18:10 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-apr-8009"]
Mar 02, 2014 10:18:10 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2146 ms
Mar 02, 2014 10:18:10 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Mar 02, 2014 10:18:10 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.50
Mar 02, 2014 10:18:10 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\Apache\Apache-conf\conf\Catalina\loc
alhost\manager.xml
Mar 02, 2014 10:18:10 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\Apache\Apache-conf\conf\Catalina\loc
alhost\ROOT.xml
Mar 02, 2014 10:18:11 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\Apache\Apache-conf\webapps\dhis.war
* INFO 2014-03-02 10:18:36,571 System property dhis2.home not set (DefaultLocat
ionManager.java [localhost-startStop-1])
* INFO 2014-03-02 10:18:36,573 Environment variable DHIS2_HOME points to C:\DHI
S2_HOME (DefaultLocationManager.java [localhost-startStop-1])
* INFO 2014-03-02 10:18:37,314 Hibernate configuration loaded, using dialect: o
rg.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [l
ocalhost-startStop-1])
* ERROR 2014-03-02 10:18:57,655 HHH000388: Unsuccessful: alter table dataelement
categoryoption add index fk_dataelementcategory_conceptid (conceptid), add const
raint fk_dataelementcategory_conceptid foreign key (conceptid) references concep
t (conceptid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:57,657 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,067 HHH000388: Unsuccessful: alter table indicator a
dd index fk_indicator_userid (userid), add constraint fk_indicator_userid foreig
n key (userid) references userinfo (userinfoid) (SchemaUpdate.java [localhost-st
artStop-1])
* ERROR 2014-03-02 10:18:58,072 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,275 HHH000388: Unsuccessful: alter table interpretat
ioncomment add index fk_interpretation_userid (userid), add constraint fk_interp
retation_userid foreign key (userid) references userinfo (userinfoid) (SchemaUpd
ate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,281 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,422 HHH000388: Unsuccessful: alter table orgunitgrou
p add index fk_indicator_userid (userid), add constraint fk_indicator_userid for
eign key (userid) references userinfo (userinfoid) (SchemaUpdate.java [localhost
-startStop-1])
* ERROR 2014-03-02 10:18:58,426 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,586 HHH000388: Unsuccessful: alter table programstag
einstance add index fk_programinstance_patientcommentid (patientcommentid), add
constraint fk_programinstance_patientcommentid foreign key (patientcommentid) re
ferences patientcomment (patientcommentid) (SchemaUpdate.java [localhost-startSt
op-1])
* ERROR 2014-03-02 10:18:58,588 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,706 HHH000388: Unsuccessful: alter table report add
index fk_report_relativeperiodsid (relativeperiodsid), add constraint fk_report_
relativeperiodsid foreign key (relativeperiodsid) references relativeperiods (re
lativeperiodsid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,707 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,855 HHH000388: Unsuccessful: alter table reporttable
add index fk_report_relativeperiodsid (relativeperiodsid), add constraint fk_re
port_relativeperiodsid foreign key (relativeperiodsid) references relativeperiod
s (relativeperiodsid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:58,857 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2014-03-02 10:18:59,016 HHH000388: Unsuccessful: alter table usergroupme
mbers add index fk_usergroup_userid (userid), add constraint fk_usergroup_userid
foreign key (userid) references userinfo (userinfoid) (SchemaUpdate.java [local
host-startStop-1])
* ERROR 2014-03-02 10:18:59,018 Can't create table 'dhis.#sql-844_2' (errno: 121
) (SchemaUpdate.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:07,322 Found the following message senders: [org.hisp.d
his.message.EmailMessageSender@1be137a, org.hisp.dhis.sms.SmsMessageSender@1f0dd
a4] (DefaultMessageService.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:15,400 Detecting apps: [] (DefaultAppManager.java [loca
lhost-startStop-1])
* INFO 2014-03-02 10:19:21,365 Executing startup routine [1 of 11, runlevel 1]:
TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:23,421 Tables updated (TableAlteror.java [localhost-sta
rtStop-1])
* INFO 2014-03-02 10:19:23,422 Executing startup routine [2 of 11, runlevel 1]:
MapViewUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:23,474 Executing startup routine [3 of 11, runlevel 2]:
IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:25,346 Executing startup routine [4 of 11, runlevel 2]:
PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]
)
* INFO 2014-03-02 10:19:25,371 Executing startup routine [5 of 11, runlevel 3]:
TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:25,383 Executing startup routine [6 of 11, runlevel 3]:
DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [local
host-startStop-1])
* INFO 2014-03-02 10:19:26,006 Linked default category with default concept (Da
taElementDefaultDimensionPopulator.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:26,288 Executing startup routine [7 of 11, runlevel 4]:
PatientTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]
)
* INFO 2014-03-02 10:19:26,936 Executing startup routine [8 of 11, runlevel 5]:
DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-
1])
* INFO 2014-03-02 10:19:26,938 Upgraded custom case entry form identifiers: 1 (
DataEntryFormUpgrader.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:26,939 Executing startup routine [9 of 11, runlevel 6]:
ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO 2014-03-02 10:19:26,953 Executing startup routine [10 of 11, runlevel 7]
: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startSto
p-1])
* INFO 2014-03-02 10:19:26,957 Executing startup routine [11 of 11, runlevel 7]
: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1
])
* INFO 2014-03-02 10:19:26,963 All startup routines done (DefaultStartupRoutine
Executor.java [localhost-startStop-1])
Mar 02, 2014 10:19:33 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8084"]
Mar 02, 2014 10:19:33 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
Mar 02, 2014 10:19:33 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 83291 ms
* INFO 2014-03-02 10:25:16,288 Login success for user: 'admin', ip: '127.0.0.1'
(DefaultUserAuditService.java [http-apr-8084-exec-6])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram
mar [SELECT '0' as dataelementid, '0' as categoryoptioncomboid, ou.organisationu
nitid as sourceid, '0' as periodid,'DHIS-SYSTEM' as comment, '201403' as periodI
soDate,'dataelementname' as dataelementname, 'optioncomboid' as categoryoptionco
mboname, ou.name as organisationunitname, count (distinct(pi.patientid) ) as va
lue FROM programinstance as pi INNER JOIN patient p on p.patientid=pi.patienti
d INNER JOIN programstageinstance psi ON pi.programinstanceid=psi.programinstan
ceid INNER JOIN organisationunit ou ON ou.organisationunitid=psi.organisationun
itid WHERE EXISTS ( SELECT * FROM patientdatavalue _pdv inner join programstag
einstance _psi ON _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN p
rograminstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE psi.pro
gramstageinstanceid=_pdv.programstageinstanceid AND _pdv.dataelementid=40 AND _
psi.organisationunitid in (0) AND _pi.programid = 1 AND _psi.executionDate>='
2014-03-02' AND _psi.executionDate <= '2014-03-02' AND _psi.programstageid = 1
AND _pdv.value is not null ) GROUP BY ou.organisationunitid, ou.name]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have
an error in your SQL syntax; check the manual that corresponds to your MySQL se
rver version for the right syntax to use near 'distinct(pi.patientid) ) as value
FROM programinstance as pi INNER JOIN patien' at line 1
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
oTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
407)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:45
6)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:46
4)
at org.hisp.dhis.caseaggregation.jdbc.JdbcCaseAggregationConditionManage
r.executeSQL(JdbcCaseAggregationConditionManager.java:138)
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.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:198)
at $Proxy78.executeSQL(Unknown Source)
at org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationCondi
tionAction.execute(TestCaseAggregationConditionAction.java:111)
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(DefaultA
ctionInvocation.java:450)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
ultActionInvocation.java:289)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:252)
at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
ept(XWorkPortalUserInterceptor.java:88)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
rcept(XWorkPortalModuleInterceptor.java:93)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
ept(XWorkPortalMenuInterceptor.java:97)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
rcept(XWorkPortalParamsInterceptor.java:119)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
ptor.java:83)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettin
gInterceptor.java:81)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInte
rceptor.java:85)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X
WorkSecurityInterceptor.java:113)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe
ttingInterceptor.java:106)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j
ava:136)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.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(DefaultActionI
nvocation.java:246)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
cept(StaticParametersInterceptor.java:191)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
erceptor.java:110)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
ava:54)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav
a:562)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(Exec
uteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
.doFilter(StrutsPrepareAndExecuteFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.invoke(FilterSecurityInterceptor.java:118)
at org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.doFilter(FilterSecurityInterceptor.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.access.ExceptionTranslationFilter.do
Filter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.session.SessionManagementFilter.doFi
lter(SessionManagementFilter.java:103)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AnonymousAuthenticati
onFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.servletapi.SecurityContextHolderAwar
eRequestFilter.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.BasicAuthenticati
onFilter.doFilter(BasicAuthenticationFilter.java:150)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(Cus
tomAuthenticationFilter.java:64)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.authentication.logout.LogoutFilter.d
oFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(Automati
cAccessFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.context.SecurityContextPersistenceFi
lter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(Fi
lterChainProxy.java:192)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChai
nProxy.java:160)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
elegatingFilterProxy.java:343)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
ingFilterProxy.java:260)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java:152)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:409)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1044)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:607)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpo
int.java:2441)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoin
t.java:2430)
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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have a
n error in your SQL syntax; check the manual that corresponds to your MySQL serv
er version for the right syntax to use near 'distinct(pi.patientid) ) as value F
ROM programinstance as pi INNER JOIN patien' at line 1
at sun.reflect.GeneratedConstructorAccessor56.newInstance(Unknown Source
)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1556)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyState
ment.java:35)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.do
InStatement(JdbcTemplate.java:441)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
396)
... 106 more
Attachment:
aggregate query_2_3_2014.JPG
Description: JPEG image
Follow ups
References
