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
Hi Channara,
I think you’re problem is well explained in the following bug: https://bugs.launchpad.net/dhis2/+bug/1313954.
I had the same problem but everything was fine after I deleted the double entries in my periods table in PostgreSQL. It seems the double entries are created by using the data aggregators from tracker to aggregate data for non-standard periods (e.g. from 01/07/2014 to 22/07/2014). Instead, try using standard periods to avoid the problem occurring again (e.g. monthly from 01/07/2014 to 31/07/2014, quarterly,…) until the bug gets fixed.
Good luck!
Robin
···
From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher.be@lists.launchpad.net] On Behalf Of channara rin
Sent: 22 July 2014 05:48
To: DHIS 2 Users list; DHIS 2 Developers list
Subject: [Dhis2-users] generate table error
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
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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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!!!
···
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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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@gmail.com 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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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
···
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@gmail.com 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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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
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@gmail.com 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
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list
From: Wilfred Senyoni
Sent: Tuesday, July 22, 2014 4:32 Evening
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@gmail.com 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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Hi Wilfred,
I tried delete period that doesn’t relate to datavalue, mapview and eventreport. But when I ticked “PRUNE PERIOD” to process. I still got the error on console. DO you know this problem below?
···
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@gmail.com 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
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list
From: Wilfred Senyoni
Sent: Tuesday, July 22, 2014 4:32 Evening
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@gmail.com 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@gmail.com 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
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp