dhis2-users team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

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 <hannank@xxxxxxxxx> 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 <sumuduw00@xxxxxxxxx>
> 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 <sumuduw00@xxxxxxxxx>
>> 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 <larshelge@xxxxxxxxx
>>> > 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 <
>>>> sumuduw00@xxxxxxxxx> 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 <
>>>>> mortenoh@xxxxxxxxx> 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 <
>>>>>> sumuduw00@xxxxxxxxx> 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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>> 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     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>