Re: [Dhis2-users] Analytics error after upgrade to 2.29

2018-05-08 Thread Knut Staring
Still not sure why this error arose, but *fixed it" by deleting completenessregistrations from before 2015: delete from completedatasetregistration where periodid in (select periodid from period where startdate <'2015-01-01') On Tue, May 8, 2018 at 7:43 PM, Knut Staring wrote:

[Dhis2-users] Analytics error after upgrade to 2.29

2018-05-08 Thread Knut Staring
There seems to be a problem with year (it is trying to insert 2015 in a table that requires 2014). Does anyone have an insight into why this happens? Caused by: org.postgresql.util.PSQLException: ERROR: new row for relation "analytics_completeness_temp_2014" violates check constraint