Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Lars Helge Øverland 
Great.

2018-04-06 12:43 GMT+02:00 Norberto Banze <norbertoba...@live.com>:

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

Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Norberto Banze 
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 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<mailto: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), "J

Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Lars Helge Øverland 
çã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,

Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Norberto Banze 
0-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 <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<mailto: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(23

Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Lars Helge Øverland 
We have fixed this in master now. Let us know if the work-around was okay.

Lars


2018-04-06 11:43 GMT+02:00 Norberto Banze <norbertoba...@live.com>:

> 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), "Gr

Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Norberto Banze 
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<mailto: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 (treina

Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Lars Helge Øverland 
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 :

> 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

Re: [Dhis2-devs] Error generating resource tables

2018-04-06 Thread Alex Tumwesigye 
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 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"

[Dhis2-devs] Error generating resource tables

2018-04-06 Thread Norberto Banze 
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),

Re: [Dhis2-devs] Error generating resource tables

2013-01-29 Thread Hieu Dang Duy 
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 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?


 Hieu has made a fix, let us know if it's working properly on your side..

 Lars



Excuse me, Lars. What fixed that you are mentioning in this thread?

If you are talking about this Error generating resource tables then I
remember that I've just brought up to you an idea is that We should check
if one of resource tables is not existing and following on two different
ways:

Generating all of them automatically or Alerting and redirecting user to
the Resource 
Tableshttp://domain_context_name/dhis-web-maintenance-dataadmin/displayResourceTableForm.actionpage

P.S: I think we can get back to this thread *[Bug 909624] [NEW] Resource
Tables are not generated*

-- 
*Expert By Chance*
___
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

Re: [Dhis2-devs] Error generating resource tables

2013-01-28 Thread Lars Helge Øverland 
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
 views to prevent this from happening?


Hieu has made a fix, let us know if it's working properly on your side..

Lars
___
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

Re: [Dhis2-devs] Error generating resource tables

2013-01-26 Thread Lars Helge Øverland 
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 at 6:12 AM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Using latest 2.10 build and getting this when attempting to generate
 _categorystructure table.

 Any ideas?

 Regards,
 Jason


 * INFO  2013-01-26 15:10:24,207 Login success for user: 'jpickering',
 ip: '127.0.0.1' (DefaultUserAuditService.java [http-bio-8080-exec-4])
 * INFO  2013-01-26 15:10:41,239 Dropped all sql views
 (GenerateResourceTableAction.java [http-bio-8080-exec-6])
 * INFO  2013-01-26 15:10:41,285 Create category structure table SQL:
 CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT
 NULL, categoryoptioncomboname VARCHAR (250),
 _05mths611mths1217mths1823mths VARCHAR (250), cat_67 INTEGER,
 _lt_15yrs1519yrs2024yrs2529yrs3034yrs35yrs VARCHAR (250), cat_69
 INTEGER, _lt_1yr14yrs514yrs1549yrs50yrs VARCHAR (250), cat_68 INTEGER,
 clinic_locationvillage_location VARCHAR (250), cat_70 INTEGER,
 _default VARCHAR (250), cat_14 INTEGER,
 first_vaccinesecond_vaccinethird_vaccine VARCHAR (250), cat_71
 INTEGER,
 hp_activity_1hp_activity_2hp_activity_3hp_activity_4hp_activity_5hp_activity_6hp_activity_7hp_activity_8
 VARCHAR (250), cat_72 INTEGER, in_clinicon_tour VARCHAR (250), cat_73
 INTEGER, live_birthstill_birth VARCHAR (250), cat_74 INTEGER,
 malefemale VARCHAR (250), cat_75 INTEGER,
 nurse_or_nurse_aide_commentssupervisor_comments VARCHAR (250), cat_76
 INTEGER, rhcahcprovincenrh VARCHAR (250), cat_77 INTEGER, PRIMARY KEY
 ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java
 [http-bio-8080-exec-6])
 * INFO  2013-01-26 15:10:41,535 Generated resource tables
 (GenerateResourceTableAction.java [http-bio-8080-exec-6])
 * WARN  2013-01-26 15:10:41,560 SQL Error: 0, SQLState: 42701
 (SqlExceptionHelper.java [http-bio-8080-exec-6])
 * ERROR 2013-01-26 15:10:41,561 ERROR: column categoryoptioncomboid
 specified more than once (SqlExceptionHelper.java
 [http-bio-8080-exec-6])
 * ERROR 2013-01-26 15:10:41,569 Error while executing action
 (ExceptionInterceptor.java [http-bio-8080-exec-6])
 org.hibernate.exception.SQLGrammarException: ERROR: column
 categoryoptioncomboid specified more than once
 at
 org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
 at
 org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
 at
 org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
 at
 org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
 at
 org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
 at
 org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
 at $Proxy149.execute(Unknown Source)
 at
 org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
 at
 org.hisp.dhis.sqlview.jdbc.JdbcSqlViewExpandStore.createView(JdbcSqlViewExpandStore.java:128)
 at
 org.hisp.dhis.sqlview.DefaultSqlViewService.createViewTable(DefaultSqlViewService.java:168)
 at
 org.hisp.dhis.sqlview.DefaultSqlViewService.createAllViewTables(DefaultSqlViewService.java:156)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:616)
 at
 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
 at
 org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 at
 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 at
 org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 at
 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at
 org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 at $Proxy98.createAllViewTables(Unknown Source)
 at
 org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(GenerateResourceTableAction.java:165)
 at

