dhis2-devs team mailing list archive

[Adebusoye Anifalaje <busoye@xxxxxxxx>]

Hi Lars,

I also reported this problem on the Bug list here: https://bugs.launchpad.net/dhis2/+bug/1313954.

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 16 Jun 2014, at 15:39, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:

> 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 <sumuduw00@xxxxxxxxx> 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'   
>    
> I will attach my log file and screen shot.
> I am using   
>   dhis 2.15
> Build revision: 15123
> Database type: Mysql 
> OS name:Windows 7
> OS architecture:x86
> 
> Can any one help to come out from this?
> 
> 
> _______________________________________________
> 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
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp