dhis2-devs team mailing list archive

[Timothy Harding <hardingt@xxxxxxxxx>]

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

[image: Inline image 1]

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@xxxxxxxxx
+678 5955137

On Thu, Oct 2, 2014 at 12:28 PM, Seide, Germine <GSeide@xxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx] *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.
>
>
>
> [image: Inline image 1]
>
>
>
> We completed a dataset for 'Monthly Aid Post Form' in April 2014 for
> Tanbok Aidpost:
>
>
>
> [image: Inline image 4]
>
>
>
>  but it has yet to show up as complete in the following table:
>
>
>
> [image: Inline image 2]
>
>
>
> 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: Inline image 3]
>
> or elsewhere?
>
>
>
> Thanks!
>
>
>
>
>   Timothy Harding
>
> PeaceCorps Volunteer
>
> Republic of Vanuatu
>
> hardingt@xxxxxxxxx
>
> +678 5955137
>