dhis2-devs team mailing list archive

[Pascal Brandt <pascal@xxxxxxxxx>]

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<http://pastebin.com/sHgUUYKT>.
I'm setting up DHIS2 on a 64bit Ubuntu machine and I followed these install
instructions<http://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html>
.

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@xxxxxxxxx*