Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SF_BulkSOQL_Refresh - INVALID_REPLICATION_DATE: startDate cannot be more than 30 days ago

Hello, I'm using SF_BulkSOQL and SF_BulkSOQL_Refresh to replicate/refresh a custom Salesforce table. I'm able to use these two DBAmp procs with other SOQL tables, however this one is giving me some trouble. I first replicate the table using SF_BulkSOQL, and then immediately use SF_BulkSOQL_Refresh to refresh the table, however I'm getting the following error. Any ideas?

Output:

--- Starting SF_BulkSOQL_Refresh for Apttus_Proposal__Proposal__c V3.8.3
12:31:55: Using last run time of 2019-08-07 08:44:00
12:32:10: Identified 17 updated/inserted rows.
OLE DB provider "DBAmp.DBAmp" for linked server "LS_REPLICN_SF_CORP" returned message "Error 1 : INVALID_REPLICATION_DATE: startDate cannot be more than 30 days ago".
12:32:10: Error occurred fetching deleted rows.
12:32:10: Error: Cannot execute the query "Select Id from apttus_proposal__proposal__c_Deleted where startdate='2019-08-07 01:44:00'" against OLE DB provider "DBAmp.DBAmp" for linked server "LS_REPLICN_SF_CORP".
--- Ending SF_BulkSOQL_Refresh. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_BulkSOQL_Refresh, Line 558 [Batch Start Line 0]
--- Ending SF_BulkSOQL_Refresh. Operation FAILED.

Completion time: 2019-09-10T13:32:10.7458215-06:00
1 person has
this problem
+1
Reply