Some Tables Not Created? (Clean Install)

Support - Assistance technique
1

Hi,

On a clean install I can see 106 tables being created in postgres, but in the logs I also always see:

  • INFO 2013-09-05 14:20:26,797 System property dhis2.home not set (DefaultLocationManager.java [main])

  • INFO 2013-09-05 14:20:26,801 Environment variable DHIS2_HOME points to /usr/share/dhis2 (DefaultLocationManager.java [main])

  • ERROR 2013-09-05 14:20:33,802 HHH000388: Unsuccessful: create table attribute (attributeid integer generated by default as identity, uid varchar(11), code varchar(50), created timestamp, lastUpdated timestamp, name varchar(230) not null, valueType varchar(255) not null, mandatory boolean not null, dataElementAttribute boolean not null, dataElementGroupAttribute boolean, indicatorAttribute boolean not null, indicatorGroupAttribute boolean, organisationUnitAttribute boolean not null, organisationUnitGroupAttribute boolean, userAttribute boolean not null, userGroupAttribute boolean, sortOrder integer, primary key (attributeid)) (SchemaUpdate.java [main])

  • ERROR 2013-09-05 14:20:33,804 ERROR: syntax error at or near “generated”
    Position: 45 (SchemaUpdate.java [main])

(and many more similar messages)

This seems to ultimately result in this failure. I’m setting up DHIS2 on a 64bit Ubuntu machine and I followed these install instructions.

Any suggestions regarding what I could try next would be greatly appreciated.

Thanks!

Pascal

···

–
*Pascal Brandt

Senio**r Software Developer, Jembi Health Systems | SOUTH AFRICA
Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt

E-mail: pascal@jembi.org*

2

Hi,

I managed to figure this out, fortunately. The problem was that in my hibernate.properties file I had:

ibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

instead of:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

This resulted in the “generated” keyword causing a syntax error. The tables that weren’t getting created were those whose create statements contained the this keyword.

Ciao,

Pascal

···

On 5 September 2013 14:30, Pascal Brandt pascal@jembi.org wrote:

Hi,

On a clean install I can see 106 tables being created in postgres, but in the logs I also always see:

  • INFO 2013-09-05 14:20:26,797 System property dhis2.home not set (DefaultLocationManager.java [main])

  • INFO 2013-09-05 14:20:26,801 Environment variable DHIS2_HOME points to /usr/share/dhis2 (DefaultLocationManager.java [main])

  • ERROR 2013-09-05 14:20:33,802 HHH000388: Unsuccessful: create table attribute (attributeid integer generated by default as identity, uid varchar(11), code varchar(50), created timestamp, lastUpdated timestamp, name varchar(230) not null, valueType varchar(255) not null, mandatory boolean not null, dataElementAttribute boolean not null, dataElementGroupAttribute boolean, indicatorAttribute boolean not null, indicatorGroupAttribute boolean, organisationUnitAttribute boolean not null, organisationUnitGroupAttribute boolean, userAttribute boolean not null, userGroupAttribute boolean, sortOrder integer, primary key (attributeid)) (SchemaUpdate.java [main])

  • ERROR 2013-09-05 14:20:33,804 ERROR: syntax error at or near “generated”
    Position: 45 (SchemaUpdate.java [main])

(and many more similar messages)

This seems to ultimately result in this failure. I’m setting up DHIS2 on a 64bit Ubuntu machine and I followed these install instructions.

Any suggestions regarding what I could try next would be greatly appreciated.

Thanks!

Pascal

–
*Pascal Brandt

Senio**r Software Developer, Jembi Health Systems | SOUTH AFRICA
Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt

E-mail: pascal@jembi.org*

–
*Pascal Brandt
Senio**r Software Developer, Jembi Health Systems | SOUTH AFRICA

Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt
E-mail: pascal@jembi.org*

3

Thanks Pascal.

Was the typo caused by copy-and-paste from dhis docs or web site, or
clubbed thumbs ?

Lars

···

On Thu, Sep 5, 2013 at 3:30 PM, Pascal Brandt <pascal@jembi.org> wrote:

Hi,

I managed to figure this out, fortunately. The problem was that in my
hibernate.properties file I had:

ibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

instead of:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

This resulted in the "generated" keyword causing a syntax error. The tables
that weren't getting created were those whose create statements contained
the this keyword.

Ciao,
Pascal

On 5 September 2013 14:30, Pascal Brandt <pascal@jembi.org> wrote:

Hi,

