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 <thomaslavr...@gmail.com> 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>
_______________________________________________ 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
