You might want to turn on debug mode so you can see what SOQL queries the plugin is running; then you can see better what’s happening (it will show the lastmodified timestamp, the offset values, etc once it logs the query for you). It might be that the frequency is too high.
Okay. Thanks for the pointers, @jonathanstegall. If I “edit” 800 records in Salesforce to trigger the sync/pull, and have the Pull Query Record Limit set to 20, Pull Throttle at 5 seconds, and Run Schedule Every 20 mins (Pull from Salesforce), will the sync keep running until all 800 records are pulled from Salesforce (in batches of 20 at a time every 5 seconds)? Am I think about that correctly? Just trying to understand how this works. Thanks once again.
You can try that and see if it works. If it doesn’t, please do try turning on debug mode so you can see what queries the plugin is actually running against your Salesforce.
Hi @jonathanstegall, so I permanently deleted all logs and posts that the Salesforce pull had created so far in order to start with a clean slate. I just gave 1 record a test (1 update in Salesforce), and the Pull was successful, but based on the log, I got an error: Error: WordPress update for centers ID 4098 from Salesforce record 001f400000ZaxodAAB was unsuccessful with these errors: Invalid Post ID. Essentially, it looks like the sync is still looking for the deleted post. I thought deleting the posts would clear the connection between the records, and the pull would just create a new record. Is there a way to clear it out so that the Pull from Salesforce does create new records now?
Hi @jonathanstegall, any insights on how to sync (pull from SF) to a previously synced record that was deleted from WP? Getting an error that WP Post ID does not exist. Is there a way to clear out the previous sync? Ideally, I want the pull to create a new post on the WP side. Thanks in advance.
The plugin doesn’t really have an interface for that, although it’s possible we might add one at some point. The easiest way is to delete the entry if the record appears in the Mapping Errors tab of the plugin settings. If it does not, you’ll have to find it in the wp_object_sync_sf_object_map table and delete it.
Thanks, @jonathanstegall. Had to truncate the table, but that did work. Appreciate the direction.
So now that the sync is working again, I can debug this better. I just triggered 100 records to pull from Salesforce (based on record update), and when the pull ran, it pulled in (created) 20 new records which is the Pull Query Record Limit I set in the plugin settings. Will the remaining 80 Salesforce records come through during sequential pulls (20 at a time)?
