Analytics and Data mart: Process failed: java.sql.SQLSyntaxErrorException [2.20]

Harivola_RANDRIANJAF · 4 August 2015 11:34

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

···

L’absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
www.avast.com

Lars · 4 August 2015 11:58

Hi Harivola,

my best guesses here are:

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.
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@psi.mg 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

L’absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
www.avast.com

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars · 4 August 2015 12:03

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@gmail.com wrote:

Hi Harivola,

my best guesses here are:

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.

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@psi.mg 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

L’absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
www.avast.com

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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

smuyambo · 5 August 2015 07:22

Hi

What table is used to store data capture event capture?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 12045 (20150805) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Abyot_Gizaw · 5 August 2015 07:29

Hi Simon,

It is trackedentitydatavalue table.

Thank you,

Abyot.

···

On Wed, Aug 5, 2015 at 9:23 AM Simon Muyambo smmuyambo@gmail.com wrote:

Hi

What table is used to store data capture event capture?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 12045 (20150805) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

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

–

Thank you,

Abyot

Harivola_RANDRIANJAF · 10 August 2015 10:22

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@gmail.com]
Envoyé : mardi 4 août 2015 15:03
À : Harivola RANDRIANJAFY harivolar@psi.mg
Cc : DHIS 2 Users list dhis2-users@lists.launchpad.net
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@gmail.com wrote:

Hi Harivola,

my best guesses here are:

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.

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@psi.mg 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

L’absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
www.avast.com

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

L’absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
www.avast.com