dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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.ntunyane@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049