Querying a Salesforce introspected table in TIBCO Data Virtualization fails with an INVALID_QUERY_SCOPE error

Querying a Salesforce introspected table in TIBCO Data Virtualization fails with an INVALID_QUERY_SCOPE error

book

Article ID: KB0074489

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

Querying a Salesforce introspected table in TIBCO Data Virtualization fails with the below error:

====
ERROR 2020-10-26 13:42:34.100 -0700 SalesforceConnectionFactory - 0 [sf:INVALID_QUERY_SCOPE] INVALID_QUERY_SCOPE: Invalid query scope: delegated.
XcdataXsalesforceX190X7145.qne
at XcdataXsalesforceX190X7145.lwe.b(Unknown Source)
at XcdataXsalesforceX190X7145.bwe.a(Unknown Source)
====

This issue occurs due to the 'Filter Scope' property on the datasource in TDV Studio set to Delegated, by default.

Resolution

To resolve this error, in TDV Studio, change the property 'FilterScope' to 'Everything' on the adapter and re-introspect. 

Screenshot for reference:

User-added image

Issue/Introduction

Querying a Salesforce introspected table in TIBCO Data Virtualization fails with an INVALID_QUERY_SCOPE error