← Back to team overview

dhis2-devs team mailing list archive

Re: Error generating _periodstructure

 

OK, cache clearing worked, analytics now running ... thank you team!

On Fri, Feb 5, 2016 at 2:25 PM, Knut Staring <knutst@xxxxxxxxx> 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" <greg.rowles@xxxxxxxxx> wrote:
>
>> 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 <greg.rowles@xxxxxxxxx>
>> 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
>>> 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 Helge Øverland <lars@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Greg, which DHIS 2 version / build is it?
>>>>
>>>> Lars
>>>>
>>>> On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles <greg.rowles@xxxxxxxxx>
>>>> 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 days. Please help...
>>>>>
>>>>> Kind Regards,
>>>>> Greg
>>>>>
>>>>> --
>>>>> *Health Information Systems Program - South Africa*
>>>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- -
>>>>> - - - *
>>>>> Mobile  :    073 246 2992
>>>>> Landline:   021 851 2216
>>>>> Skype:      gregory_rowles
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> *Health Information Systems Program - South Africa*
>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - -
>>> - - *
>>> Mobile  :    073 246 2992
>>> Landline:   021 851 2216
>>> Skype:      gregory_rowles
>>>
>>
>>
>>
>> --
>> *Health Information Systems Program - South Africa*
>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - -
>> - *
>> Mobile  :    073 246 2992
>> Landline:   021 851 2216
>> Skype:      gregory_rowles
>>
>> _______________________________________________
>> 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
>>
>>


-- 
*Health Information Systems Program - South Africa*
*- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - *
Mobile  :    073 246 2992
Landline:   021 851 2216
Skype:      gregory_rowles

PNG image

PNG image


Follow ups

References