Error message "The query processor could not obtain access to a required interface" is displayed when running Information Links that connect to Microsoft SQL Server.

Error message "The query processor could not obtain access to a required interface" is displayed when running Information Links that connect to Microsoft SQL Server.

book

Article ID: KB0083226

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.0.x and later

Description

Spotfire may display the following error message when running Information Links that are based out of MS SQL Server.

"The query processor could not obtain access to a required interface" 


 

Issue/Introduction

Error message "The query processor could not obtain access to a required interface" is displayed when running Information Links that connect to Microsoft SQL Server.

Resolution

This error is specific to SQL Server data sources.

Check with your database administrator (DBA) to see if the database that is being used as the datasource has sufficient resources and is up & running.

Additional Information

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0a967ae8-a1fe-48e6-b251-88348ecdc281/sql-server-2014-columnstore-with-partitioningindexed-views-bug?forum=sqldatabaseengine
http://sqlknowledge.com/2011/01/monitoring-setting-alerts-for-sql-server-critical-errors/