dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #27527
Re: [Bug 1267561] Re: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13
Hi Cenk,
It looks like you are facing the same problem we are in Mozambique. Please see https://bugs.launchpad.net/dhis2/+bug/1268787
If it’s just for demo propose you can always use postgresql instead of h2 default database. You will need to install postgresql on demonstration computers, and all you need is a restore from central server database;
If these are final installations to use in production environment be aware that you may need bidirectional data transmission, and on that case you can’t simply replace live databases with a dump from central server.
Regards,
Paulo Grácio
From: Dhis2-devs [mailto:dhis2-devs-bounces+pgracio=criticalsoftware.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of D. Cenk Erdil
Sent: segunda-feira, 13 de Janeiro de 2014 20:09
To: Knut Staring
Cc: DHIS 2 developers
Subject: Re: [Dhis2-devs] [Bug 1267561] Re: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13
Hi Knut,
(I work with Sharada)
We host server instances for in-country teams, but we need several off-line copies for demonstration and training.
Also, the possibility to enter data while offline, and sync it with the server would be nice, as most our facilities do not have internet.
Thus, the need to move data between server and live editions.
In response to your recommendation, we might try dumping data from postgres and putting it in h2 (unless you've meant something else).
I've done some googling and it looks like there are several methods to do that.
Since we are time-constrained this week (our M&E staff are traveling in-country for demo/training of a shiny instance of brand new DHIS 2.13 with all its bells and whistles), I wanted to get your feedback on what would be the easiest way to move data from 2.13 server to live edition.
Any feedback is greatly appreciated.
Thanks.
--
-Cenk.
On Sat, Jan 11, 2014 at 4:31 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
Hi Sharada,
What exactly is your use case - you want to work with the same data offline on multiple computers? You did an export + import? Could you perhaps just do a db dump and clone the database?
Knut
On Fri, Jan 10, 2014 at 11:27 PM, Sharada Acharya <sa3119@xxxxxxxxxxxx> wrote:
Hi Knut,
After generating the Analytics table, we could see the data in the Pivot
Tables and Data set reports. Now, we have created a new DHIS live
instance (2.13), in which we imported the data from the another DHIS
instance (in which Pivot tables, reports woroked). But in this DHIS
instance, we are still not able to see the data after generating
Analytics tables. We verified that the data is present in the data set.
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1267561
Title:
dataset reports, pivot tables, and data visualizer does not work after
upgrade from 2.4 to 2.13
Status in DHIS 2:
New
Bug description:
Hello,
We have upgraded one of our DHIS server instances from 2.4 to 2.13
last month.
Upon user feedback, we have come to realize that the three modules
have issues working on data that exist in the system.
In particular:
1) Data Set Reports
2) Pivot Tables
3) Data Visualizer
With the data set reports, the system generates a report with blank
values in the 2.13 vs. a complete report in 2.4 (see attached
screenshots).
With Pivot Tables and Data Visualizer, the front-end gives "no values
found" error, while we see the Tomcat log references some missing
relationships in the postgres database (see attached catalina.out).
This behavior is consistent with two separate DHIS instances (with two
different countries), both upgraded from 2.4 to 2.13. It also behaves
similarly on a DHIS Live (2.13) instance which was setup on a local
machine and data was imported from a server instance for the same
country.
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1267561/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522 <tel:%2B4791880522>
http://dhis2.org
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Follow ups
References
-
[Bug 1267561] [NEW] dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13
From: Cenk Erdil, 2014-01-09
-
[Bug 1267561] Re: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13
From: Sharada Acharya, 2014-01-10
-
Re: [Bug 1267561] Re: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13
From: Knut Staring, 2014-01-11
-
Re: [Bug 1267561] Re: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13
From: D. Cenk Erdil, 2014-01-13