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 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 > > ******************************************* > > -- 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
