dhis2-devs team mailing list archive

[Pascal Brandt <pascal@xxxxxxxxx>]

No no, it was my mistake :).


On 5 September 2013 15:33, Lars Helge Øverland <larshelge@xxxxxxxxx> 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 <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
> >
>



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