dhis2-users team mailing list archive

["Harivola RANDRIANJAFY" <harivolar@xxxxxx>]

Hi Lars,



I think it is due to 2 Indicators conflict where the formula is like (DataElement x Number) :

Ex :

Indicator 1 = DataElement1 x 0.25

Indicator 2 = DataElement1 x 1.34



Indicator 1 et Indicator2 use the same DataElement in Numerator and Denominator=1



When I created the Indicator1 and go to Report/Datamart Analytics, the process is completed and no Error. But when the Indicator2 is created, the process is failed. So I have used only the Indicator1 and delete the indicator2.



Any other suggestion or solution please ?



Regards,



Harivola



PS : the uid code is like this ICL8MJ0PZOH_QE63W1GD7SK where QE63W1GD7SK is categoryoptioncombouid and ICL8MJ0PZOH is dataelement uid













De : Lars Helge Øverland [mailto:larshelge@xxxxxxxxx]
Envoyé : mardi 4 août 2015 15:03
À : Harivola RANDRIANJAFY <harivolar@xxxxxx>
Cc : DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Objet : Re: [Dhis2-users] Analytics and Data mart: Process failed: java.sql.SQLSyntaxErrorException [2.20]





Sorry the object with UID DELOOOYRXTI7W could also be a data element.



Lars







On Tue, Aug 4, 2015 at 1:58 PM, Lars Helge Øverland <larshelge@xxxxxxxxx <mailto:larshelge@xxxxxxxxx> > wrote:

Hi Harivola,



my best guesses here are:



1. an integrity issue with the database related to attributes linked to a program. Please check through the UI and/or the Web API that the attribute with uid DELOOOYRXTI7W is not a member of the program multiple times.



2. you have duplicate uids for tracked entity attributes. I assume DELOOOYRXTI7W was generated by yourself since its not a valid UID (it is supposed to have 11 characters). Please have a look at this.





regards,



Lars



On Tue, Aug 4, 2015 at 1:34 PM, Harivola RANDRIANJAFY <harivolar@xxxxxx <mailto:harivolar@xxxxxx> > wrote:

Hi all,



There seems to be a problem since one week when I proceed Report/Analytics and data mart.



After 12 minutes, the process failed and give this captured image :







Please, could someone help how to check and solve this type of error.



Best regards,



Harivola RANDRIANJAFY



  _____


 <https://www.avast.com/antivirus>

L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
 <https://www.avast.com/antivirus> www.avast.com





_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp







--

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

 <https://www.dhis2.org> http://www.dhis2.org









--

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

 <https://www.dhis2.org> http://www.dhis2.org





  _____


 <https://www.avast.com/antivirus>

L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
 <https://www.avast.com/antivirus> www.avast.com





---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus