dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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
>
>