On a clean install I can see 106 tables being created in postgres, but in
the logs I also always see:

* INFO 2013-09-05 14:20:26,797 System property dhis2.home not set
(DefaultLocationManager.java [main])
* INFO 2013-09-05 14:20:26,801 Environment variable DHIS2_HOME points to
/usr/share/dhis2 (DefaultLocationManager.java [main])
* ERROR 2013-09-05 14:20:33,802 HHH000388: Unsuccessful: create table
attribute (attributeid integer generated by default as identity, uid
varchar(11), code varchar(50), created timestamp, lastUpdated timestamp,
name varchar(230) not null, valueType varchar(255) not null, mandatory
boolean not null, dataElementAttribute boolean not null,
dataElementGroupAttribute boolean, indicatorAttribute boolean not null,
indicatorGroupAttribute boolean, organisationUnitAttribute boolean not null,
organisationUnitGroupAttribute boolean, userAttribute boolean not null,
userGroupAttribute boolean, sortOrder integer, primary key (attributeid))
(SchemaUpdate.java [main])
* ERROR 2013-09-05 14:20:33,804 ERROR: syntax error at or near
"generated"
  Position: 45 (SchemaUpdate.java [main])

(and many more similar messages)

This seems to ultimately result in this failure. I'm setting up DHIS2 on a
64bit Ubuntu machine and I followed these install instructions.

Any suggestions regarding what I could try next would be greatly
appreciated.

Thanks!

Pascal

--
Pascal Brandt
Senior Software Developer, Jembi Health Systems | SOUTH AFRICA
Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt
E-mail: pascal@jembi.org

--
Pascal Brandt
Senior Software Developer, Jembi Health Systems | SOUTH AFRICA
Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt
E-mail: pascal@jembi.org

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

4

No no, it was my mistake :).

···

On 5 September 2013 15:33, Lars Helge Øverland larshelge@gmail.com wrote:

Thanks Pascal.

Was the typo caused by copy-and-paste from dhis docs or web site, or

clubbed thumbs ?

Lars

On Thu, Sep 5, 2013 at 3:30 PM, Pascal Brandt pascal@jembi.org wrote:

Hi,

I managed to figure this out, fortunately. The problem was that in my

hibernate.properties file I had:

ibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

instead of:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

This resulted in the “generated” keyword causing a syntax error. The tables

that weren’t getting created were those whose create statements contained

the this keyword.

Ciao,

Pascal

On 5 September 2013 14:30, Pascal Brandt pascal@jembi.org wrote:

Hi,

On a clean install I can see 106 tables being created in postgres, but in

the logs I also always see:

  • INFO 2013-09-05 14:20:26,797 System property dhis2.home not set

(DefaultLocationManager.java [main])

  • INFO 2013-09-05 14:20:26,801 Environment variable DHIS2_HOME points to

/usr/share/dhis2 (DefaultLocationManager.java [main])

  • ERROR 2013-09-05 14:20:33,802 HHH000388: Unsuccessful: create table

attribute (attributeid integer generated by default as identity, uid

varchar(11), code varchar(50), created timestamp, lastUpdated timestamp,

name varchar(230) not null, valueType varchar(255) not null, mandatory

boolean not null, dataElementAttribute boolean not null,

dataElementGroupAttribute boolean, indicatorAttribute boolean not null,

indicatorGroupAttribute boolean, organisationUnitAttribute boolean not null,

organisationUnitGroupAttribute boolean, userAttribute boolean not null,

userGroupAttribute boolean, sortOrder integer, primary key (attributeid))

(SchemaUpdate.java [main])

  • ERROR 2013-09-05 14:20:33,804 ERROR: syntax error at or near

“generated”

Position: 45 (SchemaUpdate.java [main])

(and many more similar messages)

This seems to ultimately result in this failure. I’m setting up DHIS2 on a

64bit Ubuntu machine and I followed these install instructions.

Any suggestions regarding what I could try next would be greatly

appreciated.

Thanks!

Pascal

–

Pascal Brandt

Senior Software Developer, Jembi Health Systems | SOUTH AFRICA

Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt

E-mail: pascal@jembi.org

–

Pascal Brandt

Senior Software Developer, Jembi Health Systems | SOUTH AFRICA

Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt

E-mail: pascal@jembi.org

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

–
*Pascal Brandt
Senio**r Software Developer, Jembi Health Systems | SOUTH AFRICA

Mobile: +27 84 827 9342 | Office: +27 21 701 0939 | Skype: psbrandt
E-mail: pascal@jembi.org*