Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion board where members can learn more about Qlik Sense Data Connectivity.
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!