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