dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Thomas,

which version are you on? Can you please try to upgrade to the latest 2.21
build from here?

https://www.dhis2.org/downloads

This weakness is fixed there.


You can manually drop the "_orgunitstructure_temp" table in the database to
fix it, but there might be more temp tables like that.

regards,

Lars

On Thu, Jan 7, 2016 at 3:50 PM, thomaslavreys <thomaslavreys@xxxxxxxxx>
wrote:

> Dear all,
>
> I’m having a problem when I try to update the Analytics table (Report ->
> Analytics -> Start Export). This is the error report I get:
>
> 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-181]
>
> I only recently started working with DHIS2 so I don’t really understand
> what this message is trying to tell me.  Can anybody help?
>
> Thanks a lot in advance!
>
> Kind regards,
>
> Thomas
> --
> This message was sent from Launchpad by
> thomaslavreys (https://launchpad.net/~thomaslavreys)
> using the "Contact this team's admins" link on the DHIS 2 Users team page
> (https://launchpad.net/~dhis2-users).
> For more information see
> https://help.launchpad.net/YourAccount/ContactingPeople
>



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org>