Thank you Morten, I am eagerly waiting for it.
···
On Thu, Jun 18, 2015 at 7:41 AM, Morten Olav Hansen mortenoh@gmail.com wrote:
Hi Fatema
I will try and have another look at this.
–
–
Morten
On Wed, Jun 17, 2015 at 4:45 PM, Uddin Fatema fatemacse@gmail.com wrote:
Dear Morten,
Time zone error still remains in 2.18 and 2.19 version. but working fine in 2.17 and bellow version
Time Zone
(UTC+06:00) Dhaka
(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
are giving same error.
(UTC+06:30) Yangon (Rangoon)…do not showing that error.
I change the time zone UTC+06.30 Yangon and update the resource table it was fine but inside period table a major change shows.
id Startdate Enddate
1283308;3;“2015-05-01”;“2015-05-31”
1283335;3;“2015-02-28”;“2015-03-30”
1283334;3;“2015-06-01”;“2015-06-30”
1283336;3;“2014-12-31”;“2015-01-30”
1283337;3;“2014-11-30”;“2014-12-30”
1283338;3;“2013-12-31”;“2014-01-30”
1283339;3;“2014-01-31”;“2014-02-27”
1283340;3;“2014-07-31”;“2014-08-30”
1283341;3;“2014-10-31”;“2014-11-29”
1283342;3;“2015-04-30”;“2015-05-30”
1283343;3;“2015-03-31”;“2015-04-29”
Please resolve the bug and help us.
Thanks in advance
On Mon, Mar 23, 2015 at 2:12 PM, Morten Olav Hansen mortenoh@gmail.com wrote:
Yes, this is a known bug. I’m still looking into it, it only happens with certain timezones, will let you know when it has been fixed.
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
–
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
–
Morten
On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi Fatema,
This is not a database issue, but a bug that occurs when generating the period structure table on machines/servers using on of a few specific time zones.
I think I commented on this issues on another email thread you started.
Morten knows the details, but my quick fix advice is to change the system time zone to a zone that we know works, e.g. GMT.
Ola
On 20 Mar 2015 14:16, “Alex Tumwesigye” atumwesigye@gmail.com wrote:
Dear Fatema,
All looks good and no duplicates.
The only odd stuff is this: Note the years (2063 and 2140)
“811017”,“1”,“2063-03-11”,“2063-03-11”
“811018”,“1”,“2063-03-12”,“2063-03-12”
“811019”,“1”,“2063-03-13”,“2063-03-13”
“811020”,“1”,“2063-03-14”,“2063-03-14”
“811021”,“1”,“2063-03-15”,“2063-03-15”
“811022”,“1”,“2063-03-16”,“2063-03-16”
“811023”,“1”,“2063-03-17”,“2063-03-17”
“811024”,“1”,“2063-03-18”,“2063-03-18”
“811025”,“1”,“2063-03-19”,“2063-03-19”
“811026”,“1”,“2063-03-20”,“2063-03-20”
“811027”,“1”,“2063-03-21”,“2063-03-21”
“811028”,“1”,“2063-03-22”,“2063-03-22”
“811029”,“1”,“2063-03-23”,“2063-03-23”
“811030”,“1”,“2063-03-24”,“2063-03-24”
“811031”,“1”,“2063-03-25”,“2063-03-25”
“1555”,“1”,“2140-09-03”,“2140-09-03”
“1554”,“1”,“2140-09-04”,“2140-09-04”
“1550”,“1”,“2140-09-05”,“2140-09-05”
“1551”,“1”,“2140-09-06”,“2140-09-06”
“1552”,“1”,“2140-09-07”,“2140-09-07”
“1553”,“1”,“2140-09-08”,“2140-09-08”
can you try this query on period table?
delete from period where enddate is null or startdate is null;
After running this query, go to resource table and regenerate them.
Thanks.
Alex
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
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
On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatemacse@gmail.com wrote:
Dear Alex,
I have run this query and get two result.
select enddate,startdate,periodtypeid from period where enddate = ‘2009-12-31’ or startdate = ‘2009-12-31’
Result is
“2009-12-31”;“2009-12-01”;3
“2009-12-31”;“2009-01-01”;6
here i attached the file too.
Thanks a lot
–
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don’t want to be anything other than what I have been - one tree hill "
On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:
Fatema,
Can you dump for me the enddate, startdate and periodtype from period table for that date ‘2009-12-31’
I need to see the output of "select enddate,startdate,periodtypeid from period where enddate like ‘2009-12-31’ or startdate like ‘2009-12-31’ "
Thanks.
Alex
–
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
On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedberg@gmail.com wrote:
Did you verify that all three constraints are in place on the period table?
If they are and you are 100% sure there are no duplicates, then I don’t know - I’ve had similar error messages a couple of times, but removing the duplicates and re-inserting the constraint have always sorted it out.
Clear cache (DHIS and browser), empty resource tables, re-start tomcat - I’m not aware of any other tricks…
Regards
Calle
–
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don’t want to be anything other than what I have been - one tree hill "
On 20 March 2015 at 14:15, Uddin Fatema fatemacse@gmail.com wrote:
Thanks Calle,
I have already checked all part and this period is daily, so startdate and enddate is same 2009-12-31
However, my problem is remains same
What can i do.
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedberg@gmail.com wrote:
Fatema,
note that 2009-12-31 looks like an ENDdate, not a startdate.
Regards
Calle
–
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
On 20 March 2015 at 14:09, Uddin Fatema fatemacse@gmail.com wrote:
Thanks Bharath Anna and Alex.
Actually i checked period table with this( 2009-12-31) startdate and there is no duplicate period with same startdate.
Additionally, for test purpose i deleted this period from period table and from other related table with this periodid.
Several time restart the tomcat and clear the cash.
Although, problem remain same.
"Process failed: PreparedStatementCallback; 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 constraint “_dateperiodstructure_pkey” Detail: Key (dateperiod)=(2009-12-31) already exists.
2015-03-20 12:03:45 Generating resource tables "
What can i do now?
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
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:
Dear Fatema,
If I remember correctly, this used to be an issue in 2.16. I guess, it has been carried to 2.18.
The problem was that, two similar dates were created and when you try to run the resource table, that range is already created.
Query the period table directly for this date “2009-12-31”, two duplicates may exist.Please try to attempt to compare ranges for different period types, this is where the problem is (You will encounter a range that is meant to be for a week, yet it is assigned to daily or monthly)
If so, you may need drop it manually for the resource tables to be generated.
Let me look for the script
Thanks.
Alex
–
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
On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatemacse@gmail.com wrote:
Dear All,
I have upgrade our application from 2.16 to 2.18.
However, when we generate Resource table,we have get error. the error short note given in bellow.
ERROR, category: RESOURCETABLE_UPDATE, t
ime: Fri Mar 20 16:52:29 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-03-20 16:52:29,445 Unexpected error occurred in scheduled task. (Ta
skUtils.java [taskScheduler-1])
Additionally, here i attached the bug file.
Could anyone please help us.
–
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
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
–
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don’t want to be anything other than what I have been - one tree hill "
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