dhis2-users team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

Thank you Tran,
Yes it was old Revision Now ,
I downloaded R 13806 for 2.14 and
R12980 for 2.13 try on both.

   - Aggregate query builder test button work and no error massage
   - Manual person aggregation also work well and show that data is pass to
   aggregate data elements in preview menu.
   - But that value *not shows in reports/ data entry form or mysql
   database datavalue table  * ?




On Thu, Mar 6, 2014 at 9:44 PM, Tran Chau <tran.hispvietnam@xxxxxxxxx>wrote:

> Hi Sumudu,
>
> Which revision in 2.14 version do you used for testing ? Can you help me
> to test with R. 13799 or above ?
>
> Best regards,
> ------------------------------------------------
> Châu Thu Trân
> HISP Viet Nam
> Email: tran.hispvietnam@xxxxxxxxx
>
>
> On Thu, Mar 6, 2014 at 10:13 PM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>wrote:
>
>> Now it is working in 2.13. But 2.14 still having same problem and sending
>> same error message in Mysql sql.?
>>
>>
>> On Mon, Mar 3, 2014 at 12:23 AM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>wrote:
>>
>>> 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
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>