dhis2-devs team mailing list archive

[David Siang Fong Oh <doh@xxxxxxxxxxxxxxxx>]

Hi Knut,

I've connected DHIS Live to Postgres and the issue seems to be resolved, so
the underlying problem must be related to the H2 database. Can you raise an
issue on JIRA? Or direct me to the site?

Cheers,

-doh

On Fri, Dec 30, 2016 at 8:49 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> I think most likely the DHIS2 Live is not out of date, but there is an
> issue with the new version having an issue with the H2 database, as there
> is very little testing on that - very likely you are one of the first to
> try the operation you did on H2. I think it would be good if you could a)
> try to connect DHIS Live to Postgres to see if the error persists and b)
> report the issue in JIRA.
>
> Thanks,
> Knut
>
> On Fri, Dec 30, 2016 at 5:09 AM, David Siang Fong Oh <doh@xxxxxxxxxxxxxxxx
> > wrote:
>
>> Hi team,
>>
>> We are encountering problems generating resource tables and analytics
>> tables using the DHIS2 Live version downloadable at:
>>
>> https://www.dhis2.org/download/live/dhis2-live.zip
>>
>> Here is the errors that we see in the DHIS2 app:
>>
>> 2016-12-29 13:48:52 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-191]
>> 2016-12-29 13:48:52 Generating resource tables
>>
>> To recreate the problem simply download and run the DHIS2 Live
>> application and run resource tables twice. The first time is successful but
>> subsequent attempts fail. There seems to be an issue with clearing up temp
>> tables like *orgunitstructure_temp*.
>>
>> Is it possible that the DHIS2 Live version is out of date?
>>
>> Thanks,
>>
>> -doh
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522 <+47%20918%2080%20522>
> Skype: knutstar
> http://dhis2.org
>