dhis2-users team mailing list archive

[Wilfred Senyoni <senyoni@xxxxxxxxx>]

thus great Channara.

the prune period feature cleans your period table by removing all periods
which have no registered data values. more information on the maintenance
module is here
<https://www.dhis2.org/doc/snapshot/en/user/html/ch22s03.html>

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 PM, <rin.channara@xxxxxxxxx> wrote:

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