Greg
(Greg)
5 February 2016 12:03
1
Hi Devs
Our analytics process is failing with the following error:
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
April 9 exists twice, it seems. Which version?
···
On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles greg.rowles@gmail.com wrote:
Hi Devs
Our analytics process is failing with the following error:
Any suggestions? This is a production DHIS2 instance which hasn’t refreshed analytics for 4 days. Please help…
Kind Regards,
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
Greg
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
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
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 knutst@gmail.com wrote:
April 9 exists twice, it seems. Which version?
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
–
On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles greg.rowles@gmail.com wrote:
Hi Devs
Our analytics process is failing with the following error:
Any suggestions? This is a production DHIS2 instance which hasn’t refreshed analytics for 4 days. Please help…
Kind Regards,
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
Greg
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
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
–
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don’t want to be anything other than what I have been - one tree hill "
Greg
(Greg)
5 February 2016 12:19
4
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:
Kind Regards,
Greg
···
On Fri, Feb 5, 2016 at 2:11 PM, Lars Helge Øverland lars@dhis2.org wrote:
Lars
Hi Greg, which DHIS 2 version / build is it?
–
On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles greg.rowles@gmail.com wrote:
Hi Devs
Our analytics process is failing with the following error:
Any suggestions? This is a production DHIS2 instance which hasn’t refreshed analytics for 4 days. Please help…
Kind Regards,
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
Greg
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
Greg
(Greg)
5 February 2016 12:20
5
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@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:
Kind Regards,
Greg
–
On Fri, Feb 5, 2016 at 2:11 PM, Lars Helge Øverland lars@dhis2.org wrote:
Lars
Hi Greg, which DHIS 2 version / build is it?
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles greg.rowles@gmail.com wrote:
Hi Devs
Our analytics process is failing with the following error:
Any suggestions? This is a production DHIS2 instance which hasn’t refreshed analytics for 4 days. Please help…
Kind Regards,
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
Greg
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
In your datavalue table you will have references to the one you deleted. Update those to point to the remaining one
···
On Fri, Feb 5, 2016 at 2:19 PM, Greg Rowles greg.rowles@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:
Kind Regards,
Greg
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
On Fri, Feb 5, 2016 at 2:11 PM, Lars Helge Øverland lars@dhis2.org wrote:
Lars
Hi Greg, which DHIS 2 version / build is it?
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles greg.rowles@gmail.com wrote:
Hi Devs
Our analytics process is failing with the following error:
Any suggestions? This is a production DHIS2 instance which hasn’t refreshed analytics for 4 days. Please help…
Kind Regards,
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
Greg
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
Greg
(Greg)
5 February 2016 12:27
7
OK, cache clearing worked, analytics now running … thank you team!
···
On Fri, Feb 5, 2016 at 2:25 PM, Knut Staring knutst@gmail.com 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@gmail.com wrote:
ps. 9295515 was the periodid (record) we deleted. The other duplicate periodid was 9295516…
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
–
On Fri, Feb 5, 2016 at 2:19 PM, Greg Rowles greg.rowles@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:
Kind Regards,
Greg
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
On Fri, Feb 5, 2016 at 2:11 PM, Lars Helge Øverland lars@dhis2.org wrote:
Lars
Hi Greg, which DHIS 2 version / build is it?
–
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
On Fri, Feb 5, 2016 at 1:03 PM, Greg Rowles greg.rowles@gmail.com wrote:
Hi Devs
Our analytics process is failing with the following error:
Any suggestions? This is a production DHIS2 instance which hasn’t refreshed analytics for 4 days. Please help…
Kind Regards,
Health Information Systems Program - South Africa
**- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - - - ****- - - - - **
Mobile : 073 246 2992
Landline: 021 851 2216
Skype: gregory_rowles
Greg
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