dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049