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.row...@gmail.com> 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.row...@gmail.com> 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 <l...@dhis2.org> >> wrote: >> >>> Hi Greg, which DHIS 2 version / build is it? >>> >>> Lars >>> >>> On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles <greg.row...@gmail.com> >>> 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@lists.launchpad.net >>>> 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
