function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

INVALID_REPLICATION_DATE issue with Opportunity History

Hi all,


I am using DBAmp to load my replicate some of my tables.  One of my tables OpportunityHistory, hasn't been updated in months and I need to update it.


But I got tje below error: INVALID_REPLICATION_DATE: startDate cannot be more than 30 days ago


And I cannot replicate data that has been modified past then into my OpportunityHistory table.  How do I go about fixing this?

Jia HuJia Hu
Do you mean the OpportunityHistory object here:

This is a real only Object.

Assuming that your local copy of the Salesforce database is 'SALESFORCE', I think you're using the dbAmp command:


exec sf_refresh 'SALESFORCE' , 'OpportunityHistory'


This command, under the hood, makes calls to the SFDC API calls getDeleted() and getUpdated(). As the error message stated, these calls have limits on how far back they will go.


I suspect the command you need is:


exec sf_replicate 'SALESFORCE', 'OpportunityHistory'


Good luck!


The error means you waited too long before refreshing.


Do a full copy using the sf_replicate stored procedure and then you can resume your sf_refresh schedule.