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

Thanks for the feedback. It is becoming one of our nightmares to support
DHIS Live (even worse, plan on deliverables that use a DHIS Live instance).

I think we'll eventually need to pull the plug from using Live, but we are
not there yet (need to upgrade quite a number of instances to DHIS
2.13/14).

Any ideas on how I can make a DHIS Live instance to use the local postgres
instead of the embedded H2?

I've changed the hibernate.properties file in conf directory, but that does
not seem to help.

I've inspected the jar file (of DHIS Live) and couldn't find the reference
to the database.

Any feedback is appreciated.


--
-Cenk.


On Mon, Jan 13, 2014 at 7:09 PM, Paulo Grácio
<pgracio@xxxxxxxxxxxxxxxxxxxx>wrote:

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