dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #38213
Re: [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
Dear Lars,
Here I attached the Error Log file
Thanks in advance
On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema <fatemacse@xxxxxxxxx> 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 <larshelge@xxxxxxxxx>
> 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 <fatemacse@xxxxxxxxx>
>> 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.mifthah@xxxxxxxxx>
>>> 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.mifthah@xxxxxxxxx | nayeem@xxxxxxxxxxxxxxx
>>>> Cell:+8801914030574
>>>>
>>>> On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland <
>>>> larshelge@xxxxxxxxx> 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 <fatemacse@xxxxxxxxx>
>>>>> 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 <fatemacse@xxxxxxxxx>
>>>>>> 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.overland@xxxxxxxxx>
>>>>>>
>>>>>>
>>>>>> 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-users@xxxxxxxxxxxxxxxxxxx
>>>>> 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
Follow ups
References
-
dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
From: Uddin Fatema, 2015-06-17
-
Re: dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
From: Lars Helge Øverland, 2015-06-17
-
Re: [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
From: Nayeem Al Mifthah, 2015-06-17
-
Re: [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
From: Uddin Fatema, 2015-06-17
-
Re: [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
From: Lars Helge Øverland, 2015-06-22
-
Re: [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.
From: Uddin Fatema, 2015-06-23