Hi Sumudu, 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 <[email protected]> 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 > > 1. Develop aggregate query builder > 2. enter one patient data for 2014 June > 3. Manual aggregate data - ( success and show data in database ) > 4. Try to generate Resource table - fail and give erro massage at > 2014-06-09 > 00:47:49 as follow > 5. 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' > > I will attach my log file and screen shot. > I am using > dhis 2.15 > Build revision: 15123 Database type: Mysql > OS name:Windows 7OS architecture:x86 > > Can any one help to come out from this? > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
