← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Analytics error

 

Hi David/Devs,

 

Did you get this problem sorted out. 

 

We also have the same problem after updating one of our instances from 2.19 > 2.20 but strangely enough another instance updated to 2.20 runs analytics perfectly fine. 

 

Here is the build version we updated to and an extract from the analytics log that gave errors. 

We don’t have the SQL views mentioned in the log as SQLviews in our database thus it must be part of the Core code.

Can someone assist with what is wrong please?

 

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:      041-367 1027

Cell:     082 374 2209

E-mail:  <mailto:elmarie@xxxxxxxx> elmarie@xxxxxxxx

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  <http://www.hisp.org/policies.html#comms_disclaimer> http://www.hisp.org/policies.html#comms_disclaimer .   Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to  <mailto:disclaimer@xxxxxxxx> disclaimer@xxxxxxxx and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer. 

 

From: Dhis2-users [mailto:dhis2-users-bounces+elmarie=hisp.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of Marko David Garcia
Sent: 24 July 2015 08:56 PM
To: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: [Dhis2-users] Analytics error

 

Hello all.

 

After migrate from 2.19 to 2.20 version, the analytics process generate an error.

 

ERROR: column "de" does not exist

 

Why this error might occur?.

 

Attach the catalina.out file.

 

Thank you very much.

 

Best regards.

 

Mag. (c). Marko David Garcia M.

Ingeniería Telemática

Universidad del Cauca

Skype: marko_david


-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
<http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclaimer@xxxxxxxx 
<disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*

PNG image

Attachment: ERROR analytics ishp_s.docx
Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document