Sep 2014 09:37:36 +0200
Subject: Re: [Dhis2-devs] periodstructure giving errors...
To: moemedi.ntuny...@hotmail.com
CC: jason.p.picker...@gmail.com; dhis2-devs@lists.launchpad.net
Depending on how much of configuration you have in your database, one option
could be to start afresh - doing metadata
ll value in column "iso"
> violates not-null constraint.
>
>
>
>
> *Moemedi NtunyaneCo-founder KeyInConsulting*
>
>
> --
> Date: Tue, 16 Sep 2014 09:18:20 +0200
>
> Subject: Re: [Dhis2-devs] periodstructure giving errors...
> F
gt;
>
>
> *Moemedi NtunyaneCo-founder KeyInConsulting*
>
>
> --
> Date: Tue, 16 Sep 2014 09:18:20 +0200
>
> Subject: Re: [Dhis2-devs] periodstructure giving errors...
> From: jason.p.picker...@gmail.com
> To: moemedi.ntuny...@hotmail.com
&g
ue, 16 Sep 2014 09:18:20 +0200
Subject: Re: [Dhis2-devs] periodstructure giving errors...
From: jason.p.picker...@gmail.com
To: moemedi.ntuny...@hotmail.com
CC: larshe...@gmail.com; dhis2-devs@lists.launchpad.net
Yeah, well, I can't offer much more advice other in this case. We had similar
tunyaneCo-founder KeyInConsulting*
>
>
> --
> Date: Tue, 16 Sep 2014 06:09:43 +0200
> Subject: Re: [Dhis2-devs] periodstructure giving errors...
> From: jason.p.picker...@gmail.com
> To: moemedi.ntuny...@hotmail.com
> CC: larshe...@gmail.com; dhis2-devs@lists.launchpad.net
>
>
I cleared cache and even restarted my tomcat server
Moemedi Ntunyane
Co-founder KeyInConsulting
Date: Tue, 16 Sep 2014 06:09:43 +0200
Subject: Re: [Dhis2-devs] periodstructure giving errors...
From: jason.p.picker...@gmail.com
To: moemedi.ntuny...@hotmail.com
CC: larshe...@gmail.com; dhis2-devs
t;
>
> *Moemedi NtunyaneCo-founder KeyInConsulting*
>
>
> --
> From: moemedi.ntuny...@hotmail.com
> To: larshe...@gmail.com; jason.p.picker...@gmail.com
> CC: dhis2-devs@lists.launchpad.net
> Subject: RE: [Dhis2-devs] periodstructure giving errors...
> Date: Mon, 15 Se
LException:
ERROR: null value in column "iso" violates not-null constraint.
Moemedi Ntunyane
Co-founder KeyInConsulting
From: moemedi.ntuny...@hotmail.com
To: larshe...@gmail.com; jason.p.picker...@gmail.com
CC: dhis2-devs@lists.launchpad.net
Subject: RE: [Dhis2-devs] periodstructure g
Hi Lars,
I have not done that. Im only capturing statistical data.
Regards,
Moemedi Ntunyane
Co-founder KeyInConsulting
Date: Mon, 15 Sep 2014 16:10:13 +0200
Subject: Re: [Dhis2-devs] periodstructure giving errors...
From: larshe...@gmail.com
To: jason.p.picker...@gmail.com
CC: moemedi.ntuny
-founder KeyInConsulting*
>
>
> --
> Date: Mon, 15 Sep 2014 16:01:08 +0200
>
> Subject: Re: [Dhis2-devs] periodstructure giving errors...
> From: jason.p.picker...@gmail.com
> To: moemedi.ntuny...@hotmail.com
> CC: dhis2-devs@lists.launchpad.net
>
> I suspect
Mon, 15 Sep 2014 12:22:31 +0200
Subject: Re: [Dhis2-devs] periodstructure giving errors...
From: jason.p.picker...@gmail.com
To: moemedi.ntuny...@hotmail.com
CC: dhis2-devs@lists.launchpad.net
So, the period 1589;6;"2010-02-01";"2010-02-28 , points to a yearly period
type, which is
Exception: ERROR: null value in column "iso" violates
> not-null constraint.
>
> Regards,
>
> Moemedi Ntunyane
> Co-founder KeyInConsulting
>
> -
> Date: Mon, 15 Sep 2014 12:22:31 +0200
>
> Subject: Re: [Dhis2-devs] periodstructure giving errors...
&g
s (?,?,?,?,?,?,?,?,?,?,?,?,?)]; 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,
>>
>>
>> *
mat is
> available as:
>
> 1573;6;"2010-01-01";"2010-01-31"
> 1589;6;"2010-02-01";"2010-02-28"
>
> The error available shows that there is key violation for null values for
> iso column in the periodstructure table.
>
>
>
>
> *Moemedi NtunyaneCo-founder KeyIn
01";"2010-01-31"
1589;6;"2010-02-01";"2010-02-28"
The error available shows that there is key violation for null values for iso
column in the periodstructure table.
Moemedi Ntunyane
Co-founder KeyInConsulting
Date: Mon, 15 Sep 2014 11:46:07 +0200
Subje
;;"2010-02-28"
>
> The error available shows that there is key violation for null values for
> iso column in the periodstructure table.
>
>
>
>
> *Moemedi NtunyaneCo-founder KeyInConsulting*
>
>
> --
> Date: Mon, 15 Sep 2014
le shows that there is key violation for null values for iso
column in the periodstructure table.
Moemedi Ntunyane
Co-founder KeyInConsulting
Date: Mon, 15 Sep 2014 11:46:07 +0200
Subject: Re: [Dhis2-devs] periodstructure giving errors...
From: jason.p.picker...@gmail.com
To: moe
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 hel
18 matches
Mail list logo
