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 <[email protected]> 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: [email protected]* > -- *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: [email protected]*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
