dhis2-devs team mailing list archive

[David Siang Fong Oh <doh@xxxxxxxxxxxxxxxx>]

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