dhis2-users team mailing list archive

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

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] 
Sent: Thursday, March 3, 2016 5:11 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,

 

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

Attachment: period.PNG
Description: PNG image