dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

Hi Sunudu,

Which is the revision you used ? It should be R. 12980. Can you check this
revision on you side ?

Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx


On Sun, Mar 2, 2014 at 1:11 PM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>wrote:

> 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
>>>
>>>
>>
>