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
