← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Error prune period

 

Yes. Thank. I can solve..

Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:

>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
>Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎11‎:‎16‎ ‎Morning
>To: channara rin
>Cc: DHIS 2 Users list, DHIS 2 Developers list
>
>
>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