Olá!

Estamos enfrentando dificuldade para utilizar o Gerenciador de Contratos, o qual está reportando erro ao tentar cadastrar um novo contrato.

O stacktrace gerado nos logs do servidor indica um erro na consulta abaixo:

SELECT FORMULAOS.IDFORMULAOS Val_1, FORMULAOS.DESCRICAO Fld_1 FROM FORMULAOS WHERE (situacao=A) ORDER BY FORMULAOS.DESCRICAO
Segue o erro reportado: 
ERROR: column "a" does not exist at character 94 

Analisando a consulta observamos que falta as aspas na clausula WHERE (situacao=A). Segue a correção:

SELECT FORMULAOS.IDFORMULAOS Val_1, FORMULAOS.DESCRICAO Fld_1 FROM FORMULAOS WHERE (situacao='A') ORDER BY FORMULAOS.DESCRICAO

Fizemos uma busca nos logs do banco de dados e encontramos outros logs similares, ou seja, existem outros pontos do sistema gerando o mesmo erro:

2015-01-12 00:48:10 BRST ERROR:  column "a" does not exist at character 94
2015-01-12 00:48:10 BRST STATEMENT:  SELECT FORMULAOS.IDFORMULAOS Val_1, FORMULAOS.DESCRICAO Fld_1 FROM FORMULAOS WHERE (situacao=A) ORDER BY FORMULAOS.DESCRICAO
2015-01-12 00:49:11 BRST ERROR:  column "a" does not exist at character 110
2015-01-12 00:49:11 BRST STATEMENT:  SELECT TIPOSERVICO.IDTIPOSERVICO Val_1, TIPOSERVICO.NOMETIPOSERVICO Fld_1 FROM TIPOSERVICO WHERE (SITUACAO = A) ORDER BY TIPOSERVICO.NOMETIPOSERVICO
2015-01-12 00:49:11 BRST ERROR:  column "a" does not exist at character 145
2015-01-12 00:49:11 BRST STATEMENT:  SELECT IMPORTANCIANEGOCIO.IDIMPORTANCIANEGOCIO Val_1, IMPORTANCIANEGOCIO.NOMEIMPORTANCIANEGOCIO Fld_1 FROM IMPORTANCIANEGOCIO WHERE (SITUACAO = A)  ORDER BY IMPORTANCIANEGOCIO.NOMEIMPORTANCIANEGOCIO
2015-01-12 00:49:11 BRST ERROR:  column "n" does not exist at character 158
2015-01-12 00:49:11 BRST STATEMENT:  SELECT TIPOEVENTOSERVICO.IDTIPOEVENTOSERVICO Val_1, TIPOEVENTOSERVICO.NOMETIPOEVENTOSERVICO Fld_1 FROM TIPOEVENTOSERVICO WHERE (deleted IS NULL OR deleted = N) ORDER BY TIPOEVENTOSERVICO.NOMETIPOEVENTOSERVICO
2015-01-12 00:49:12 BRST ERROR:  syntax error at or near "Y" at character 150
2015-01-12 00:49:12 BRST STATEMENT:  SELECT TIPODEMANDASERVICO.IDTIPODEMANDASERVICO Val_1, TIPODEMANDASERVICO.NOMETIPODEMANDASERVICO Fld_1 FROM TIPODEMANDASERVICO WHERE (UPPER(DELETED)  Y OR UPPER(DELETED) IS NULL)  ORDER BY TIPODEMANDASERVICO.NOMETIPODEMANDASERVICO
2015-01-12 00:49:12 BRST ERROR:  column "n" does not exist at character 173
2015-01-12 00:49:12 BRST STATEMENT:  SELECT LOCALEXECUCAOSERVICO.IDLOCALEXECUCAOSERVICO Val_1, LOCALEXECUCAOSERVICO.NOMELOCALEXECUCAOSERVICO Fld_1 FROM LOCALEXECUCAOSERVICO WHERE (deleted IS NULL OR deleted = N ) ORDER BY LOCALEXECUCAOSERVICO.NOMELOCALEXECUCAOSERVICO

Segue as informações do nosso ambiente (observem que estamos utilizando a última versão disponível):

Sistema Operacional: Ubuntu Server 12.04 (Debian 7 based)
Citsmart: VC3R16.21 
JBoss: JBoss AS 7.1.1
BD: Postgres 9.1 (+129ubuntu1)

Autor: Luiz Henrique Coura