Hi Everyone
I’m new to DHIS 2 and I’ve run into a problem that I cant solve. I tried to create a pivot table out of some data I had put in and the table shows but no data. So I manually tried to update analytics from the reports section and I got this error below. Any ideas on what this is?
2017-10-28 10:10:34
···
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), “idlevel5” integer, “uidlevel5” character(11), “idlevel6” integer, “uidlevel6” 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), “idlevel5” integer, “uidlevel5” character(11), “idlevel6” integer, “uidlevel6” character(11)); [42101-191]
2017-10-28 10:10:33
Updating resource tables
2017-10-28 10:10:33
Analytics table update process started
Any help would be appreciated
Thanks
Sent from Mail for Windows 10