dhis2-users team mailing list archive

Thread
Date

Analytics error

To: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: Tirus Gichuhi <gichuhitirus@xxxxxxxxx>
Date: Mon, 30 Oct 2017 16:49:11 +0000
Importance: normal

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