Hi all,
I’m trying to whip up a quick 2.24 prototype using (first time for me) DHIS2 Live. However, after setting up all program metadata and entering 2 events, the second time I ran the analytics, it crashed, with an error message that includes “Table _ORGUNITSTRUCTURE_TEMP already exists”. (Presumably the analytics didn’t tidy up after itself properly the first time it ran.) All further attempts to run the analytics have generated the same error message.
How can I reset/clear the analytics tables? I’ve never worked with embedded H2 databases before – is it possible to get a SQL console, so I can list and drop the offending temp tables? (I’m using the vanilla DHIS2 Live download in an Ubuntu 14.04 VM.)
Cheers, Sam.
Hi Sam,
Even with DHIS2 Live, I usually link it to Postgresql. But there is a console for H2: http://www.h2database.com/html/quickstart.html
Not sure how many people are actually using H2 much, so would be very interesting for us to hear about your experience and problems.
Cheers,
Knut
···
On Mon, Aug 8, 2016 at 4:23 AM, Sam Johnson samuel.johnson@qebo.co.uk wrote:
Hi all,
I’m trying to whip up a quick 2.24 prototype using (first time for me) DHIS2 Live. However, after setting up all program metadata and entering 2 events, the second time I ran the analytics, it crashed, with an error message that includes “Table _ORGUNITSTRUCTURE_TEMP already exists”. (Presumably the analytics didn’t tidy up after itself properly the first time it ran.) All further attempts to run the analytics have generated the same error message.
How can I reset/clear the analytics tables? I’ve never worked with embedded H2 databases before – is it possible to get a SQL console, so I can list and drop the offending temp tables? (I’m using the vanilla DHIS2 Live download in an Ubuntu 14.04 VM.)
Cheers, Sam.
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org