dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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@xxxxxxxxx>
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@xxxxxxxxx]
> *Sent:* Thursday, January 7, 2016 4:09 PM
> *To:* thomaslavreys <thomaslavreys@xxxxxxxxx>; DHIS 2 Users list <
> dhis2-users@xxxxxxxxxxxxxxxxxxx>
> *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@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>
>
>
>



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