← Back to team overview

dhis2-devs team mailing list archive

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