| Thread Previous • Date Previous • Date Next • Thread Next |
Hi Lars, I have download the war file of 2.14 and used it . For one orgunit and one aggregated quarry it work well data set report came . But when I register a person to other orgunit and for same quarry data set report didnt appear . I have found this error in Catalina.out file ERROR 2014-03-11 12:38:34,527 Error while executing action (ExceptionInterceptor.java [http-bio-8080-exec-12]) org.springframework.dao.DuplicateKeyException: StatementCallback; SQL [INSERT INTO datavalue (dataelementid, categoryoptioncomboid, attributeoptioncomboid, sourceid, periodid, comment, value) SELECT '19' as dataelementid, '1' as categoryoptioncomboid, '1' as attributeoptioncomboid, ou.organisationunitid as sourceid, '3' as periodid,'DHIS-SYSTEM' as comment, count(distinct(pi.patientid)) as value 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 * FROM patientattributevalue _pav WHERE _pav.patientid=pi.patientid AND _pav.patientattributeid=2 AND _pav.value ='Female' ) GROUP BY ou.organisationunitid, ou.name]; Duplicate entry '19-3-12-1-1' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '19-3-12-1-1' for key 'PRIMARY' Regards Gayan On Tue, Mar 11, 2014 at 9:32 AM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>wrote: > Hi Lars, > > What is the revision ? is it R13807 ? > I have down load it from this http://www.dhis2.org/downloads. > > > > > > On Tue, Mar 11, 2014 at 3:27 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote: > >> Hi Gayan, >> >> this issue should have been fixed today in 2.14. Download again from >> dhis2.org. >> >> regards, >> >> Lars >> On Mar 10, 2014 9:51 AM, "Gayan Yasantha" <gayanyp@xxxxxxxxx> wrote: >> >>> Hi tran >>> >>> I am using war file R12980. I have test Aggregate query builder test >>> button and it success quarry and no run fail massage then Manual person >>> aggregation also work well and show that data is pass to aggregate data >>> elements in preview menu. then i have save it into data base But that value >>> not shows in reports/ data entry form or mysql database data-value table. >>> >>> I have found the error massage it says Data Integrity Violation >>> Exception in Catalina.out file . >>> >>> i.e. >>> >>> ... 121 more >>> * INFO 2014-03-10 13:10:54,939 'admin' update >>> org.hisp.dhis.caseaggregation.CaseAggregationCondition, name: Multi- >>> bacillary, uid: D7TMQF7l6o1 (AuditLogUtil.java [http-bio-8080-exec-8]) >>> * ERROR 2014-03-10 13:12:22,494 Error while executing action >>> (ExceptionInterceptor.java [http-bio-8080-exec-3]) >>> org.springframework.dao.DataIntegrityViolationException: >>> StatementCallback; SQL [*INSERT INTO datavalue (dataelementid, >>> categoryoptioncomboid, sourceid, periodid, comment, value)SELECT '21' as >>> dataelementid, '1' as categoryoptioncomboid, ou.organisationunitid as >>> sourceid, '1' as periodid,'DHIS-SYSTEM' as comment, >>> COUNT(DISTINCT(pi.patientid)) as value FROM programinstance as pi INNER >>> JOIN patient p on p.patientid=pi.patientid INNER JOIN programstageinstance >>> psi ON pi.programinstanceid=psi.programinstanceid INNER JOIN >>> organisationunit ou ON ou.organisationunitid=psi.organisationunitid WHERE >>> EXISTS ( SELECT * FROM patientdatavalue _pdv inner join >>> programstageinstance _psi ON >>> _pdv.programstageinstanceid=_psi.programstageinstanceid JOIN >>> programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid WHERE >>> psi.programstageinstanceid=_pdv.programstageinstanceid AND >>> _pdv.dataelementid=1 AND _psi.organisationunitid in (12) AND >>> _pi.programid = 1 AND _psi.executionDate>='2014-03-01' AND >>> _psi.executionDate <= '2014-03-31' AND _psi.programstageid = 1 AND >>> _pdv.value ='MB-A' + 'MB-C' ) GROUP BY ou.organisationunitid, ou.name >>> <http://ou.name>*]; Data truncation: Truncated incorrect DOUBLE value: >>> 'MB-C'; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data >>> truncation: Truncated incorrect DOUBLE value: 'MB-C' >>> >>> Thank you >>> Gayan >>> >>> >>> >>> >>> On Sat, Mar 8, 2014 at 8:54 AM, Gayan Yasantha <gayanyp@xxxxxxxxx>wrote: >>> >>>> Hi >>>> Dear All >>>> I try with R12980 in 2.13 to aggregate patient base data. >>>> My agree gate data element is All female patient. My aggregated query >>>> is [CP:gender] ='F' is not null . But >>>> 1 I didn't get all the number of patient in manual person aggregation >>>> i enter (including male also ,in screen print) is my quarry wrong? >>>> 2 I didn't get any aggregated reports in data set report( IN screen >>>> print ) Why is this ? I have run the data mart and up dated the resource >>>> tables >>>> >>>> I have attached my Catalina.out file >>>> What is the wrong ? >>>> Best Regards >>>> >>>> Gayan Yasantha >>>> >>>> >>>> On Fri, Mar 7, 2014 at 11:54 AM, sumudu weerasinghe < >>>> sumuduw00@xxxxxxxxx> wrote: >>>> >>>>> 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 >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> 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 >>>>> >>>>> >>>> >>>> >>>> -- >>>> Gayan Yasantha Piyasena >>>> >>> >>> >>> >>> -- >>> Gayan Yasantha Piyasena >>> >>> _______________________________________________ >>> 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 >>> >>> > -- Gayan Yasantha Piyasena
Attachment:
catalina.out
Description: Binary data
Attachment:
Screenshot from 2014-03-11 12:40:17.png
Description: PNG image
| Thread Previous • Date Previous • Date Next • Thread Next |
