← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Error prune period

 

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

References