dhis2-users team mailing list archive

[<rin.channara@xxxxxxxxx>]

YES now I can delete duplicate that occurred error. now it work fine, when I generate table.

BUT WHEN I TICK “PRUNE PERIOD” IN maintenance section. I got the console error. I don’t know what prune period mean?


thank you

channara





From: Wilfred Senyoni
Sent: ‎Tuesday‎, ‎July‎ ‎22‎, ‎2014 ‎4‎:‎32‎ ‎Evening
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list





Hello channara
look at the log files (catalina.out) and see which table the duplicate period is referred to. You will need to delete the periods which are duplicates before you can proceed.




Cheers



Wilfred F. Senyoni
Computer Science and Engineering Department 
College of Information and Communication Technologies
University of Dar es salaam



On Tue, Jul 22, 2014 at 11:41 AM, <rin.channara@xxxxxxxxx> wrote:




hi Wilfred,

when I clicked “Prune periods”, in the console got the error too.




* ERROR 2014-07-22 15:42:23,133 HHH000352: Unable to release batch statement...
(AbstractBatchImpl.java [http-bio-8080-exec-16])
* ERROR 2014-07-22 15:42:23,134 HHH000246: SQLException escaped proxy (AbstractB
atchImpl.java [http-bio-8080-exec-16])
java.sql.SQLException: You can't operate on a closed Statement!!!











From: Wilfred Senyoni
Sent: ‎Tuesday‎, ‎July‎ ‎22‎, ‎2014 ‎2‎:‎11‎ ‎Evening
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list







Hello Channara
You need to clean your periods by going to the System Administration -> Maintenance -> Prune periods.

You will also need to observer the logs as some periods might require you to delete them manually.




Cheers



Wilfred F. Senyoni
Computer Science and Engineering Department 
College of Information and Communication Technologies
University of Dar es salaam



On Tue, Jul 22, 2014 at 6:47 AM, channara rin <rin.channara@xxxxxxxxx> wrote:



Hi all user, and developers,



When i click generate table i got this below error. DO YOU KNOW HOW TO SOLVE THIS PROBLEM?


NOTE: 

DHIS2 version: 2.15

Build revision: 15195

Database: PostgreSQL




 Inline image 1 

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp