Re: [Dhis2-devs] Error generating resource tables

230), > "HySAKxTrldw" character(11), "Programa de Rádio "QUERO VIDA" 1" > varchar(230), "Dq4zcZXsvUa" character(11), "Rapazes e Raparigas" > varchar(230), "ifeqAZ6jGj7" character(11), "Juntas- Tipo de participantes > ES" varchar(230), &

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 have two

Re: [Dhis2-devs] Error generating resource tables

, "Rapazes e Raparigas" > varchar(230), "ifeqAZ6jGj7" character(11), "Juntas- Tipo de participantes > ES" varchar(230), "shtog5J11rv" character(11), "Juntas - Língua do SPOT > Publicado" varchar(230), "SQjf885Ec5H" charact

Re: [Dhis2-devs] Error generating resource tables

H" character(11), "Juntas - # De programas Emitidos" varchar(230), "AOaPokeLCVa" character(11), "Juntas - Tipo de participantes EE" varchar(230), "bSRWsL5IlFQ" character(11), "Idades (<10, 10-14,15-19, >19)" varchar(230)

Re: [Dhis2-devs] Error generating resource tables

> *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? > > It seems this problem comes from lack of encoding of category names in

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 DHIS 2 version

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 ar

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: StatementCallback; bad SQL grammar [create

[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" chara

Re: [Dhis2-devs] Error generating resource tables

Hi all, On Tue, Jan 29, 2013 at 2:59 PM, Lars Helge Øverland wrote: > > > On Sat, Jan 26, 2013 at 2:44 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Lars, >> You are right. The resource tables generated OK. >> >> In fact, it was this bug

Re: [Dhis2-devs] Error generating resource tables

On Sat, Jan 26, 2013 at 2:44 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Lars, > You are right. The resource tables generated OK. > > In fact, it was this bug (?) > which caused the problem. I think we need to put some check on the

Re: [Dhis2-devs] Error generating resource tables

Hi Lars, You are right. The resource tables generated OK. In fact, it was this bug (?) which caused the problem. I think we need to put some check on the SQL views to prevent this from happening? On Sat, Jan 26, 2013 at 11:09 AM, Lars Helge Øverlan

Re: [Dhis2-devs] Error generating resource tables

Hi Jason, it seems like the resource tables are generated okay. After that step, all of your (dhis) SQL views will be re-generated. I suspect its one of those which are failing. Try to run all of your SQL views independently and see if that will trigger an exception. Lars On Sat, Jan 26, 2013