Re: [Dhis2-devs] Error generating resource tables

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 categories with quotes (could > also be org unit group sets or data element group sets): > > Pr

Re: [Dhis2-devs] Error generating resource tables

Thanks so much, Found, renamed and fixed now. Greetings, From: Lars Helge Øverland <l...@dhis2.org> 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

Re: [Dhis2-devs] Error generating resource tables

svUa" character(11), "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), "SQjf885

Re: [Dhis2-devs] Error generating resource tables

t; 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), "VF13qWuqTJ2"

Re: [Dhis2-devs] Error generating resource tables

t; *From:* Lars Helge Øverland <l...@dhis2.org> > *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

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 <l...@dhis2.org> 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 i

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"

Re: [Dhis2-devs] Error generating resource tables

Hi all, On Tue, Jan 29, 2013 at 2:59 PM, Lars Helge Øverland larshe...@gmail.comwrote: 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 https://bugs.launchpad.net/dhis2/+bug/1100706 (?) which caused the problem. I think we need to put some check on the SQL

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

Re: [Dhis2-devs] Error generating resource tables

Hi Lars, You are right. The resource tables generated OK. In fact, it was this bug https://bugs.launchpad.net/dhis2/+bug/1100706 (?) 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 Øverland