dhis2-devs team mailing list archive

[Pascal Brandt <pascal@xxxxxxxxx>]

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



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