Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

siddheshmane
Contributor

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
Honored Contributor III

Re: Error in running SQL query

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
Contributor

Re: Error in running SQL query

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
Contributor II

Re: Error in running SQL query

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

Re: Error in running SQL query

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
Contributor

Re: Error in running SQL query

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.

Community Browser