Dear all,
I’m having a problem when I try to update the Analytics table (Report → Analytics → Start Export). This is the error report I get:
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-181]
I only recently started working with DHIS2 so I don’t really understand what this message is trying to tell me. Can anybody help?
Thanks a lot in advance!
Kind regards,
Thomas