How to resolve "INVALID_QUERY_SCOPE" when running a query against Salesforce in TIBCO Data Virtualization?
Article ID: KB0075257
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.2 and later |
Description
A query against a "Salesforce with SSO" data source returns this error in TDV:
Cause: [sf:INVALID_QUERY_SCOPE] INVALID_QUERY_SCOPE: Invalid query scope: delegated.
Cause: [sf:INVALID_QUERY_SCOPE] INVALID_QUERY_SCOPE: Invalid query scope: delegated.
Issue/Introduction
This concerns an adapter setting.
Resolution
In the Studio, open your "Salesforce with SSO" type data source. In the Connections tab, look for the drop-down field for "Filter Scope". When the data source was initially created, it may have defaulted to: "Delegated" after the introspection was completed and saved.
Change the "Filter Scope" setting to "Everything" and save it in the Studio, then retry your query.
These are the normally allowable values:
- Delegated
- Everything
- Mine
- MineAndMyGroups
- My_Territory
- My_Team_Territory
- Team
Change the "Filter Scope" setting to "Everything" and save it in the Studio, then retry your query.
These are the normally allowable values:
- Delegated
- Everything
- Mine
- MineAndMyGroups
- My_Territory
- My_Team_Territory
- Team
Feedback
Yes
No
Powered by
