Resource table generation error

Dear all,

We use dhis 2.19 , tracker for Nutrition registry.

I had problem with resource table generation. error came as follows,
image

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,

image

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

image

image

···

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.

image

image

···

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

image

image

···

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

http://www.dhis2.org

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

image

image

···

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

http://www.dhis2.org

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?

image

image

···

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

http://www.dhis2.org

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

image

image

···

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

http://www.dhis2.org

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

image

image

···

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

http://www.dhis2.org

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