>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 <norbertoba...@live.com>: > 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), "Kdq06ujoVjk" character(11), "Tipo de atividade" > varchar(230), "dqmhOZRR1We" character(11), "Tipo de violencia" > varchar(230), "SDCIwEAv5q1" character(11), "Age (<25;>25)" varchar(230), > "KthWpj6XFsv" character(11), "LAD NGOs" varchar(230), "ZBP48mQKg6r" > character(11), "FP method MOH" varchar(230), "bwDFJ7BVBa8" character(11), > "Users (new, continuing)" varchar(230), "zQ4fymseujg" character(11), > "Genero" varchar(230), "LU1SkoVajKM" character(11), "Age (19 and under; > 20-24; 25 and older)" varchar(230), "d2Z7ul5F8lI" character(11), "LAPM > User" varchar(230), "i8gdgOhke8r" character(11), "Method (LAD)" > varchar(230), "nskyfRjHsLK" character(11), "ServiceType" varchar(230), > "AYrc1nzk9ku" character(11), "Idade (<15; >15)" varchar(230), "L5SItJnA90a" > character(11), "Staff (APEs;Parteira tradicional;Agente IPC;Facilitadores)" > varchar(230), "mDua3TWXHOu" character(11), "Ficha 8 (15-24, 25-35, 35+ > anos)" varchar(230), "MkkZc2vFk79" character(11), "Age (<15,15-19,>24)" > varchar(230), "FY7hjxPiryF" character(11), "CHW_Categories" varchar(230), > "uyx6rcERB1Q" character(11), "Quality_Standards" varchar(230), > "BxnAMrbTSj4" character(11), "Method (IUD, Other)" varchar(230), > "WgNivmavzdw" character(11), "Family Planning Methords" varchar(230), > "rn3bn4Xr24E" character(11), "Homens e Mulheres" varchar(230), > "CoVw9YvXK0b" character(11), "APEs methods (pills,injectales,Fcondom,Mcondom)" > varchar(230), "ZgjySG9J1ut" character(11), "FP method MOH + PPIUD" > varchar(230), "caJWFD9Biaf" character(11), "PPIUD & Other" varchar(230), > "qfuqF0leQny" character(11), "US apoiadas pelo projecto (Us treinadas_PF, > US espera apoio_projecto)" varchar(230), "f5EpxoNkbud" character(11), "ACS > (PT/TBA,IPC Agent)" varchar(230), "pUnJv1QcYEV" character(11), "ACS (all)" > varchar(230), "ou7FvcTvdDF" character(11), "ACS (APE,PT,IPC,Fcomunitário)" > varchar(230), "XvL6PqCqGAj" character(11), "ACS (facilitadores,agentes > IPC,PTS/TBA)" varchar(230), "XJSUSXGp12J" character(11), "LAD-ASS-Salas de > atendimento" varchar(230), "rSA00TxXzOj" character(11), "Categorias > profissionais na US" varchar(230), "tjVDq3bYdae" character(11), "Testagem > (Positivo, negativo)" varchar(230), "JiKUG3WTsHh" character(11), "Nome de > supervisor" varchar(230), "A7r2Ln1aUOI" character(11), "Aborto médico e > aspiração intra-uterina" varchar(230), "jj690P3iicJ" character(11), > "Pilula, depo, implante, DIU" varchar(230), "sPlBZfJAeW2" character(11), > "Pilula, depo, implante, diu, p.masculino, p.feminino e emergencia" > varchar(230), "EXkWewDdHEG" character(11), "Nome do Par" varchar(230), > "bndhLVshe8J" character(11), "Grupo2 etário (10-14,15-19,20-24, >25)" > varchar(230), "fQfRpHa05JB" character(11), "Grupo3 etário > (<10,10-14,15-19,20-24, >25)" varchar(230), "Ux7HO1greCy" character(11), > "Vias testadas e positivas" varchar(230), "PgpFaYgZdU9" character(11), > "Feminino" varchar(230), "CDFZgDPtkSt" character(11), "Grupo etário > (10-14,15-19,20-24)" varchar(230), "V5PsLxSoF68" character(11), "Género" > varchar(230), "nhTRT31WJDA" character(11), "Provedores > (treinados,completaram)" varchar(230), "HosXrX4HX0J" character(11), "JUNTAS > (dentro, fora)" varchar(230), "JNdkdsPqfzd" character(11), "JUNTAS (Geral, > Sexualidade, ITS/HIV/SIDA, Contracepção)" varchar(230), "mQlTybYKrob" > character(11), "JUNTAS_Diagnóstico" varchar(230), "FXNomXmYwDs" > character(11), "Masculino e feminino" varchar(230), "hNokUJLD8cQ" > character(11), "JUNTAS - Nr de grupos e participantes" varchar(230), > "fdqeMRYklLp" character(11), "Tipos de violência" varchar(230), > "oWht4qXBWzo" character(11), "Preservativos" varchar(230), "ANs3RhPHmmG" > character(11), "Idades (10-14,15-19, >19)" varchar(230), "HgyNiJmUwpq" > character(11), "Grupo etário (10-14,15-19)" varchar(230), "g5pexYgVjMI" > character(11), "Nome - Activista escolar" varchar(230), "ZtFRPLoRiNU" > character(11), "Linhas de inserção de dados" varchar(230), "FdiamoDTNk6" > character(11), "Quero - Referência feita ES" varchar(230), "NWewoFlzaKN" > character(11), "Quero - Tipo de participantes ES" varchar(230), > "JBL5ONo06wI" character(11), "Publicação de Spot's " varchar(230), > "i4Miq6JdOqO" character(11), "Língua do SPOT Publicado" varchar(230), > "TJfZ8NVsxr9" character(11), "# De programas Emitidos" varchar(230), > "USUHznXcT5F" character(11), "Programa de Rádio "QUERO VIDA"" varchar(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), "shtog5J11rv" character(11), "Juntas - Língua do SPOT > Publicado" varchar(230), "SQjf885Ec5H" 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" character(11), > "Juntas - Tipo de Crime/Caso" varchar(230), "Snjzk4gC81t" character(11), > "Juntas - Encaminhados da:" varchar(230), "IlbJ7canGDx" character(11), > "Juntas - Encaminhamento para:" varchar(230), "UIkWzw9bDqc" character(11), > "Pontuação CPC" varchar(230), "d4fHDWhFCjI" character(11), "Resultado do > Teste HIV" varchar(230), "qaydV342x3u" character(11), "Tipos de violência > 2" varchar(230), "JYtTPHChi6H" character(11), "Faixa (0-11 m,1-4 A,5-9 > A,10-14 A,15-19 A,20-24 A,25-49 A,50-54 A,55- 59 A,+ 60 A)" varchar(230), > "XvJu6JYLJq7" character(11), "Vitimas de violência sexual que receberam > cuidados Iniciais Pós VBG" varchar(230), "Tw3U3BJNnKQ" character(11), " > Vitimas - outras formas de VBG (Fisica, Outros) que receberam cuidados > iniciais pós VBG" varchar(230), "sstXoDUagAh" character(11), "Líderes > comunitários" varchar(230), "LZKfGaQ7EJg" character(11), "default" > varchar(230), "AIyKLYwYxfK" character(11), primary key > (categoryoptioncomboid))]; nested exception is > org.postgresql.util.PSQLException: > ERROR: syntax error at or near "VIDA" Position: 4403 > > ------------------------------ > *From:* Norberto Banze <norbertoba...@live.com> > *Sent:* Friday, April 6, 2018 11:43 AM > *To:* Lars Helge Øverland > > *Cc:* dhis2-devs > *Subject:* 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 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 are fine). Will work on a proper fix. > > regards, > > Lars > > > 2018-04-06 11:33 GMT+02:00 Norberto Banze <norbertoba...@live.com>: > > 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" character(11), "Tipo de atividade" > varchar(230), "dqmhOZRR1We" character(11), "Tipo de violencia" > varchar(230), "SDCIwEAv5q1" character(11), "Age (<25;>25)" varchar(230), > "KthWpj6XFsv" character(11), "LAD NGOs" varchar(230), "ZBP48mQKg6r" > character(11), "FP method MOH" varchar(230), "bwDFJ7BVBa8" character(11), > "Users (new, continuing)" varchar(230), "zQ4fymseujg" character(11), > "Genero" varchar(230), "LU1SkoVajKM" character(11), "Age (19 and under; > 20-24; 25 and older)" varchar(230), "d2Z7ul5F8lI" character(11), "LAPM > User" varchar(230), "i8gdgOhke8r" character(11), "Method (LAD)" > varchar(230), "nskyfRjHsLK" character(11), "ServiceType" varchar(230), > "AYrc1nzk9ku" character(11), "Idade (<15; >15)" varchar(230), "L5SItJnA90a" > character(11), "Staff (APEs;Parteira tradicional;Agente IPC;Facilitadores)" > varchar(230), "mDua3TWXHOu" character(11), "Ficha 8 (15-24, 25-35, 35+ > anos)" varchar(230), "MkkZc2vFk79" character(11), "Age (<15,15-19,>24)" > varchar(230), "FY7hjxPiryF" character(11), "CHW_Categories" varchar(230), > "uyx6rcERB1Q" character(11), "Quality_Standards" varchar(230), > "BxnAMrbTSj4" character(11), "Method (IUD, Other)" varchar(230), > "WgNivmavzdw" character(11), "Family Planning Methords" varchar(230), > "rn3bn4Xr24E" character(11), "Homens e Mulheres" varchar(230), > "CoVw9YvXK0b" character(11), "APEs methods (pills,injectales,Fcondom,Mcondom)" > varchar(230), "ZgjySG9J1ut" character(11), "FP method MOH + PPIUD" > varchar(230), "caJWFD9Biaf" character(11), "PPIUD & Other" varchar(230), > "qfuqF0leQny" character(11), "US apoiadas pelo projecto (Us treinadas_PF, > US espera apoio_projecto)" varchar(230), "f5EpxoNkbud" character(11), "ACS > (PT/TBA,IPC Agent)" varchar(230), "pUnJv1QcYEV" character(11), "ACS (all)" > varchar(230), "ou7FvcTvdDF" character(11), "ACS (APE,PT,IPC,Fcomunitário)" > varchar(230), "XvL6PqCqGAj" character(11), "ACS (facilitadores,agentes > IPC,PTS/TBA)" varchar(230), "XJSUSXGp12J" character(11), "LAD-ASS-Salas de > atendimento" varchar(230), "rSA00TxXzOj" character(11), "Categorias > profissionais na US" varchar(230), "tjVDq3bYdae" character(11), "Testagem > (Positivo, negativo)" varchar(230), "JiKUG3WTsHh" character(11), "Nome de > supervisor" varchar(230), "A7r2Ln1aUOI" character(11), "Aborto médico e > aspiração intra-uterina" varchar(230), "jj690P3iicJ" character(11), > "Pilula, depo, implante, DIU" varchar(230), "sPlBZfJAeW2" character(11), > "Pilula, depo, implante, diu, p.masculino, p.feminino e emergencia" > varchar(230), "EXkWewDdHEG" character(11), "Nome do Par" varchar(230), > "bndhLVshe8J" character(11), "Grupo2 etário (10-14,15-19,20-24, >25)" > varchar(230), "fQfRpHa05JB" character(11), "Grupo3 etário > (<10,10-14,15-19,20-24, >25)" varchar(230), "Ux7HO1greCy" character(11), > "Vias testadas e positivas" varchar(230), "PgpFaYgZdU9" character(11), > "Feminino" varchar(230), "CDFZgDPtkSt" character(11), "Grupo etário > (10-14,15-19,20-24)" varchar(230), "V5PsLxSoF68" character(11), "Género" > varchar(230), "nhTRT31WJDA" character(11), "Provedores > (treinados,completaram)" varchar(230), "HosXrX4HX0J" character(11), "JUNTAS > (dentro, fora)" varchar(230), "JNdkdsPqfzd" character(11), "JUNTAS (Geral, > Sexualidade, ITS/HIV/SIDA, Contracepção)" varchar(230), "mQlTybYKrob" > character(11), "JUNTAS_Diagnóstico" varchar(230), "FXNomXmYwDs" > character(11), "Masculino e feminino" varchar(230), "hNokUJLD8cQ" > character(11), "JUNTAS - Nr de grupos e participantes" varchar(230), > "fdqeMRYklLp" character(11), "Tipos de violência" varchar(230), > "oWht4qXBWzo" character(11), "Preservativos" varchar(230), "ANs3RhPHmmG" > character(11), "Idades (10-14,15-19, >19)" varchar(230), "HgyNiJmUwpq" > character(11), "Grupo etário (10-14,15-19)" varchar(230), "g5pexYgVjMI" > character(11), "Nome - Activista escolar" varchar(230), "ZtFRPLoRiNU" > character(11), "Linhas de inserção de dados" varchar(230), "FdiamoDTNk6" > character(11), "Quero - Referência feita ES" varchar(230), "NWewoFlzaKN" > character(11), "Quero - Tipo de participantes ES" varchar(230), > "JBL5ONo06wI" character(11), "Publicação de Spot's " varchar(230), > "i4Miq6JdOqO" character(11), "Língua do SPOT Publicado" varchar(230), > "TJfZ8NVsxr9" character(11), "# De programas Emitidos" varchar(230), > "USUHznXcT5F" character(11), "Programa de Rádio "QUERO VIDA"" varchar(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), "shtog5J11rv" character(11), "Juntas - Língua do SPOT > Publicado" varchar(230), "SQjf885Ec5H" 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" character(11), > "Juntas - Tipo de Crime/Caso" varchar(230), "Snjzk4gC81t" character(11), > "Juntas - Encaminhados da:" varchar(230), "IlbJ7canGDx" character(11), > "Juntas - Encaminhamento para:" varchar(230), "UIkWzw9bDqc" character(11), > "Pontuação CPC" varchar(230), "d4fHDWhFCjI" character(11), "Resultado do > Teste HIV" varchar(230), "qaydV342x3u" character(11), "Tipos de violência > 2" varchar(230), "JYtTPHChi6H" character(11), "Faixa (0-11 m,1-4 A,5-9 > A,10-14 A,15-19 A,20-24 A,25-49 A,50-54 A,55- 59 A,+ 60 A)" varchar(230), > "XvJu6JYLJq7" character(11), "Vitimas de violência sexual que receberam > cuidados Iniciais Pós VBG" varchar(230), "Tw3U3BJNnKQ" character(11), " > Vitimas - outras formas de VBG (Fisica, Outros) que receberam cuidados > iniciais pós VBG" varchar(230), "sstXoDUagAh" character(11), "Líderes > comunitários" varchar(230), "LZKfGaQ7EJg" character(11), "default" > varchar(230), "AIyKLYwYxfK" character(11), primary key > (categoryoptioncomboid))]; nested exception is > org.postgresql.util.PSQLException: ERROR: syntax error at or near "VIDA" > Position: 4403 > 2018-04-06 09:14:47 Generating resource tables > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > -- > Lars Helge Øverland > Technical lead, DHIS 2 > University of Oslo > l...@dhis2.org > https://www.dhis2.org > > -- Lars Helge Øverland Technical lead, DHIS 2 University of Oslo l...@dhis2.org https://www.dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
