← Back to team overview

dhis2-devs team mailing list archive

Re: Error generating resource tables

 

Great.

2018-04-06 12:43 GMT+02:00 Norberto Banze <norbertobanze@xxxxxxxx>:

> 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>:
>
> 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 <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>
> *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>:
>
> 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@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
> https://www.dhis2.org
>
>
>
>
> --
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> lars@xxxxxxxxx
> https://www.dhis2.org
>
>


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

References