dhis2-users team mailing list archive

["Thomas Lavreys" <thomaslavreys@xxxxxxxxx>]

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