Skyvia interacts with Salesforce via its API. During a backup operation, you may encounter errors due to certain limitations or behaviors specific to the Salesforce API.
For example, when Skyvia performs a backup or replication, it queries all the data from Salesforce using a SELECT query. However, there are objects in Salesforce that require the WHERE condition in the query (simple SELECT * FROM Table is not valid for such objects).
These objects require different filter conditions (generally, the error message includes details regarding these filters):
- FlowVariableView: a filter on a reified column is required [FlowVersionViewId,DurableId]
- Implementation restriction: ContentFolderItem requires a filter by Id or ParentContentFolderId using the equals or 'IN' operator
- Can select only RecordId, a Has*Access field, and MaxAccessLevel
- FlexQueueItem | The WHERE clause must contain a JobType field expression. , etc.
Generally, objects with such restrictions are system tables and contain not user's data, but data about other objects, columns or service information. That's why these tables require specific filters in order to retrieve the necessary information. Please note, usually, these tables are read-only and thus cannot be used in a restore operation.
Also, Skyvia cannot add filters automatically because each object has its own peculiarities and most filters are based on specific Id values, etc.
It is recommended to exclude these objects from the backup. If these objects are required for your scenario, you can manually add filters to the tasks. Related Articles
Salesforce API errors: TotalRequests Limit Exceeded/ApiBatchItems Limit Exceeded
The TotalRequests Limit Exceeded and ApiBatchItems Limit Exceeded errors are Salesforce-specific errors indicating that you have reached specific API limits on the Salesforce platform. Please find explanations of each error and relevant documentation ...
Skyvia Query: Easily Verify Data in Your Connection!
Please follow the steps below to query your data in Skyvia Query: Log in to Skyvia and navigate to + Create New → Query. Select an existing connection or establish a new one for your data source. Choose the desired table or object from the Connection ...
Backup Plan Storage Limits
When using a backup solution, monitoring storage capacity is critical for smooth operation. Once the backup plan’s storage limit is reached, no further backups—whether manual or scheduled—will be performed until storage is freed, or the plan is ...
Salesforce Report exports only 2000 records
Skyvia integrates with Salesforce via its API, inheriting both its features and limitations. One key limitation is the Run Report restriction, which limits data extraction to the first 2,000 rows of a report. For more details on this limitation, we ...
Skyvia Query: You have reached the limit of queries
If you encounter the message "You have reached the limit of queries," it indicates that you have exceeded the maximum number of queries allowed for your Free plan on Skyvia Query. The Free Query plan is designed for basic testing purposes and allows ...