DHIS2 Live - problems generating resource tables

Support - Assistance technique
#1

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

#2

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@thoughtworks.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

#3

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,

···

On Fri, Dec 30, 2016 at 8:49 PM, Knut Staring knutst@gmail.com 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

-doh

On Fri, Dec 30, 2016 at 5:09 AM, David Siang Fong Oh doh@thoughtworks.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

–

#4

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

···

On Jan 4, 2017 2:31 PM, “David Siang Fong Oh” doh@thoughtworks.com 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@gmail.com 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@thoughtworks.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

–