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 : 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> >> >> > > > -- > > ******************************************* > > 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 > > ******************************************* > > -- 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp