Qvx file read error on line 1, too many columns

danielbm — Tue, 25 May 2021 14:43:10 GMT

Hi!

I'm getting this error when loading two tables of the same database:

Qvx file read error on line 1, too many columns: [tblDotacaoSemItem]: SELECT "Cd_Dotacao_Id", "Sigla_Orgao" FROM "sf8416_financas".dbo.tblDotacaoSemItem

The load script is quite simple:

LIB CONNECT TO 'SQL03'; LOAD Cd_Dotacao_Id; [tblDotacaoComItem]: SELECT "Cd_Dotacao_Id" FROM "sf8416_financas".dbo.tblDotacaoComItem; LOAD Cd_Dotacao_Id, Sigla_Orgao; [tblDotacaoSemItem]: SELECT "Cd_Dotacao_Id", "Sigla_Orgao" FROM "sf8416_financas".dbo.tblDotacaoSemItem;

If I only load one table, the script runs fine, but whenever I join any two tables, I get this error.

The other posts on the forum say that it might be a DB performance issue, but the DB is ok, I can run the queries outside Qlik Sense, and the error also happens in debug mode with row limitation.

Thanks!

topic Qvx file read error on line 1, too many columns in Connectivity & Data Prep

Qvx file read error on line 1, too many columns