dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

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



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org/>