Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddheshmane
Creator
Creator

Error in running SQL query

Hello everyone,

I need help with this error that i am getting. Please find screenshot of the error attached. This has been occuring since a couple of weeks now. I am connecting to a NAV database.

error.png

Thank you for your help.

Siddhesh Mane.

5 Replies
sasiparupudi1
Master III
Master III

It says too many columns in the query.. may be there is some restriction on the select?/

try commenting some of the columns and see if the error disappears

siddheshmane
Creator
Creator
Author

Hi Sasidhar,

Thanks for helping me out. I am only loading one column "No_" in the select statement. It still gives me this error.

jerifortune
Creator III
Creator III

Could you try another field?  Also try running the select statement on the database.

tamilarasu
Champion
Champion

I am not sure about this but below link explain the reason and fix.

https://support.microsoft.com/mk-mk/help/2534952/the-value-in-the-maxcolsupport-property-of-the-nodb...

siddheshmane
Creator
Creator
Author

The problem is I do not have access to it, It's a Navision ERP database. I also tried a different column. it seems like the error occurs only when i query this table. The other tables when I try querying, it works fine.