Connectivity & Data Prep

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

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this topic

danielbm
Contributor
Contributor

Qvx file read error on line 1, too many columns

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!

Labels (1)
Who Me Too'd this topic