Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
Hi Fatema I will try and have another look at this. -- Morten On Wed, Jun 17, 2015 at 4:45 PM, Uddin Fatema fatema...@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 morte...@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. -- Morten On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad ol...@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 atumwesi...@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 On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@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 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
Thank you Morten, I am eagerly waiting for it. On Thu, Jun 18, 2015 at 7:41 AM, Morten Olav Hansen morte...@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 fatema...@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 morte...@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. -- Morten On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad ol...@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 atumwesi...@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 On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@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 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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;
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
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 morte...@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. -- Morten On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad ol...@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 atumwesi...@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 On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@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 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
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 atumwesi...@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 On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@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 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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? On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatema...@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:
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
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. -- Morten On Mon, Mar 23, 2015 at 3:05 PM, Ola Hodne Titlestad ol...@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 atumwesi...@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 On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@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 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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? On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20,
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
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 On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@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 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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? On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatema...@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
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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? On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatema...@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 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f ___ 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
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
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 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@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 On 20 March 2015 at 14:15, Uddin Fatema fatema...@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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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? On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatema...@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 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help :
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
Fatema, It seems like you have a duplicate period in the period table, as Alex says - which actually should not be possible because there is supposed to be a constraint on the period table that ensures unique periods (periodtype+startdate+enddate must be unique). If you have access to the PostgreSQL instance - either directly or via pgremote - then verify that there are THREE constraints on the period table. If one is missing, you can pick the SQL code to re-create it from another instance (e.g. the demo if you have it installed on your localhost). If that fails, you must first identify and manually remove one of the duplicates. A second possibility is that Alex is suggesting - that you have e.g. a daily period (which means that startdate=enddate) where the periodtype erroneously have been specified as something else. Regards Calle On 20 March 2015 at 13:22, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatema...@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 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f ___ 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 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@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.hedb...@gmail.com Skype: calle_hedberg *** ___ 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
Re: [Dhis2-users] [Dhis2-devs] dhis2 2, 18 resource table generate Bugs
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. On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg calle.hedb...@gmail.com wrote: Fatema, note that 2009-12-31 looks like an ENDdate, not a startdate. Regards Calle On 20 March 2015 at 14:09, Uddin Fatema fatema...@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? On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye atumwesi...@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 On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatema...@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 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f ___ 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 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- *** Calle Hedberg 46D