dhis2-users team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

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