← Back to team overview

dhis2-users team mailing list archive

Re: Error prune period

 

YES! now it work fine. After I waited to see log around 5mn for complete it’s task. It seem take longer than previous version.


Thank you for helping





From: Jason Pickering
Sent: ‎Friday‎, ‎August‎ ‎01‎, ‎2014 ‎12‎:‎58‎ ‎Evening
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list





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
Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎12‎:‎37‎ ‎Evening
To: Jason Pickering


Cc: DHIS 2 Users list, DHIS 2 Developers list








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

References