Dear Sumudu Did you check the period table for duplicate period? If you removed all duplicates and still the problem persists, then can try this:
Take a backup of your database. Manually delete _periodstructure table. Generate resource table again. Hopefully your problem will be resolved. Regards Hannan Khan HISP Bangladesh On Thu, Nov 5, 2015 at 10:12 AM, sumudu weerasinghe <[email protected]> wrote: > Hi Lars, > > I upgraded it to 2.20 but it gives same error, unable to generate > resource tables. > e > Do i need to delete period 2015.01 from table contents? > > > On Thu, Nov 5, 2015 at 6:59 AM, sumudu weerasinghe <[email protected]> > wrote: > >> Thanks Lars, >> I will try to upgrade it today . >> >> - Do i need to do the changes on "period" table before upgrade or >> just upgrade my database according to upgrade note ? >> - Actually i want to upgrade up to 2.21 , is there issue in upgrade >> in to 2.21 >> >> regards >> Sumudu >> >> On Thu, Nov 5, 2015 at 1:38 AM, Lars Helge Øverland <[email protected]> >> wrote: >> >>> Hi Sumudu, >>> >>> this weakness was fixed in version 2.20 and later. Are you able to >>> upgrade your instance? >>> >>> regards, >>> >>> Lars >>> >>> >>> On Thu, Oct 29, 2015 at 3:15 AM, sumudu weerasinghe <[email protected] >>> > wrote: >>> >>>> Yes Morten, >>>> >>>> I tried it before and after deletion of period but still not work and >>>> giving same error. >>>> as in second error massage. >>>> >>>> >>>> >>>> >>>> On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen <[email protected] >>>> > wrote: >>>> >>>>> Hi >>>>> >>>>> Did you try and prune your periods? it should be under data admin -> >>>>> maintainence >>>>> >>>>> -- >>>>> Morten >>>>> >>>>> On Thu, Oct 29, 2015 at 10:50 AM, sumudu weerasinghe < >>>>> [email protected]> wrote: >>>>> >>>>>> Dear all, >>>>>> >>>>>> >>>>>> We use dhis 2.19 , tracker for Nutrition registry. >>>>>> I had problem with resource table generation. error came as follows, >>>>>> >>>>>> >>>>>> then according to previous discussion i delete the duplicate 01.2015 >>>>>> value from period table and their fk constrain from eventchart_ periods >>>>>> table. >>>>>> >>>>>> Following above changes i got second error massage as follows, >>>>>> >>>>>> >>>>>> >>>>>> Can any one help on this matter? >>>>>> >>>>>> >>>>>> Best Regards, >>>>>> >>>>>> Sumudu Weerasinghe >>>>>> Teaching hospital Ragama, >>>>>> Sri Lanka >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>> Post to : [email protected] >>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : [email protected] >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> >>> -- >>> Lars Helge Øverland >>> Lead developer, DHIS 2 >>> University of Oslo >>> Skype: larshelgeoverland >>> http://www.dhis2.org <https://www.dhis2.org> >>> >>> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
