I have customized dhis2 for mental health requirement.
After data element ,org unit, attribute creation Resources table generation work well and resource table generated at 2014-06-09 00:43:02
Then follow these steps to aggregate data from tracke
Develop aggregate query builder
enter one patient data for 2014 June
Manual aggregate data - ( success and show data in database )
Try to generate Resource table - fail and give erro massage at 2014-06-09 00:47:49 as follow
I try this in demo site but it is not authorize to generate resource table
Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’; nested exception is java.sql.BatchUpdateException: Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’
my guess is that someone has done manual inserts of periods in the period table, and that you have a mismatch between the period (start / end date) and the period type. E.g. you have periods which are days but has the monthly period type. Please investigate this. This SQL will give you the overview:
select * from period p join periodtype pt on p.periodtypeid=pt.periodtypeid;
This sql will set daily period type on day periods:
update period set periodtypeid=1 where startdate=enddate;
regards,
Lars
···
On Mon, Jun 9, 2014 at 4:30 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Dear all,
I have customized dhis2 for mental health requirement.
After data element ,org unit, attribute creation Resources table generation work well and resource table generated at 2014-06-09 00:43:02
Then follow these steps to aggregate data from tracke
Develop aggregate query builder
enter one patient data for 2014 June
Manual aggregate data - ( success and show data in database )
Try to generate Resource table - fail and give erro massage at 2014-06-09 00:47:49 as follow
I try this in demo site but it is not authorize to generate resource table
Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’; nested exception is java.sql.BatchUpdateException: Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’
It happens either when you import from another system so you have period type id = 3 both end dates in year 9999. Another scenario is when you run the manual aggregate query and choose a non-full month e.g 1 Feb 2013 to 16 June 2014. This always inserts an additional monthly period into the table with start date 16-June and end date 16-June. I suspect that this will happen if you are aggregating for a monthly period data set.
Regards,
Busoye
···
On Mon, Jun 9, 2014 at 4:30 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Dear all,
I have customized dhis2 for mental health requirement.
After data element ,org unit, attribute creation Resources table generation work well and resource table generated at 2014-06-09 00:43:02
Then follow these steps to aggregate data from tracke
Develop aggregate query builder
enter one patient data for 2014 June
Manual aggregate data - ( success and show data in database )
Try to generate Resource table - fail and give erro massage at 2014-06-09 00:47:49 as follow
I try this in demo site but it is not authorize to generate resource table
Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’; nested exception is java.sql.BatchUpdateException: Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’
To get past this quickly, you need to check your period table and filter by Periodtypeid 3. Have a look at all any start date that does not begin on the 1st. Delete this from the table. Clear system cache and run analytics again. This should work.
The Devs have to think of a more long-term solution though.
Cheers.
Busoye
···
On Mon, Jun 9, 2014 at 4:30 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Dear all,
I have customized dhis2 for mental health requirement.
After data element ,org unit, attribute creation Resources table generation work well and resource table generated at 2014-06-09 00:43:02
Then follow these steps to aggregate data from tracke
Develop aggregate query builder
enter one patient data for 2014 June
Manual aggregate data - ( success and show data in database )
Try to generate Resource table - fail and give erro massage at 2014-06-09 00:47:49 as follow
I try this in demo site but it is not authorize to generate resource table
Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’; nested exception is java.sql.BatchUpdateException: Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’
Tran can you please check that the aggregation queries produce valid periods (start / end dates are in sync with the period type) ?
···
On Mon, Jun 16, 2014 at 5:00 PM, Adebusoye Anifalaje busoye@hisp.org wrote:
Hi Sumudu,
To get past this quickly, you need to check your period table and filter by Periodtypeid 3. Have a look at all any start date that does not begin on the 1st. Delete this from the table. Clear system cache and run analytics again. This should work.
The Devs have to think of a more long-term solution though.
my guess is that someone has done manual inserts of periods in the period table, and that you have a mismatch between the period (start / end date) and the period type. E.g. you have periods which are days but has the monthly period type. Please investigate this. This SQL will give you the overview:
select * from period p join periodtype pt on p.periodtypeid=pt.periodtypeid;
This sql will set daily period type on day periods:
update period set periodtypeid=1 where startdate=enddate;
On Mon, Jun 9, 2014 at 4:30 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:
Dear all,
I have customized dhis2 for mental health requirement.
After data element ,org unit, attribute creation Resources table generation work well and resource table generated at 2014-06-09 00:43:02
Then follow these steps to aggregate data from tracke
Develop aggregate query builder
enter one patient data for 2014 June
Manual aggregate data - ( success and show data in database )
Try to generate Resource table - fail and give erro massage at 2014-06-09 00:47:49 as follow
I try this in demo site but it is not authorize to generate resource table
Process failed: PreparedStatementCallback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’; nested exception is java.sql.BatchUpdateException: Duplicate entry ‘201406’ for key ‘in_periodstructure_iso’
