# SF\_Refresh tells me that I've exceeded ID limit

**URL:** <https://community.cdata.com/t/sf-refresh-tells-me-that-ive-exceeded-id-limit/128>\
**Category:** CData DBAmp\
**Tags:** sql, question, salesforce, dbamp\
**Created:** [March 30, 2023, 5:19pm UTC](https://community.cdata.com/t/sf-refresh-tells-me-that-ive-exceeded-id-limit/128 "2023-03-30T17:19:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dani\_Moran](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\
**Post date:** [March 30, 2023, 5:19pm UTC](https://community.cdata.com/t/sf-refresh-tells-me-that-ive-exceeded-id-limit/128/1 "2023-03-30T17:19:30Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Dani\_Moran](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\
**Post date:** [March 30, 2023, 5:28pm UTC](https://community.cdata.com/t/sf-refresh-tells-me-that-ive-exceeded-id-limit/128/2 "2023-03-30T17:28:01Z")

</div>

EXCEEDED\_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.