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