Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Conexão ODBC falhou - value is too big

Hello Everybody,

I'm exploring Qlik view in my work, and I am finding some  problems with two situations: I'm using a ODBC connection to a caché database. When I try to get a column named NotaFiscalItem.vlrICMS (NUMER) or Item.nome (STRING).

When I reload, I receive this message:

Conexão ODBC falhou

SQL SELECT

  NotaFiscal.codEmpresa,

  NotaFiscal.numero,

  NotaFiscal.codRepresentante,

  NotaFiscal.prazoMedio,

  NotaFiscal.vlrICMS,

  NotaFiscal.vlrICMSSubstit,

  NotaFiscal.vlrIPI,

  NotaFiscal.vlrLiquido,

  NotaFiscal.vlrTotal,

  NotaFiscal.codCliente,

  Representante.nome,

  NotaFiscalItem.codNatOperacao,

  NotaFiscalItem.qtdeFaturada,

  NotaFiscalItem.precoUnitario,

  NotaFiscalItem.vlrPISProp,

  NotaFiscalItem.vlrCOFINSProp,

NotaFiscalItem.vlrICMS,

NotaFiscalItem.vlrIPI,

  NotaFiscalItem.vlrICMSSubstituto,

    NotaFiscalComp1.pesoBruto,

  NotaFiscalComp1.pesoLiquido,

  NotaFiscalComp1.qtdeVolumes,

  NotaFiscalComp1.codTransportadora,

  Item.codigo,

Item.nome

FROM Esv.Cliente Cliente,

Cgi.Item Item,

Fat.NotaFiscal NotaFiscal,

Fat.NotaFiscalComp1 NotaFiscalComp1,

Fat.NotaFiscalItem NotaFiscalItem,

Fat.NotaFiscalProdItem NotaFiscalProdItem,

Fat.Representante Representante

WHERE Cliente.codCliente = NotaFiscal.codCliente

AND Cliente.codEmpresa = NotaFiscal.codEmpresa

AND Representante.codEmpresa = Cliente.codEmpresa

AND Representante.codEmpresa = NotaFiscal.codEmpresa

AND Representante.codRepresent = NotaFiscal.codRepresentante

AND NotaFiscalProdItem.codEmpresa = Cliente.codEmpresa

AND NotaFiscalProdItem.codEmpresa = NotaFiscal.codEmpresa

AND NotaFiscalProdItem.codEmpresa = Representante.codEmpresa

AND NotaFiscalProdItem.dataEmissao = NotaFiscal.dataEmissao

AND NotaFiscalProdItem.numero = NotaFiscal.numero

AND Item.codigo = NotaFiscalProdItem.codProduto

AND NotaFiscalItem.codEmpresa = Cliente.codEmpresa

AND NotaFiscalItem.codEmpresa = NotaFiscal.codEmpresa

AND NotaFiscalItem.codEmpresa = NotaFiscalProdItem.codEmpresa

AND NotaFiscalItem.codEmpresa = Representante.codEmpresa

AND NotaFiscalItem.codItem = NotaFiscalProdItem.codItem

AND NotaFiscalItem.dataEmissao = NotaFiscal.dataEmissao

AND NotaFiscalItem.dataEmissao = NotaFiscalProdItem.dataEmissao

AND NotaFiscalItem.numero = NotaFiscal.numero

AND NotaFiscalItem.numero = NotaFiscalProdItem.numero

AND NotaFiscalItem.codProduto = NotaFiscalProdItem.codProduto

AND NotaFiscalComp1.codEmpresa = Cliente.codEmpresa

AND NotaFiscalComp1.codEmpresa = NotaFiscal.codEmpresa

AND NotaFiscalComp1.codEmpresa = NotaFiscalItem.codEmpresa

AND NotaFiscalComp1.codEmpresa = NotaFiscalProdItem.codEmpresa

AND NotaFiscalComp1.codEmpresa = Representante.codEmpresa

AND NotaFiscalComp1.dataEmissao = NotaFiscal.dataEmissao

AND NotaFiscalComp1.dataEmissao = NotaFiscalItem.dataEmissao

AND NotaFiscalComp1.dataEmissao = NotaFiscalProdItem.dataEmissao

AND NotaFiscalComp1.numero = NotaFiscal.numero

AND NotaFiscalComp1.numero = NotaFiscalItem.numero

AND NotaFiscalComp1.numero = NotaFiscalProdItem.numero

I tried to use the function Num(NotaFiscalItem.vlrICMS, '#0.00'), or Round(NotaFiscalItem.vlrICMS, 0.01) without success. With the String column I even tryed because I didn't find any information...

Tks for while!

Community Browser