dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Laura,
Seems a bit strange. Here are a few ideas.

1) I assume that the analytics finished without any error? It might  be
good to post a log of the analytics process someplace for us to review.

2) Check the Cache Strategy , documented here
<https://www.dhis2.org/doc/snapshot/en/user/html/ch23.html#systemGeneralSettings>.
What is this set to? Try setting it to "No cache", completely clear your
browser cache (or use incognito mode) and try again.

3) Are you using a caching proxy, such as nginx (as documented here
<https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s03.html#d5e605>)
? If so, disable it.

Regards,
Jason




On Thu, Aug 20, 2015 at 12:27 AM, Laura E. Lincks <
laura.lincks@xxxxxxxxxxxxxxxxx> wrote:

> 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.
>>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049