Hi I'm not sure how well analytics currently works on H2. Would you mind writing a JIRA issue for? jira.dhis2.org
-- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Thu, Aug 3, 2017 at 8:42 PM, ThankGod Anazodo <anazodothank...@yahoo.com> wrote: > Dear all, > I got this error while trying to run analytics: > > 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-194] > > I am running version 2.27, any help please. > > > Thanks. > ThankGod > > _______________________________________________ > 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 > >
_______________________________________________ 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
