Analytics error in 2.29

Hello All,

I’ve been having some issues with Analytics since I upgraded from 2.28 to 2.29.

The scheduled Analytics which is supposed to run at 12:00 midnight always fails with the following error (Screen shot):


I’ve always had to drop the analytics table manually using the CASCADE option and afterwards have to re-run analytics and it works.

Has any one experienced this? How can it be solved?



Barnabas AKUMBA

Mobile: +2348036195778

Skype: barnabas.akumba

Perhaps you could try with the latest build of 2.29, in case this is related to a bug that was recently fixed:




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