dhis2-users team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

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