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.chann...@gmail.com> 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.picker...@gmail.com> > *Sent:* Thursday, July 31, 2014 11:16 Morning > *To:* channara rin <rin.chann...@gmail.com> > *Cc:* DHIS 2 Users list <dhis2-us...@lists.launchpad.net>, DHIS 2 > Developers list <dhis2-devs@lists.launchpad.net> > > 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.chann...@gmail.com> 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-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
