Reporting Rates Completeness Schedule

Hello DHIS2 Devs

We are using 2.14 and Postgres. I rooted around in the manual for 2.14 but could not find a section that references how quickly a ‘complete’ report will show up as complete in a pivot table of reporting rates.

image

We completed a dataset for ‘Monthly Aid Post Form’ in April 2014 for Tanbok Aidpost:

image

but it has yet to show up as complete in the following table:

How long does it usually take to see a completed report show up, and is there a way to speed up the process? Or should it be instant and we’ve got a different kind of problem here?

Lastly: Where is the ‘complete’ bit stored in the database?, is it in the ‘completeness_yyyy’ tables?

image

or elsewhere?

Thanks!

Timothy Harding
PeaceCorps Volunteer

Republic of Vanuatu

hardingt@gmail.com

+678 5955137

Hello,

image

image

image

···

Did you try to run the analytics in Apps- Reports- Analytics and data mart?

Best,

G.

De : Dhis2-devs [mailto:dhis2-devs-bounces+gseide=futuresgroup.com@lists.launchpad.net] De la part de Timothy Harding

Envoyé : Wednesday, October 1, 2014 8:27 PM

À : DHIS 2 Developers list

Cc : Michael Buttsworth

Objet : [Dhis2-devs] Reporting Rates Completeness Schedule

Hello DHIS2 Devs

We are using 2.14 and Postgres. I rooted around in the manual for 2.14 but could not find a section that references how quickly a ‘complete’ report will show up as complete in a pivot table of reporting rates.

We completed a dataset for ‘Monthly Aid Post Form’ in April 2014 for Tanbok Aidpost:

but it has yet to show up as complete in the following table:

How long does it usually take to see a completed report show up, and is there a way to speed up the process? Or should it be instant and we’ve got a different kind of problem here?

Lastly: Where is the ‘complete’ bit stored in the database?, is it in the ‘completeness_yyyy’ tables?

or elsewhere?

Thanks!

Timothy Harding

PeaceCorps Volunteer

Republic of Vanuatu

hardingt@gmail.com

+678 5955137

Thank you for the response Germine,

I had not, but I just did, and here is what I got back:

2014-10-02 02:03:50
Analytics tables updated
2014-10-02 02:03:50
Table not valid, aborted update
2014-10-02 02:03:50
Updating event analytics tables
2014-10-02 02:03:50
Table update done
2014-10-02 02:03:50
Swapping analytics tables
2014-10-02 02:03:50
Vacuuming tables
2014-10-02 02:03:50
Creating indexes
2014-10-02 02:03:50
Applying aggregation levels
2014-10-02 02:03:50
Pruned analytics tables
2014-10-02 02:03:50
Populating analytics tables
2014-10-02 02:03:50
Creating analytics tables
2014-10-02 02:03:50
**Updating compeleteness target table **
2014-10-02 02:03:50
Table update done
2014-10-02 02:03:50
Swapping analytics tables
2014-10-02 02:03:50
Vacuuming tables
2014-10-02 02:03:47
Creating indexes
2014-10-02 02:03:47
Applying aggregation levels
2014-10-02 02:03:47
Pruned analytics tables
2014-10-02 02:03:47
Populating analytics tables
2014-10-02 02:03:47
Creating analytics tables
2014-10-02 02:03:47
**Updating completeness tables **
2014-10-02 02:03:47
Table update done
2014-10-02 02:03:11
Swapping analytics tables
2014-10-02 02:03:11
Vacuuming tables
2014-10-02 02:01:24
Creating indexes
2014-10-02 02:01:24
Applying aggregation levels
2014-10-02 02:01:24
Pruned analytics tables
2014-10-02 02:01:12
Populating analytics tables
2014-10-02 02:01:12
Creating analytics tables
2014-10-02 02:01:11
Updating analytics tables
2014-10-02 02:01:06
Updating resource tables

I highlighted the completeness table rows above. While I was hopeful that this was my smoking gun, alas, I still do not have a ‘100’ for that aidpost in April in the report rates pivot table.

I also highlighted a row (near the top) that says there is an error. I don’t have access to our production environment’s console, but I ran the same process in our test server (with a few day old dump of the production data) and it came back much the same way, here is what the console had to say:

  • INFO 2014-10-02 12:59:28,791 [Level: INFO, category: DATAMART, time: Thu Oct 02 12:59:28 SBT 2014, message: Table not

valid, aborted update] (InMemoryNotifier.java [taskScheduler-1])

  • INFO 2014-10-02 12:59:28,791 [Level: INFO, category: DATAMART, time: Thu Oct 02 12:59:28 SBT 2014, message: Analytics

tables updated] (InMemoryNotifier.java [taskScheduler-1])

I’m not sure if it was an erroneous skip of an invalid table, or if that stopped the entire update. In any case, the test environment has the same exact behavior, it also did not register any change in the completed reports, so the issue still stands.

image

image

image

···

Timothy Harding
PeaceCorps Volunteer

Republic of Vanuatu

hardingt@gmail.com

+678 5955137

On Thu, Oct 2, 2014 at 12:28 PM, Seide, Germine GSeide@futuresgroup.com wrote:

Hello,

Did you try to run the analytics in Apps- Reports- Analytics and data mart?

Best,

G.

De : Dhis2-devs [mailto:dhis2-devs-bounces+gseide=futuresgroup.com@lists.launchpad.net] De la part de Timothy Harding

Envoyé : Wednesday, October 1, 2014 8:27 PM

À : DHIS 2 Developers list

Cc : Michael Buttsworth

Objet : [Dhis2-devs] Reporting Rates Completeness Schedule

Hello DHIS2 Devs

We are using 2.14 and Postgres. I rooted around in the manual for 2.14 but could not find a section that references how quickly a ‘complete’ report will show up as complete in a pivot table of reporting rates.

We completed a dataset for ‘Monthly Aid Post Form’ in April 2014 for Tanbok Aidpost:

but it has yet to show up as complete in the following table:

How long does it usually take to see a completed report show up, and is there a way to speed up the process? Or should it be instant and we’ve got a different kind of problem here?

Lastly: Where is the ‘complete’ bit stored in the database?, is it in the ‘completeness_yyyy’ tables?

or elsewhere?

Thanks!

Timothy Harding

PeaceCorps Volunteer

Republic of Vanuatu

hardingt@gmail.com

+678 5955137