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