dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Please raise it at https://jira.dhis2.org/

On Jan 4, 2017 2:31 PM, "David Siang Fong Oh" <doh@xxxxxxxxxxxxxxxx> wrote:

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