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

[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:

> 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
> "analytics_completeness_temp_2014_yearly_check"
>   Detail: Failing row contains (null, null, null, null, XbBIPEpxTue,
> XbBIPEpxTue, aRxa6o8GqZN, HfVjCurKxh2, t0J75eHKxz5, xLWuQq3DjOR,
> iZNVvlnVxm6, ELzS3pnwJyh, null, null, null, null, null, null, null, 2015W1,
> null, null, null, null, 2015BiW0, 201501, 201501B, 2015Q1, 2015S1,
> 2014AprilS2, 2015, 2014April, 2014July, 2014Oct, t, zJrL4HQqYmD,
> 2015-01-06).
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Analytics error after upgrade to 2.29

[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
"analytics_completeness_temp_2014_yearly_check"
  Detail: Failing row contains (null, null, null, null, XbBIPEpxTue,
XbBIPEpxTue, aRxa6o8GqZN, HfVjCurKxh2, t0J75eHKxz5, xLWuQq3DjOR,
iZNVvlnVxm6, ELzS3pnwJyh, null, null, null, null, null, null, null, 2015W1,
null, null, null, null, 2015BiW0, 201501, 201501B, 2015Q1, 2015S1,
2014AprilS2, 2015, 2014April, 2014July, 2014Oct, t, zJrL4HQqYmD,
2015-01-06).
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp