dhis2-devs team mailing list archive

[Wilfred Senyoni <senyoni@xxxxxxxxx>]

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 <senyoni@xxxxxxxxx>
> *Sent:* ‎Tuesday‎, ‎July‎ ‎22‎, ‎2014 ‎2‎:‎11‎ ‎Evening
> *To:* channara rin <rin.channara@xxxxxxxxx>
> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2
> Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>
> 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
>>
>> [image: 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
>>
>>
>