Re: [Dhis2-devs] Error generating resource tables

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:*

Re: [Dhis2-devs] Integrity check error

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=*=false Lars On 6 April 2018 at 12:53, Calle Hedberg wrote: > Lars, > > There are no filters like that

Re: [Dhis2-devs] Error generating resource tables

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

Re: [Dhis2-devs] Integrity check error

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

Re: [Dhis2-devs] Integrity check error

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=false and look for anomalies, i.e. a filter with just an "A" or

Re: [Dhis2-devs] Error generating resource tables

>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

Re: [Dhis2-devs] Error generating resource tables

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)"

Re: [Dhis2-devs] Error generating resource tables

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

Re: [Dhis2-devs] Error generating resource tables

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

Re: [Dhis2-devs] Error generating resource tables

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

Re: [Dhis2-devs] Error generating resource tables

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:

[Dhis2-devs] Error generating resource tables

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"

[Dhis2-devs] Integrity check error

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