dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

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