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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp