Please raise it at https://jira.dhis2.org/
On Jan 4, 2017 2:31 PM, "David Siang Fong Oh" <[email protected]> wrote: > Hi Knut, > > I've connected DHIS Live to Postgres and the issue seems to be resolved, > so the underlying problem must be related to the H2 database. Can you raise > an issue on JIRA? Or direct me to the site? > > Cheers, > > -doh > > On Fri, Dec 30, 2016 at 8:49 PM, Knut Staring <[email protected]> wrote: > >> I think most likely the DHIS2 Live is not out of date, but there is an >> issue with the new version having an issue with the H2 database, as there >> is very little testing on that - very likely you are one of the first to >> try the operation you did on H2. I think it would be good if you could a) >> try to connect DHIS Live to Postgres to see if the error persists and b) >> report the issue in JIRA. >> >> Thanks, >> Knut >> >> On Fri, Dec 30, 2016 at 5:09 AM, David Siang Fong Oh < >> [email protected]> wrote: >> >>> Hi team, >>> >>> We are encountering problems generating resource tables and analytics >>> tables using the DHIS2 Live version downloadable at: >>> >>> https://www.dhis2.org/download/live/dhis2-live.zip >>> >>> Here is the errors that we see in the DHIS2 app: >>> >>> 2016-12-29 13:48:52 Process failed: StatementCallback; bad SQL grammar >>> [create table orgunitstructure_temp (organisationunitid integer not null >>> primary key, organisationunituid character(11), level integer, "idlevel1" >>> integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" >>> character(11), "idlevel3" integer, "uidlevel3" character(11), "idlevel4" >>> integer, "uidlevel4" character(11));]; nested exception is >>> org.h2.jdbc.JdbcSQLException: Table "_ORGUNITSTRUCTURE_TEMP" already >>> exists; SQL statement: create table orgunitstructure_temp >>> (organisationunitid integer not null primary key, organisationunituid >>> character(11), level integer, "idlevel1" integer, "uidlevel1" >>> character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" >>> integer, "uidlevel3" character(11), "idlevel4" integer, "uidlevel4" >>> character(11)); [42101-191] >>> 2016-12-29 13:48:52 Generating resource tables >>> >>> To recreate the problem simply download and run the DHIS2 Live >>> application and run resource tables twice. The first time is successful but >>> subsequent attempts fail. There seems to be an issue with clearing up temp >>> tables like *orgunitstructure_temp*. >>> >>> Is it possible that the DHIS2 Live version is out of date? >>> >>> Thanks, >>> >>> -doh >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> Norway: +4791880522 <+47%20918%2080%20522> >> Skype: knutstar >> http://dhis2.org >> > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
