Error prune period

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

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@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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

console.txt (17 KB)

···

On Thu, Jul 31, 2014 at 4:50 AM, rin.channara@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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

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@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-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp