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.

Issue/Introduction

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

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

Powered by Wolken Software