Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Knut Staring
Great. Always clear.. On Feb 5, 2016 1:27 PM, "Greg Rowles" wrote: > OK, cache clearing worked, analytics now running ... thank you team! > > On Fri, Feb 5, 2016 at 2:25 PM, Knut Staring wrote: > >> In your datavalue table you will have references to the one you deleted. >> Update those to poin

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
OK, cache clearing worked, analytics now running ... thank you team! On Fri, Feb 5, 2016 at 2:25 PM, Knut Staring wrote: > In your datavalue table you will have references to the one you deleted. > Update those to point to the remaining one > On Feb 5, 2016 1:21 PM, "Greg Rowles" wrote: > >> ps

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Knut Staring
In your datavalue table you will have references to the one you deleted. Update those to point to the remaining one On Feb 5, 2016 1:21 PM, "Greg Rowles" wrote: > ps. 9295515 was the periodid (record) we deleted. The other duplicate > periodid was 9295516... > > On Fri, Feb 5, 2016 at 2:19 PM, Gr

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
ps. 9295515 was the periodid (record) we deleted. The other duplicate periodid was 9295516... On Fri, Feb 5, 2016 at 2:19 PM, Greg Rowles wrote: > We're running 2.19 but i found the duplicate. We had 2 period rows with > the exact same values. I deleted the entry with no foreign key values in >

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
We're running 2.19 but i found the duplicate. We had 2 period rows with the exact same values. I deleted the entry with no foreign key values in datavalue but when rerunning analytics we're getting a new error: [image: Inline image 1] Kind Regards, Greg On Fri, Feb 5, 2016 at 2:11 PM, Lars Helg

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Alex Tumwesigye
Dear Greg, The issue is a result of the same date range (startdate - enddate) but different periodTypes. Look for that. Alex On Fri, Feb 5, 2016 at 3:05 PM, Knut Staring wrote: > April 9 exists twice, it seems. Which version? > > On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles wrote: > >> Hi Devs

Re: [Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Knut Staring
April 9 exists twice, it seems. Which version? On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles wrote: > Hi Devs > > Our analytics process is failing with the following error: > > [image: Inline image 1] > > Any suggestions? This is a production DHIS2 instance which hasn't > refreshed analytics for 4

[Dhis2-devs] Error generating _periodstructure

2016-02-05 Thread Greg Rowles
Hi Devs Our analytics process is failing with the following error: [image: Inline image 1] Any suggestions? This is a production DHIS2 instance which hasn't refreshed analytics for 4 days. Please help... Kind Regards, Greg -- *Health Information Systems Program - South Africa* *- - - - - - -