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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Script Error

Hi All,

I am getting this error during reload. Does anybody know what might be going wrong here.

This happens both when I reload the app or run it in debug mode.

Qvx file read error on line 1, too many columns: "Name of Table"....

12 Replies
fabian3684386
Contributor III
Contributor III

Turns out for me the issue was only so cryptic (qvx too many columns) because I ran in debug mode, so running via QMC task created better error message (SQL error where casing of columns was not matching to Snowflake database, which I could fix with turning all columns uppercase)

Tool_Tip
Creator III
Creator III

Dear all,

We encountered same error. But as per our analysis the error is with the connector.

When we use OLEDB connection with same database, there is no such error even in debug mode, but when we use ORACLE (Inbuilt) connector with same database, this error encountered.

 

Any suggestion to have permanent fix for this issue?

fabian3684386
Contributor III
Contributor III

@Tool_Tip don't use debug mode, check SQL Database error in QMC download instead

SQL Dialect / ANSI compatibility, & escaping of column names, sometimes " (aws) sometimes ` (databricks) and reserved words in SQL, etc.