Thanks Hannan, Yes it is working😇 , thanks lot. It was a big headache during last one month for us.
It generate analytic tables and gives reports in event reports. Regards Sumudu Weerasinghe TH Ragama Sri Lanka On Thu, Nov 12, 2015 at 12:17 PM, Hannan Khan <[email protected]> wrote: > 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
