dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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@xxxxxxxxx> 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@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. 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@xxxxxxxxx
>
>
>
>
> --
> 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@xxxxxxxxx
>
> _______________________________________________
> 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
>