Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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