dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

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 <anazodothankgod@xxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>