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

[StaHorse]

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.

[Or · Accepted solution]

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.

[StaHorse]

Where can I increase it?

[Chip_Matejowsky · Accepted solution]

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-...

Best Regards