← Back to team overview

dhis2-users team mailing list archive

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

 

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>
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
>
>
> ------------------------------
> [image: Avast logo] <https://www.avast.com/antivirus>
>
> L'absence de virus dans ce courrier électronique a été vérifiée par le
> logiciel antivirus Avast.
> www.avast.com <https://www.avast.com/antivirus>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : 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
http://www.dhis2.org <https://www.dhis2.org>

PNG image


Follow ups

References