[Dhis2-users] Datamart Problem

It was exactly that. Thank you very much.

Good to hear.

Here's a general question to developers : when resource tables are
missing sometimes odd things happen. The corrective action is always
the same - to generate the resource tables. Is there any sense in
automating this generation and, if so, what would be the sensible
trigger points:
1. on startup
2. as part of a scheduled task - eg right before or after datamart generation

···

On 27 June 2012 16:07, Kabango Malewezi <kmalewezi@jhpiego.net> wrote:

Kabango Malewezi | Database Specialist

SSDI Services

2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431

kmalewezi@jhpiego.net | www.jhpiego.org

Skype: kabango.malewezi | Twitter: kabangoM

________________________________________
From: Bob Jolliffe [bobjolliffe@gmail.com]
Sent: Wednesday, June 27, 2012 5:04 PM
To: Kabango Malewezi
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Datamart Problem

Hi Kabango

This is an odd error but I believe it is probably caused because you
are missing resource tables on the dhis server side. On dhis server
go to:

data administration -> resource tables -> select all -> generate tables

and try again.

Regards
Bob

On 27 June 2012 15:32, Kabango Malewezi <kmalewezi@jhpiego.net> wrote:

Dear Users

I'm new to DHIS and I have a problem.

After I run datamart, login, and download Metadata I cannot update Aggregate data. Enclosed is the log file.

Kabango Malewezi | Database Specialist

SSDI Services

2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431

kmalewezi@jhpiego.net <mailto:kmalewezi@jhpiego.net > | www.jhpiego.org<http://www.jhpiego.org/>

Skype: kabango.malewezi | Twitter: kabangoM

_______________________________________________
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

Hi Bob,

I agree this needs to be done, and has been discussed a number of
times. . There are numerous places in the system now where these
resource tables are required (data browser for instance). Trolling
back through the mailing list archives, one will see this issue coming
up a number of times, of various weird errors occuring because of the
lack of the tables. Not only do the resource tables need to be
present, but they need to be regenerated automatically, when certain
actions on the system occur, for instance, when a new orgunit is
added. When a new orgunit, data element, etc are added the tables are
out of sync with the rest of the metadata in the system. There is no
way to know that the system is "dirty" and that these resource tables
should be regenerated. So, we should have some mechanism of marking
these tables as dirty, and forcing a refresh each time (or at some
point maybe once an hour after they have been marked as dirty) such a
situation would occur. I am not opposed to automatic scheduling either
(probably each day before data mart) but I am not sure this would
really be good enough.

Regards,
Jason

···

On Wed, Jun 27, 2012 at 5:25 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

On 27 June 2012 16:07, Kabango Malewezi <kmalewezi@jhpiego.net> wrote:

It was exactly that. Thank you very much.

Good to hear.

Here's a general question to developers : when resource tables are
missing sometimes odd things happen. The corrective action is always
the same - to generate the resource tables. Is there any sense in
automating this generation and, if so, what would be the sensible
trigger points:
1. on startup
2. as part of a scheduled task - eg right before or after datamart generation

Kabango Malewezi | Database Specialist

SSDI Services

2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431

kmalewezi@jhpiego.net | www.jhpiego.org

Skype: kabango.malewezi | Twitter: kabangoM

________________________________________
From: Bob Jolliffe [bobjolliffe@gmail.com]
Sent: Wednesday, June 27, 2012 5:04 PM
To: Kabango Malewezi
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Datamart Problem

Hi Kabango

This is an odd error but I believe it is probably caused because you
are missing resource tables on the dhis server side. On dhis server
go to:

data administration -> resource tables -> select all -> generate tables

and try again.

Regards
Bob

On 27 June 2012 15:32, Kabango Malewezi <kmalewezi@jhpiego.net> wrote:

Dear Users

I'm new to DHIS and I have a problem.

After I run datamart, login, and download Metadata I cannot update Aggregate data. Enclosed is the log file.

Kabango Malewezi | Database Specialist

SSDI Services

2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88 4 245 431

kmalewezi@jhpiego.net <mailto:kmalewezi@jhpiego.net > | www.jhpiego.org<http://www.jhpiego.org/>

Skype: kabango.malewezi | Twitter: kabangoM

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help