dhis2-users team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

Hi Tran,
Yes, your correct it was R12979.I have update with R12980. It is working
now!
Many thanks for your help.

Sumudu



On Sun, Mar 2, 2014 at 7:59 PM, Tran Chau <tran.hispvietnam@xxxxxxxxx>wrote:

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