dhis2-users team mailing list archive

["Laura E. Lincks" <laura.lincks@xxxxxxxxxxxxxxxxx>]

As a follow up, I notice that all the resource tables (preceded by an
underscore) and all analytics_ and analytics_completeness tables contain 0
columns. I recreated resource tables and reran Analytics, both without
error (from the front end). I'm very confused.

*Laura E. Lincks*
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132

On Tue, Aug 18, 2015 at 5:06 PM, Laura E. Lincks <
laura.lincks@xxxxxxxxxxxxxxxxx> wrote:

> DHIS2, version 2.18
>
> We have recently been experiencing a problem in getting data to appear in
> Pivot Tables and Data Set Reports.
>
> I can verify that data exists on the data entry screen. Furthermore, all
> users, user roles, data elements, categories, indicators, data sets and Org
> Units exist. However, after successfully running Analytics (no errors in
> the front end, at least) I cannot produce a Pivot Table with any results
> for a simple query I am certain should return results. Furthermore, I
> cannot pull up a Data Set report for an Org Unit/Reporting Period for which
> there is data on the corresponding Data Entry screen. (The form displays
> with no data in the cells.)
>
> We have a test version of this DHIS instance with data that is about 6
> weeks old. I am able to run the simple Pivot Table and Data Set Reports
> without issue -- they produce the expected data.
>
> What might be wrong with our live production instance? What tables can I
> query on the backend to determine what's in the Analytics tables? Could it
> be due to User Access changes (even though the same user sees the data in
> Data Entry)? We had to reboot the production server 4 days ago, but I
> believe the issue with data not appearing in the pivot tables was happening
> before that.
>
> Any help would be appreciated. Thank you.
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
>