topic Re: [ODBC Driver 13 for SQL Server][SQL Server]The query has been canceled because the estimated cost of this query (3066) in QlikView

[ODBC Driver 13 for SQL Server][SQL Server]The query has been canceled because the estimated cost of this query (3066)

StaHorse — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have this error from one of my Qlik jobs:

"[ODBC Driver 13 for SQL Server][SQL Server]The query has been canceled because the estimated cost of this query (3066) exceeds the configured threshold of 3000. Contact the system administrator."

Where can I increase it, Please help.

Re: [ODBC Driver 13 for SQL Server][SQL Server]The query has been canceled because the estimated cost of this query (3066)

Or — Thu, 04 Jan 2024 11:11:41 GMT

Sounds like you should contact your system administrator / DBA, or cut down on the query's estimated cost by improving it, adding indexes, reducing complexity, etc.

Re: [ODBC Driver 13 for SQL Server][SQL Server]The query has been canceled because the estimated cost of this query (3066)

StaHorse — Thu, 04 Jan 2024 11:35:21 GMT

Where can I increase it?

Re: [ODBC Driver 13 for SQL Server][SQL Server]The query has been canceled because the estimated cost of this query (3066)

Chip_Matejowsky — Thu, 04 Jan 2024 15:39:56 GMT

Hello @StaHorse,

This looks to be a SQL related issue and not a Qlik issue, as the error [SQL Server]The query has been canceled because the estimated cost of this query (3066) isn’t coming the QlikView side. I agree with @Or ‘s suggestion that you reach out to your organization’s DBA as they likely have configured things to not allow expensive queries.

I did a Google search and found the below threads regarding the error you reported:

https://stackoverflow.com/questions/52991097/the-query-has-been-canceled-because-the-estimated-cost-of-this-query-15-exceed

Best Regards