← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Resource table generation error

 

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

PNG image

PNG image

PNG image


Follow ups

References