Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
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)
0 Replies