Re: [Dhis2-devs] Error generating resource tables

2013-01-26 Thread Jason Pickering 
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
larshe...@gmail.comwrote:

 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 at 6:12 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Using latest 2.10 build and getting this when attempting to generate
 _categorystructure table.

 Any ideas?

 Regards,
 Jason


 * INFO  2013-01-26 15:10:24,207 Login success for user: 'jpickering',
 ip: '127.0.0.1' (DefaultUserAuditService.java [http-bio-8080-exec-4])
 * INFO  2013-01-26 15:10:41,239 Dropped all sql views
 (GenerateResourceTableAction.java [http-bio-8080-exec-6])
 * INFO  2013-01-26 15:10:41,285 Create category structure table SQL:
 CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT
 NULL, categoryoptioncomboname VARCHAR (250),
 _05mths611mths1217mths1823mths VARCHAR (250), cat_67 INTEGER,
 _lt_15yrs1519yrs2024yrs2529yrs3034yrs35yrs VARCHAR (250), cat_69
 INTEGER, _lt_1yr14yrs514yrs1549yrs50yrs VARCHAR (250), cat_68 INTEGER,
 clinic_locationvillage_location VARCHAR (250), cat_70 INTEGER,
 _default VARCHAR (250), cat_14 INTEGER,
 first_vaccinesecond_vaccinethird_vaccine VARCHAR (250), cat_71
 INTEGER,
 hp_activity_1hp_activity_2hp_activity_3hp_activity_4hp_activity_5hp_activity_6hp_activity_7hp_activity_8
 VARCHAR (250), cat_72 INTEGER, in_clinicon_tour VARCHAR (250), cat_73
 INTEGER, live_birthstill_birth VARCHAR (250), cat_74 INTEGER,
 malefemale VARCHAR (250), cat_75 INTEGER,
 nurse_or_nurse_aide_commentssupervisor_comments VARCHAR (250), cat_76
 INTEGER, rhcahcprovincenrh VARCHAR (250), cat_77 INTEGER, PRIMARY KEY
 ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java
 [http-bio-8080-exec-6])
 * INFO  2013-01-26 15:10:41,535 Generated resource tables
 (GenerateResourceTableAction.java [http-bio-8080-exec-6])
 * WARN  2013-01-26 15:10:41,560 SQL Error: 0, SQLState: 42701
 (SqlExceptionHelper.java [http-bio-8080-exec-6])
 * ERROR 2013-01-26 15:10:41,561 ERROR: column categoryoptioncomboid
 specified more than once (SqlExceptionHelper.java
 [http-bio-8080-exec-6])
 * ERROR 2013-01-26 15:10:41,569 Error while executing action
 (ExceptionInterceptor.java [http-bio-8080-exec-6])
 org.hibernate.exception.SQLGrammarException: ERROR: column
 categoryoptioncomboid specified more than once
 at
 org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
 at
 org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
 at
 org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
 at
 org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
 at
 org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
 at
 org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
 at $Proxy149.execute(Unknown Source)
 at
 org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
 at
 org.hisp.dhis.sqlview.jdbc.JdbcSqlViewExpandStore.createView(JdbcSqlViewExpandStore.java:128)
 at
 org.hisp.dhis.sqlview.DefaultSqlViewService.createViewTable(DefaultSqlViewService.java:168)
 at
 org.hisp.dhis.sqlview.DefaultSqlViewService.createAllViewTables(DefaultSqlViewService.java:156)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:616)
 at
 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
 at
 org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 at
 org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 at
 org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 at