Dear Lars, Here I attached the Error Log file
Thanks in advance On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema <fatema...@gmail.com> wrote: > Dear Lars, > > Thanks a lot > > I just download 2.18 branch code and build the war file. Now i am running > my database with this war file with UTC +6 Dhaka time zone but still shows > same error. > > Is it cash problem or anything else. > > On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland <larshe...@gmail.com> > wrote: > >> Hi Fatema, >> >> we have made a fix to prevent time zone issues for resource table >> generation in 2.18 and 2.19 now. >> >> regards, >> >> Lars >> >> >> On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema <fatema...@gmail.com> >> wrote: >> >>> Yes Lars i found same error in 2.18 too. >>> >>> Actually I updated version in 2.18 in test server but still time zone >>> error remains for (UTC+60 )Dhaka . You know that some time zone has time >>> zone problem in resource table generation. So I Changes time zone UTC+6:30) >>> Yaangoon) and update resource table and analytic. >>> >>> And still I found same error which is described me and Nayeem Al Miftah. >>> >>> Thanks >>> >>> On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah <n.mift...@gmail.com> >>> wrote: >>> >>>> Dear Lars >>>> There are monthly datasets on which a data entry operator input 50 in a >>>> cell. Analytic shows that same number as 51.7 in those months which have 31 >>>> days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in >>>> February as it have 28 days. >>>> >>>> It has happened as the analytic table calculate the data as Ms. Fatema >>>> has described. >>>> >>>> >>>> >>>> Nayeem Al Mifthah >>>> HMIS Consultant >>>> Management Information System >>>> Directorate General of Health Services (DGHS), Bangladesh >>>> Supported by: UNICEF-Bangladesh >>>> Email: n.mift...@gmail.com | nay...@mis.dghs.gov.bd >>>> Cell:+8801914030574 >>>> >>>> On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland < >>>> larshe...@gmail.com> wrote: >>>> >>>>> Hi Fatema, >>>>> >>>>> do you think you could explain a bit more about the data elements and >>>>> calculation? >>>>> >>>>> Do you think you cold try with 2.18 / 2.19 ? >>>>> >>>>> regards, >>>>> >>>>> Lars >>>>> >>>>> >>>>> >>>>> On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema <fatema...@gmail.com> >>>>> wrote: >>>>> >>>>>> Dear All, >>>>>> >>>>>> Data Analytic table retrieve wrong data in Pivot table, data >>>>>> visualizer and GIS and same error remain 2.17 and 2.16 too >>>>>> >>>>>> Here i attach screen short of Pivote Table Analysis and Data Entry >>>>>> Screen >>>>>> >>>>>> >>>>>> In pivote table value shows = 51.7 >>>>>> >>>>>> but originally dataentry screen shows = 50 >>>>>> >>>>>> Calculation >>>>>> it is dividing daysxvalue / 30 = 50* 31/30 = 51.7 >>>>>> But it should do daysxvalue/daysno = 50*31/31 =50 >>>>>> >>>>>> >>>>>> Please have a look on it. >>>>>> >>>>>> >>>>>> Thanks >>>>>> >>>>>> >>>>>> Fatema >>>>>> ------- Forwarded message ---------- >>>>>> rom: Uddin Fatema <fatema...@gmail.com> >>>>>> Date: Tue, May 5, 2015 at 5:56 PM >>>>>> Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot >>>>>> table, data visualizer and GIS. >>>>>> To: Jan Henrik Øverland <janhenrik.overl...@gmail.com> >>>>>> >>>>>> >>>>>> Dear Jan, >>>>>> >>>>>> DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping >>>>>> retrieve wrong data from Analytics_2015 or all analytics table. >>>>>> >>>>>> The problem is in analytics table it store daysxvalue , daysno and >>>>>> value >>>>>> column but when it retrieve data for pivote table, data-visualizer >>>>>> and gis that time it is dividing daysxvalue / 30 >>>>>> But it should do daysxvalue/daysno >>>>>> >>>>>> As a result in pivot table, data visualizer and gis mapping shows >>>>>> wrong data. >>>>>> >>>>>> Could you please solved it additionally, can you please tell me in >>>>>> source code in which file i have to change. >>>>>> >>>>>> Thanks a lot in advance. >>>>>> >>>>>> Regards, >>>>>> *Fatema Uddin* >>>>>> >>>>>> Technical Advisor (HIS)-Support to the Health Sector Program II >>>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH >>>>>> German House >>>>>> House 10/A-2, Road 90 >>>>>> Gulshan 2, Dhaka 1212, Bangladesh >>>>>> >>>>>> T +880 9666701000 >>>>>> F +880 28823099 >>>>>> M +880 19 6206 4721 >>>>>> I www.giz.de >>>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> *Fatema Uddin* >>>>>> >>>>>> Technical Advisor (HIS)-Support to the Health Sector Program II >>>>>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH >>>>>> German House >>>>>> House 10/A-2, Road 90 >>>>>> Gulshan 2, Dhaka 1212, Bangladesh >>>>>> >>>>>> T +880 9666701000 >>>>>> F +880 28823099 >>>>>> M +880 19 6206 4721 >>>>>> I www.giz.de >>>>>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Lars Helge Øverland >>>>> Lead developer, DHIS 2 >>>>> University of Oslo >>>>> Skype: larshelgeoverland >>>>> http://www.dhis2.org <https://www.dhis2.org> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>> Post to : dhis2-us...@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>> >>> >>> -- >>> Regards, >>> *Fatema Uddin* >>> >>> Technical Advisor (HIS)-Support to the Health Sector Program II >>> Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH >>> German House >>> House 10/A-2, Road 90 >>> Gulshan 2, Dhaka 1212, Bangladesh >>> >>> T +880 9666701000 >>> F +880 28823099 >>> M +880 19 6206 4721 >>> I www.giz.de >>> <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f> >>> >>> >> >> >> -- >> Lars Helge Øverland >> Lead developer, DHIS 2 >> University of Oslo >> Skype: larshelgeoverland >> http://www.dhis2.org <https://www.dhis2.org> >> >> > > > -- > Regards, > *Fatema Uddin* > > Technical Advisor (HIS)-Support to the Health Sector Program II > Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH > German House > House 10/A-2, Road 90 > Gulshan 2, Dhaka 1212, Bangladesh > > T +880 9666701000 > F +880 28823099 > M +880 19 6206 4721 > I www.giz.de > <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f> > > -- Regards, *Fatema Uddin* Technical Advisor (HIS)-Support to the Health Sector Program II Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH German House House 10/A-2, Road 90 Gulshan 2, Dhaka 1212, Bangladesh T +880 9666701000 F +880 28823099 M +880 19 6206 4721 I www.giz.de <https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.&URL=http%3a%2f%2fwww.giz.de%2f>
* INFO 2015-06-23 17:26:57,701 Login success for user: 'admin', ip: '127.0.0.1' (DefaultUserAuditService.java [http-apr-8085-exec-10]) * INFO 2015-06-23 17:27:01,196 Information schema analytics SQL: select table_n ame from information_schema.tables where table_name like 'analytics%' and table_ type = 'BASE TABLE' (JdbcPartitionManager.java [http-apr-8085-exec-7]) * INFO 2015-06-23 17:30:23,518 [Level: INFO, category: DATAMART, time: Tue Jun 23 17:30:23 BDT 2015, message: Analytics table update process started] (InMemory Notifier.java [taskScheduler-1]) * INFO 2015-06-23 17:30:23,519 [Level: INFO, category: DATAMART, time: Tue Jun 23 17:30:23 BDT 2015, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-1]) * INFO 2015-06-23 17:30:23,534 Using 6 organisation unit levels for org unit st ructure table (DefaultResourceTableService.java [taskScheduler-1]) * INFO 2015-06-23 17:30:23,534 Create organisation unit structure table SQL: CR EATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1 " CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEG ER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" CHARACTER(11), "i dlevel5" INTEGER, "uidlevel5" CHARACTER(11), "idlevel6" INTEGER, "uidlevel6" CHA RACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2015-06-23 17:31:06,513 Organisation unit structure table generated (Def aultResourceTableService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:06,711 Create category option combo name table SQL: CRE ATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIM ARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcReso urceTableStore.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,516 Category option combo name table generated (Defa ultResourceTableService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,576 Create category option group set table SQL: CREA TE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NU LL, PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryOptionGroupSetTableSt atement.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,632 Category option group set table generated (Defau ltResourceTableService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,639 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelemen tname VARCHAR (250), "EPI Program" VARCHAR (250), "fqBqT0HAoi0" CHARACTER(11), " HIV AIDS Program" VARCHAR (250), "Y3oMQmo1eaG" CHARACTER(11), PRIMARY KEY ( data elementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,639 Populate data element group set structure SQL: i nsert into _dataelementgroupsetstructure select d.dataelementid as dataelementid , d.name as dataelementname, (select deg.name from dataelementgroup deg inner jo in dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgrou pid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = de gm.dataelementgroupid and degsm.dataelementgroupsetid = 51086 where degm.dataele mentid = d.dataelementid limit 1) as "EPI Program", (select deg.uid from dataele mentgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid inner join dataelementgroupsetmembers degsm on degsm.d ataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 51 086 where degm.dataelementid = d.dataelementid limit 1) as "fqBqT0HAoi0", (selec t deg.name from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid inner join dataelementgroupsetm embers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dat aelementgroupsetid = 50188 where degm.dataelementid = d.dataelementid limit 1) a s "HIV AIDS Program", (select deg.uid from dataelementgroup deg inner join datae lementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid inne r join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.datae lementgroupid and degsm.dataelementgroupsetid = 50188 where degm.dataelementid = d.dataelementid limit 1) as "Y3oMQmo1eaG" from dataelement d (JdbcResourceTable Store.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,917 Data element group set table generated (DefaultR esourceTableService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,946 Create indicator group set table SQL: CREATE TAB LE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VAR CHAR (250), "Facility Based Indicator Group" VARCHAR (250), "KIhvYzjKOr0" CHARAC TER(11), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.ja va [taskScheduler-1]) * INFO 2015-06-23 17:31:12,954 Populate indicator group set structure SQL: inse rt into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name as indicatorname, (select ig.name from indicatorgroup ig inner join indicatorgro upmembers igm on igm.indicatorgroupid = ig.indicatorgroupid inner join indicator groupsetmembers igsm on igsm.indicatorgroupid = igm.indicatorgroupid and igsm.in dicatorgroupsetid = 1 where igm.indicatorid = i.indicatorid limit 1) as "Facilit y Based Indicator Group", (select ig.uid from indicatorgroup ig inner join indic atorgroupmembers igm on igm.indicatorgroupid = ig.indicatorgroupid inner join in dicatorgroupsetmembers igsm on igsm.indicatorgroupid = igm.indicatorgroupid and igsm.indicatorgroupsetid = 1 where igm.indicatorid = i.indicatorid limit 1) as " KIhvYzjKOr0" from indicator i (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,967 Indicator group set table generated (DefaultReso urceTableService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,982 Create organisation unit group set table SQL: CR EATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT N ULL, organisationunitname VARCHAR (250), "Administrative unit" VARCHAR (250), "S KATQ8yboF7" CHARACTER(11), "Govt. organization type" VARCHAR (250), "WwnvrXqGyQl " CHARACTER(11), "Ownership" VARCHAR (250), "ns6fqlm8lqM" CHARACTER(11), "Progra ms" VARCHAR (250), "h178IEscavG" CHARACTER(11), "Type" VARCHAR (250), "le7YcfUsd 1c" CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitG roupSetTableStatement.java [taskScheduler-1]) * INFO 2015-06-23 17:31:12,982 Populate organisation unit group set structure S QL: insert into _organisationunitgroupsetstructure select ou.organisationunitid as organisationunitid, ou.name as organisationunitname, (select oug.name from or gunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgroupid = oug. orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 541127 where ougm.organisatio nunitid = ou.organisationunitid limit 1) as "Administrative unit", (select oug.u id from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgrou pid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orguni tgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 541127 where ougm.o rganisationunitid = ou.organisationunitid limit 1) as "SKATQ8yboF7", (select oug .name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitg roupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.org unitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 1 where ougm.org anisationunitid = ou.organisationunitid limit 1) as "Govt. organization type", ( select oug.uid from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm .orgunitgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 1 where ougm.organisationunitid = ou.organisationunitid limit 1) as "WwnvrXqGyQl", (sel ect oug.name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.o rgunitgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ou gsm.orgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 2 where o ugm.organisationunitid = ou.organisationunitid limit 1) as "Ownership", (select oug.uid from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orguni tgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.o rgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 2 where ougm.o rganisationunitid = ou.organisationunitid limit 1) as "ns6fqlm8lqM", (select oug .name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitg roupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.org unitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 719485 where oug m.organisationunitid = ou.organisationunitid limit 1) as "Programs", (select oug .uid from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgr oupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orgu nitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 719485 where ougm .organisationunitid = ou.organisationunitid limit 1) as "h178IEscavG", (select o ug.name from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orguni tgroupid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.o rgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 720968 where o ugm.organisationunitid = ou.organisationunitid limit 1) as "Type", (select oug.u id from orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgrou pid = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on ougsm.orguni tgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 720968 where ougm.o rganisationunitid = ou.organisationunitid limit 1) as "le7YcfUsd1c" from organis ationunit ou (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2015-06-23 17:31:17,851 Organisation unit group set table generated (Def aultResourceTableService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:17,871 Create category structure table SQL: CREATE TABL E _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncom boname VARCHAR (250), "Sex" VARCHAR (250), "mc2ceK4TjB6" CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskSchedule r-1]) * INFO 2015-06-23 17:31:17,879 Populate category structure SQL: insert into _ca tegorystructure select coc.categoryoptioncomboid as cocid, con.categoryoptioncom boname as cocname, (select co.name from categoryoptioncombos_categoryoptions coc co inner join dataelementcategoryoption co on cocco.categoryoptionid = co.catego ryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cc o.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 2 limit 1) as "Sex", (select co.uid from categoryoptioncom bos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categ oryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on c o.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocc o.categoryoptioncomboid and cco.categoryid = 2 limit 1) as "mc2ceK4TjB6" from ca tegoryoptioncombo coc inner join _categoryoptioncomboname con on coc.categoryopt ioncomboid = con.categoryoptioncomboid (JdbcResourceTableStore.java [taskSchedul er-1]) * INFO 2015-06-23 17:31:17,938 Category table generated (DefaultResourceTableSe rvice.java [taskScheduler-1]) * INFO 2015-06-23 17:31:30,393 Create data element structure SQL: CREATE TABLE _dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementu id CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CH ARACTER(11), datasetname VARCHAR(250), datasetapprovallevel INTEGER, periodtypei d INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskSched uler-1]) * INFO 2015-06-23 17:31:52,892 Data element table generated (DefaultResourceTab leService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:52,987 Create period structure SQL: CREATE TABLE _perio dstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, day sno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCH AR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(1 5), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHA R(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTab leStore.java [taskScheduler-1]) * INFO 2015-06-23 17:31:54,115 Date period table generated (DefaultResourceTabl eService.java [taskScheduler-1]) * INFO 2015-06-23 17:31:54,131 Create date period structure SQL: CREATE TABLE _ dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly " VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financ ialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2015-06-23 17:31:58,060 [Level: ERROR, category: DATAMART, time: Tue Jun 23 17:31:58 BDT 2015, message: Process failed: PreparedStatementCallback; SQL [ insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: dupli cate key value violates unique constraint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception is org .postgresql.util.PSQLException: ERROR: duplicate key value violates unique const raint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists.] (InMemoryNotifier.java [taskScheduler-1]) * ERROR 2015-06-23 17:31:58,140 Unexpected error occurred in scheduled task. (Ta skUtils.java [taskScheduler-1]) org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [i nsert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplic ate key value violates unique constraint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception is org .postgresql.util.PSQLException: ERROR: duplicate key value violates unique const raint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d oTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat or.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java: 660) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java: 673) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j ava:989) at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(Bat chUpdateUtils.java:32) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j ava:1039) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j ava:1034) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(J dbcResourceTableStore.java:102) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDateP eriodTable(DefaultResourceTableService.java:450) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti on(AopUtils.java:317) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami cAopProxy.java:201) at com.sun.proxy.$Proxy100.generateDatePeriodTable(Unknown Source) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.generateRe sourceTables(DefaultAnalyticsTableService.java:184) at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTa bleTask.java:131) at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl e.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violate s unique constraint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx ecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor Impl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl. java:1130) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:396) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc 2Statement.java:2892) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr oxyPreparedStatement.java:1723) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd bcTemplate.java:1005) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd bcTemplate.java:989) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java: 644) ... 25 more
* INFO 2015-06-24 12:40:41,671 Date period table generated (DefaultResourceTabl eService.java [taskScheduler-1]) * INFO 2015-06-24 12:40:42,234 Create date period structure SQL: CREATE TABLE _ dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly " VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financ ialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2015-06-24 12:40:47,462 [Level: ERROR, category: RESOURCETABLE_UPDATE, t ime: Wed Jun 24 12:40:47 BDT 2015, message: Process failed: PreparedStatementCal lback; SQL [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate key value violates unique constraint "_dateperiodstructure_pkey " Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception is org .postgresql.util.PSQLException: ERROR: duplicate key value violates unique const raint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists.] (InMemoryNotifier.java [taskScheduler-1]) * ERROR 2015-06-24 12:40:47,934 Unexpected error occurred in scheduled task. (Ta skUtils.java [taskScheduler-1]) org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [i nsert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplic ate key value violates unique constraint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists.; nested exception is org .postgresql.util.PSQLException: ERROR: duplicate key value violates unique const raint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d oTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat or.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java: 660) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java: 673) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j ava:989) at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(Bat chUpdateUtils.java:32) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j ava:1039) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j ava:1034) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(J dbcResourceTableStore.java:102) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDateP eriodTable(DefaultResourceTableService.java:450) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti on(AopUtils.java:317) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami cAopProxy.java:201) at com.sun.proxy.$Proxy100.generateDatePeriodTable(Unknown Source) at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll( ResourceTableTask.java:123) at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(Resource TableTask.java:85) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl e.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violate s unique constraint "_dateperiodstructure_pkey" Detail: Key (dateperiod)=(2009-12-31) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx ecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor Impl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl. java:1130) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:396) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc 2Statement.java:2892) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr oxyPreparedStatement.java:1723) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd bcTemplate.java:1005) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd bcTemplate.java:989) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java: 644) ... 24 more
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp