No no, it was my mistake :).
On 5 September 2013 15:33, Lars Helge Øverland <[email protected]> wrote: > 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 > > > -- *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
