← Back to team overview

dhis2-users team mailing list archive

Re: Error prune period

 

Hi there. Again, hard to say without seeing the entire log. It sort of
stops at the point of generating the periodstructure table. Is there more
to the log?
Regards,
Jason



On Thu, Jul 31, 2014 at 11:46 AM, <rin.channara@xxxxxxxxx> wrote:

>  Hi Jason,
> I am happy that when I run prune period, it doesn’t appear error in
> console and success. But when I run generate “Resource Table”. I got the UI
> still processing so long time. and the console appear like in attached file.
> DO you know what is this problem?
> NOTE:
> I am using
> -DHIS2 v2.16
> -Build revision: 16253
> -Java version: jre7
> -Database: PostgreSQL
> -OS: windows 8
>
> thank you
> channara
> *From:* channara rin <rin.channara@xxxxxxxxx>
> *Sent:* ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎12‎:‎37‎ ‎Evening
> *To:* Jason Pickering <jason.p.pickering@xxxxxxxxx>
>
> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2
> Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>
> Here is the error.
>
> ERROR: update or delete on table "
> period" violates foreign key constraint "mapview_periods_periodid_fkey" on
> table
>  "mapview_periods"
>   Detail: Key (periodid)=(427)
>
> I might try "DELETE FROM mapview_period where periodid = 427;" in the
> database, clear your DHIS2 cache and try again.
>
>
> Best regards,
> Jason
>
>
>
> On Thu, Jul 31, 2014 at 6:33 AM, <rin.channara@xxxxxxxxx> wrote:
>
>>  HI Jason,
>> I am using
>> -DHIS2 v2.16
>> -Build revision: 16253
>> -Java version: jre7
>> -Database: PostgreSQL
>> -OS: windows 8
>> plz check attached file.
>>
>> thanks
>> channara
>> ​
>>
>> *From:* Jason Pickering <jason.p.pickering@xxxxxxxxx>
>> *Sent:* ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎11‎:‎16‎ ‎Morning
>> *To:* channara rin <rin.channara@xxxxxxxxx>
>> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2
>> Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>>
>> Hi Channara,
>> It will  help if you could send the output of the console when you
>> execute the command, along with the usual (DHIS2 version, Java version,
>> OS).
>>
>> Best regards,
>> Jason
>>
>>
>>
>> On Thu, Jul 31, 2014 at 4:50 AM, <rin.channara@xxxxxxxxx> wrote:
>>
>>>  Hi all developers,
>>> when I go to services→maintenance, then I checked run “prune period”, I
>>> always got the error in console. DO you know how can I solve this problem?
>>>
>>> thank you
>>> CHANNARA
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>

Follow ups

References