Salesforce Replication Processed 0 Records On Initial Replication
Article ID: KB0078538
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
Replicating your Salesforce data to a target datastore, such as Microsoft SQL Server, results in 0 records being processed. You see errors similar to the following in the Agent Logs:
Timestamp: 9/8/2016 8:23:41 PM
Severity: Error
Title:Scribe.Core.Processor.ReplicationStatusProcessSupport
Win32 ThreadId:14932
Message: Unexpected error during Execute Method for processDefinition 645b0b42-a8bf-4580-9351-0ae69c80f29f
Exception Type : InvalidExecuteMethodException
Message : The following error has occurred in the Salesforce Connector: query batch timed out retrieving: Properties__c
StackTrace : at Scribe.Connector.Force.ForceConnector.ExecuteMethod(MethodInput input)
This issue is caused when you have enabled the RS - Use Salesforce Bulk API for initial replication option on the Salesforce Connection dialog in Scribe Online, but have not enabled the Bulk API in Salesforce.
The RS - Use Salesforce Bulk API for initial replication option in Scribe Online requires that you have the Bulk API enabled in Salesforce. If the Bulk API in for your Salesforce organization is not enabled, the regular Salesforce API is used and it does not respond to requests for bulk data. Therefore, no data is sent to Scribe Online.
Timestamp: 9/8/2016 8:23:41 PM
Severity: Error
Title:Scribe.Core.Processor.ReplicationStatusProcessSupport
Win32 ThreadId:14932
Message: Unexpected error during Execute Method for processDefinition 645b0b42-a8bf-4580-9351-0ae69c80f29f
Exception Type : InvalidExecuteMethodException
Message : The following error has occurred in the Salesforce Connector: query batch timed out retrieving: Properties__c
StackTrace : at Scribe.Connector.Force.ForceConnector.ExecuteMethod(MethodInput input)
This issue is caused when you have enabled the RS - Use Salesforce Bulk API for initial replication option on the Salesforce Connection dialog in Scribe Online, but have not enabled the Bulk API in Salesforce.
The RS - Use Salesforce Bulk API for initial replication option in Scribe Online requires that you have the Bulk API enabled in Salesforce. If the Bulk API in for your Salesforce organization is not enabled, the regular Salesforce API is used and it does not respond to requests for bulk data. Therefore, no data is sent to Scribe Online.
Issue/Introduction
On the initial sync for Salesforce to a target datastore, the Replication executes but no records are stored in the target.
Resolution
Workaround
Option 1:In Scribe Online, open the Salesforce Connection dialog and disable the RS - Use Salesforce Bulk API for initial replication option.
Option 2:
In your Salesforce organization, enable the Salesforce Bulk API.
Feedback
Yes
No
Powered by
