When I run SF_Refresh on one of my tables, I get the error "EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period" and it won’t complete. How can I run SF_Refresh on that table?
Best answer by Dani Moran
View originalEXCEEDED_ID_LIMIT is an error from Salesforce - they have a limit on how many deleted IDs can be retrieved. So when SF_Refresh goes to pick up all the records that have been deleted since it last ran, it can run into that problem if over 600000 records were deleted. To get around that, you will need to make a Full Copy instead of a Delta Copy, but just the once! You can do that by running SF_Replicate once to pick up those , then you can go back to your usual schedule.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers
