dhis2-users team mailing list archive

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

Thank you Joao,

We followed your advice to no avail. The problem still exists, although I
AM able to see data in the Analytics tables but only in the back end. From
what I've spot-checked, it looks to be correct.

We have another instance on the same physical server which is also causing
problems with regard to data not appearing in Analytics as expected (it
shows some data, just not the most recent data. It appears to be data from
a previous run.) Might there be something wrong with the server? We cannot
see anything. We have resolved, I think, all memory leaks and have rebooted
the instance and yet the problem persists.

*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 Wed, Aug 19, 2015 at 1:46 AM, Joao Mazuze <Joao_Mazuze@xxxxxxxxxxxx>
wrote:

> Hi Laura,
>
> Did you try running Data AdministrationàMaintenance?Then reboot your
> server (optional). May this could help.
>
>
>
> Regards,
>
> Joao
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+joao_mazuze=
> chasssmt.com@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Laura E. Lincks
> *Sent:* Tuesday, August 18, 2015 11:07 PM
> *To:* DHIS Users
> *Subject:* [Dhis2-users] Data not displaying in Pivot tables and Data Set
> reports
>
>
>
> 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
>
>
> ------------------------------
> This message may contain privileged and confidential information intended
> solely for the addressee. Please do not read, disseminate or copy it unless
> you are the intended recipient. If this message has been received in error,
> we kindly ask that you notify the sender immediately by return email and
> delete all copies of the message from your system.
>