Error report analytics tables update

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@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

That means that your dhis configuration file is not being recognized and it falls back to the H2 in-memory database. Have a look in the logs and see if the DHIS2_HOME env variable is being picked up.

Lars

···

On Thu, Jan 7, 2016 at 5:26 PM, Thomas Lavreys thomaslavreys@gmail.com wrote:

According to ‘About DHIS 2 ’ I was already using version 2.21, but I installed the latest build anyway. Now I have a new problem, when I start up the version that I just downloaded, it doesn’t recognize my password, I can only login using admin/district, and then all my data from the previous version is gone.

Any ideas or just start all over again? Didn’t have that much data but would be nice to not redo that part!

Best,

Thomas

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Thursday, January 7, 2016 4:09 PM
To: thomaslavreys thomaslavreys@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: Error report analytics tables update

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@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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org