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 < [email protected]> 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 <[email protected]> > 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= >> [email protected]] *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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
