← Back to team overview

dhis2-devs team mailing list archive

Re: Error generating resource tables

 

Thanks so much,

Found, renamed and fixed now.

Greetings,
________________________________
From: Lars Helge Øverland <lars@xxxxxxxxx>
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 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 <norbertobanze@xxxxxxxx<mailto:norbertobanze@xxxxxxxx>>:
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  [https://dhis2mz.pathfinder.org/images/error_small.png]

________________________________
From: Norberto Banze <norbertobanze@xxxxxxxx<mailto:norbertobanze@xxxxxxxx>>
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 <lars@xxxxxxxxx<mailto:lars@xxxxxxxxx>>
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 <norbertobanze@xxxxxxxx<mailto:norbertobanze@xxxxxxxx>>:
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  [https://dhis2mz.pathfinder.org/images/error_small.png]
2018-04-06 09:14:47     Generating resource tables



_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp




--
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
lars@xxxxxxxxx<mailto:lars@xxxxxxxxx>
https://www.dhis2.org<https://www.dhis2.org/>




--
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
lars@xxxxxxxxx<mailto:lars@xxxxxxxxx>
https://www.dhis2.org<https://www.dhis2.org/>


Follow ups

References