Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Hi Abdul,
this happens because you have some sort of duplicate record in your “period” database table, for a period near Nov 25, 2015. Have a look for that in the period table and remove any duplicates.
This is however a problem we have seen a few times now so we will put in a “safety check” in the system to warn about and then ignore this issue.
regards,
Lars
On Thu, Mar 3, 2016 at 4:04 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
Hi Lars,
I didn’t find any duplicated in table “period” or table “_dateperiodstructure”
And date “25-10-2015” contain data value, so how can I fix this problem without delete data value
Best regards,
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Thursday, March 3, 2016 5:11 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
this happens because you have some sort of duplicate record in your “period” database table, for a period near Nov 25, 2015. Have a look for that in the period table and remove any duplicates.
This is however a problem we have seen a few times now so we will put in a “safety check” in the system to warn about and then ignore this issue.
regards,
Lars
On Thu, Mar 3, 2016 at 4:04 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
Hi Abdul,
okay I am not 100% sure what causes this. I have now included a uniqueness check on ISO dates in the generation of the period resource table. It should ignore duplicates and provide a log warning when duplicates are encountered.
Could you please try to upgrade to the latest 2.22 and see if that fixes your problem. Build ready in 15 minutes. Revision 21900.
regards,
Lars
On Fri, Mar 4, 2016 at 1:24 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Hi Lars,
I didn’t find any duplicated in table “period” or table “_dateperiodstructure”
And date “25-10-2015” contain data value, so how can I fix this problem without delete data value
Best regards,
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Thursday, March 3, 2016 5:11 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
this happens because you have some sort of duplicate record in your “period” database table, for a period near Nov 25, 2015. Have a look for that in the period table and remove any duplicates.
This is however a problem we have seen a few times now so we will put in a “safety check” in the system to warn about and then ignore this issue.
regards,
Lars
On Thu, Mar 3, 2016 at 4:04 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
I upgraded to version 2.22 Revision 21900 and problem fixed, without remove any data.
Also I did test in version 2.21 and remove period in 25-11-2015 and the data in this period and that fixed this problem
Thank you so match
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Wednesday, March 9, 2016 5:39 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
okay I am not 100% sure what causes this. I have now included a uniqueness check on ISO dates in the generation of the period resource table. It should ignore duplicates and provide a log warning when duplicates are encountered.
Could you please try to upgrade to the latest 2.22 and see if that fixes your problem. Build ready in 15 minutes. Revision 21900.
regards,
Lars
On Fri, Mar 4, 2016 at 1:24 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Hi Lars,
I didn’t find any duplicated in table “period” or table “_dateperiodstructure”
And date “25-10-2015” contain data value, so how can I fix this problem without delete data value
Best regards,
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Thursday, March 3, 2016 5:11 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
this happens because you have some sort of duplicate record in your “period” database table, for a period near Nov 25, 2015. Have a look for that in the period table and remove any duplicates.
This is however a problem we have seen a few times now so we will put in a “safety check” in the system to warn about and then ignore this issue.
regards,
Lars
On Thu, Mar 3, 2016 at 4:04 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
That sounds good, thanks for applying the fix.
Note that this fix is to some extent hiding the real problem, so have a look in the logs for warnings about duplicate periods going forward.
regards,
Lars
On Thu, Mar 10, 2016 at 10:53 AM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
I upgraded to version 2.22 Revision 21900 and problem fixed, without remove any data.
Also I did test in version 2.21 and remove period in 25-11-2015 and the data in this period and that fixed this problem
Thank you so match
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Wednesday, March 9, 2016 5:39 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
okay I am not 100% sure what causes this. I have now included a uniqueness check on ISO dates in the generation of the period resource table. It should ignore duplicates and provide a log warning when duplicates are encountered.
Could you please try to upgrade to the latest 2.22 and see if that fixes your problem. Build ready in 15 minutes. Revision 21900.
regards,
Lars
On Fri, Mar 4, 2016 at 1:24 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Hi Lars,
I didn’t find any duplicated in table “period” or table “_dateperiodstructure”
And date “25-10-2015” contain data value, so how can I fix this problem without delete data value
Best regards,
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Thursday, March 3, 2016 5:11 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
this happens because you have some sort of duplicate record in your “period” database table, for a period near Nov 25, 2015. Have a look for that in the period table and remove any duplicates.
This is however a problem we have seen a few times now so we will put in a “safety check” in the system to warn about and then ignore this issue.
regards,
Lars
On Thu, Mar 3, 2016 at 4:04 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
There is also an integrity check “Dupliate periods” which should also help you to identify this problem. Look in “Data Administration → Data integrity”. You will still need to resolve the problem directly in the database however.
Regards,
Jason
On Thu, Mar 10, 2016 at 10:57 AM, Lars Helge Øverland lars@dhis2.org wrote:
That sounds good, thanks for applying the fix.
Note that this fix is to some extent hiding the real problem, so have a look in the logs for warnings about duplicate periods going forward.
regards,
Lars
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
On Thu, Mar 10, 2016 at 10:53 AM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
I upgraded to version 2.22 Revision 21900 and problem fixed, without remove any data.
Also I did test in version 2.21 and remove period in 25-11-2015 and the data in this period and that fixed this problem
Thank you so match
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Wednesday, March 9, 2016 5:39 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
okay I am not 100% sure what causes this. I have now included a uniqueness check on ISO dates in the generation of the period resource table. It should ignore duplicates and provide a log warning when duplicates are encountered.
Could you please try to upgrade to the latest 2.22 and see if that fixes your problem. Build ready in 15 minutes. Revision 21900.
regards,
Lars
On Fri, Mar 4, 2016 at 1:24 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Hi Lars,
I didn’t find any duplicated in table “period” or table “_dateperiodstructure”
And date “25-10-2015” contain data value, so how can I fix this problem without delete data value
Best regards,
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Thursday, March 3, 2016 5:11 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
this happens because you have some sort of duplicate record in your “period” database table, for a period near Nov 25, 2015. Have a look for that in the period table and remove any duplicates.
This is however a problem we have seen a few times now so we will put in a “safety check” in the system to warn about and then ignore this issue.
regards,
Lars
On Thu, Mar 3, 2016 at 4:04 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
Dear Jason,
I fixed problems in “data integrity”, but duplicated data wasn’t exist, but now after upgrade to version 2.22 problem fixed,
Thank you so much for your advice.
Regards,
From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Thursday, March 10, 2016 12:00 PM
To: Lars Helge Øverland lars@dhis2.org
Cc: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com; DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
There is also an integrity check “Dupliate periods” which should also help you to identify this problem. Look in “Data Administration → Data integrity”. You will still need to resolve the problem directly in the database however.
Regards,
Jason
On Thu, Mar 10, 2016 at 10:57 AM, Lars Helge Øverland lars@dhis2.org wrote:
That sounds good, thanks for applying the fix.
Note that this fix is to some extent hiding the real problem, so have a look in the logs for warnings about duplicate periods going forward.
regards,
Lars
On Thu, Mar 10, 2016 at 10:53 AM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
I upgraded to version 2.22 Revision 21900 and problem fixed, without remove any data.
Also I did test in version 2.21 and remove period in 25-11-2015 and the data in this period and that fixed this problem
Thank you so match
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Wednesday, March 9, 2016 5:39 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
okay I am not 100% sure what causes this. I have now included a uniqueness check on ISO dates in the generation of the period resource table. It should ignore duplicates and provide a log warning when duplicates are encountered.
Could you please try to upgrade to the latest 2.22 and see if that fixes your problem. Build ready in 15 minutes. Revision 21900.
regards,
Lars
On Fri, Mar 4, 2016 at 1:24 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Hi Lars,
I didn’t find any duplicated in table “period” or table “_dateperiodstructure”
And date “25-10-2015” contain data value, so how can I fix this problem without delete data value
Best regards,
From: Lars Helge Øverland [mailto:lars@dhis2.org]
Sent: Thursday, March 3, 2016 5:11 PM
To: Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com
Cc: DHIS 2 Users list dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Problem in Analytic
Hi Abdul,
this happens because you have some sort of duplicate record in your “period” database table, for a period near Nov 25, 2015. Have a look for that in the period table and remove any duplicates.
This is however a problem we have seen a few times now so we will put in a “safety check” in the system to warn about and then ignore this issue.
regards,
Lars
On Thu, Mar 3, 2016 at 4:04 PM, Abdul Karim Jaafar abdulkarim.jaafar87@gmail.com wrote:
Dears all,
I have a problem with “Analytics tables update”
This problem has appeared after I did maintenance from “Data Administration” because analytic cost too mutch time
And now when I try to do analytic I see this problem:
in server:
in browser:
I use Version: 2.21
Build revision: 20967
Any solution
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
–
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049