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-us...@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-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.hedb...@gmail.com Skype: calle_hedberg *******************************************
_______________________________________________ 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
