← 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 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
> 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