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.hispviet...@gmail.com>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.hispviet...@gmail.com > > > On Sun, Mar 2, 2014 at 1:11 PM, sumudu weerasinghe <sumudu...@gmail.com>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.hispviet...@gmail.com>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.hispviet...@gmail.com >>> >>> >>> On Tue, Feb 25, 2014 at 3:07 PM, sumudu weerasinghe <sumudu...@gmail.com >>> > 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@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp