topic Re: Error in running SQL query in QlikView

Error in running SQL query

siddheshmane — Wed, 25 Nov 2020 16:16:04 GMT

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.

Thank you for your help.

Siddhesh Mane.

Re: Error in running SQL query

sasiparupudi1 — Mon, 16 Apr 2018 17:49:03 GMT

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

Re: Error in running SQL query

siddheshmane — Mon, 16 Apr 2018 17:54:16 GMT

Hi Sasidhar,

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

Re: Error in running SQL query

jerifortune — Mon, 16 Apr 2018 18:00:10 GMT

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

Re: Error in running SQL query

tamilarasu — Mon, 16 Apr 2018 18:09:21 GMT

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-nodbc-dsn-is-set-to-bla

Re: Error in running SQL query

siddheshmane — Mon, 16 Apr 2018 18:12:51 GMT

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.