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

Exceeded 20000 distinct ids

When I replicate the Note table, I get the following error:

--- Starting SF_Replicate for Note
09:37:00: Drop Note_Previous if it exists.
09:37:00: Create Note_Previous with new structure.
09:37:00: Run the DBAmp.exe program.
09:37:00: DBAmp Bulk Operations. V2.14.3 (c) Copyright 2006-2012
forceAmp.com LLC
09:37:00: Populating local table Note_Previous , ALPSRV61\ALPSRV61 /
salesforce backups .
09:37:01: DBAmp is using the SQL Native Client.
09:37:01: Opening SQL Server rowset
09:38:05: Error: RunQuery failed with com_error.
09:38:05: exceeded 20000 distinct ids
09:38:05: Error: DBAmp.exe was unsuccessful.
09:38:05: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe
Export "Note_Previous" "ALPSRV61\ALPSRV61" "salesforce backups"
"SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
1 person has
this question
+1
Reply
  • "exceeded 20000 distinct ids"

    This salesforce server error normally occurs because you are using an sf
    user in the link server that does not have the modify all data privilege
    or is not a system administrator.

    For non-admins, the salesforce api must navigate the security model to
    figure out whether the id has access to the note. When an internal
    processing array exceeds 20,000 ids, the sf server returns this error.
    When you use a sys admin as the sf user, the security model processing is
    bypassed.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited