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
Hi
Did you try and prune your periods? it should be under data admin → maintainence
On Thu, Oct 29, 2015 at 10:50 AM, sumudu weerasinghe sumuduw00@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Morten
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@gmail.com 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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@gmail.com 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.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen mortenoh@gmail.com 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@gmail.com 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@lists.launchpad.net
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
Thanks Lars,
I will try to upgrade it today .
Sumudu
On Thu, Nov 5, 2015 at 1:38 AM, Lars Helge Øverland larshelge@gmail.com 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@gmail.com 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.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
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
–
On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen mortenoh@gmail.com 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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@gmail.com 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@gmail.com 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@gmail.com 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.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
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
–
On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen mortenoh@gmail.com 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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@gmail.com 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?
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
On Thu, Nov 5, 2015 at 6:59 AM, sumudu weerasinghe sumuduw00@gmail.com 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@gmail.com 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@gmail.com 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.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
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
–
On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen mortenoh@gmail.com 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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@gmail.com 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@gmail.com 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?
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
On Thu, Nov 5, 2015 at 6:59 AM, sumudu weerasinghe sumuduw00@gmail.com 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@gmail.com 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@gmail.com 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.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
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
–
On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen mortenoh@gmail.com 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Dear Hannan,
I am facing the same problem and I am using version 2.3. I tried what you are mentioned but still not working could you please advise
Dear Hadeel
Sorry some how I missed your mail. Hopefully you resolved the problem. If not then please let me know in detail with log.
Regards
Hannan