Very likely you have an invalid period in the periods table. Can you run this and see what happens?
SELECT * FROM period where age(enddate,startdate) != '1 year'::interval and periodtypeid = (SELECT periodtypeid from periodtype where name = 'Yearly'); Also, you should get an error which will help you to decipher which period is not correct , something like Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "in_periodstructure_iso" Detail: Key (iso)=(1995) already exists. Best regards, Jason On Fri, Sep 12, 2014 at 5:03 PM, Moemedi Ntunyane < moemedi.ntuny...@hotmail.com> wrote: > Hi All > > I have this problem while generating the resource tables...all other > tables are fine except periodstructure... > > Process failed: PreparedStatementCallback; SQL [insert into > _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: null value in > column "iso" violates not-null constraint; nested exception is > org.postgresql.util.PSQLException: ERROR: null value in column "iso" > violates not-null constraint > > Regards, > > > *Moemedi NtunyaneCo-founder KeyInConsulting* > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
