Hi,
I've got one instance where data integrity check under maintenance fails at
the very end, and never display any result.
The tomcat log - anybody able to say what this means?
* INFO 2018-04-06 10:47:56,136 Checked indicators
(DefaultDataIntegrityService.java [taskScheduler-17])
* INFO 2018-
Hi devs,
Can someone help me to fix this error please.
Greetings,
Process failed: StatementCallback; bad SQL grammar [create table
_categorystructure_temp (categoryoptioncomboid integer not null,
categoryoptioncomboname varchar(255), "Idade (≤15; 15-24; ≥25)" varchar(230),
"Kdq06ujoVjk" chara
Hi Norberto,
You have a special character " in your metadata.Look at this "Programa de
Rádio "QUERO VIDA""
Alex
2018-04-06 12:33 GMT+03:00 Norberto Banze :
> Hi devs,
>
> Can someone help me to fix this error please.
>
> Greetings,
>
> Process failed: StatementCallback; bad SQL grammar [create
Hi there,
what is your DHIS 2 version?
It seems this problem comes from lack of encoding of category names in the
SQL (you have double quotes in one of you category name here: "Programa de
Rádio "QUERO VIDA" 1" ).
As a quick fix, rename that category without using double quotes (single
quotes ar
Hi Lars,
My version is 2.27.
I will try that fix.
Thanks so much
From: Lars Helge Øverland
Sent: Friday, April 6, 2018 11:40 AM
To: Norberto Banze
Cc: dhis2-devs
Subject: Re: [Dhis2-devs] Error generating resource tables
Hi there,
what is your DHIS 2 version?
We have fixed this in master now. Let us know if the work-around was okay.
Lars
2018-04-06 11:43 GMT+02:00 Norberto Banze :
> Hi Lars,
>
> My version is 2.27.
>
> I will try that fix.
>
> Thanks so much
> --
> *From:* Lars Helge Øverland
> *Sent:* Friday, April 6, 2
Hi again,
I have renamed the category and removed the quotes but the problem persists.
Process failed: StatementCallback; bad SQL grammar [create table
_categorystructure_temp (categoryoptioncomboid integer not null,
categoryoptioncomboname varchar(255), "Idade (≤15; 15-24; ≥25)" varchar(230),
>From the SQL it seems you still have two categories with quotes (could also
be org unit group sets or data element group sets):
Programa de Rádio "QUERO VIDA"
Programa de Rádio "QUERO VIDA" 1
2018-04-06 12:29 GMT+02:00 Norberto Banze :
> Hi again,
>
> I have renamed the category and rem
Hi Calle,
it seems there is an invalid program indicator filter in there which trips
up the check.
Have a look at your program indicator filters e.g. with this API request:
/api/programIndicators.json?fields=id,name,filter&paging=false
and look for anomalies, i.e. a filter with just an "A" or s
Lars,
There are no filters like that - BUT there are a few program indicators
with no filter values at all. Is that illegal, for some reason? (at least
in terms of the integrity checks)
Regards
Calle
On 6 April 2018 at 12:36, Lars Helge Øverland wrote:
> Hi Calle,
>
> it seems there is an inva
Thanks so much,
Found, renamed and fixed now.
Greetings,
From: Lars Helge Øverland
Sent: Friday, April 6, 2018 12:33 PM
To: Norberto Banze
Cc: dhis2-devs
Subject: Re: [Dhis2-devs] Error generating resource tables
From the SQL it seems you still have two categori
Alright. No filters should be okay.
Perhaps you can save the output of this request and send me so we can have
a closer look:
/api/programIndicators.json?fields=*&paging=false
Lars
On 6 April 2018 at 12:53, Calle Hedberg wrote:
> Lars,
>
> There are no filters like that - BUT there are a f
Great.
2018-04-06 12:43 GMT+02:00 Norberto Banze :
> Thanks so much,
>
> Found, renamed and fixed now.
>
> Greetings,
> --
> *From:* Lars Helge Øverland
> *Sent:* Friday, April 6, 2018 12:33 PM
>
> *To:* Norberto Banze
> *Cc:* dhis2-devs
> *Subject:* Re: [Dhis2-devs]
13 matches
Mail list logo
