+ Start a Discussion
brozinickrbrozinickr 

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:
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_opportunityhistory.htm

This is a real only Object.
SFFSFF

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!

forceAMPforceAMP

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.

 

Bill