dhis2-users team mailing list archive

["Abdul Karim Jaafar" <abdulkarim.jaafar87@xxxxxxxxx>]

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@xxxxxxxxx] 
Sent: Wednesday, March 9, 2016 5:39 PM
To: Abdul Karim Jaafar <abdulkarim.jaafar87@xxxxxxxxx>
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxx <mailto:abdulkarim.jaafar87@xxxxxxxxx> > 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@xxxxxxxxx <mailto:lars@xxxxxxxxx> ] 
Sent: Thursday, March 3, 2016 5:11 PM
To: Abdul Karim Jaafar <abdulkarim.jaafar87@xxxxxxxxx <mailto:abdulkarim.jaafar87@xxxxxxxxx> >
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> >
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@xxxxxxxxx <mailto:abdulkarim.jaafar87@xxxxxxxxx> > 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@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
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

http://www.dhis2.org <https://www.dhis2.org/> 

 





 

-- 

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org <https://www.dhis2.org/>