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

Replicate fails with Unable to find query cursor data for this QueryLocator

Is there a way to know why this replication failed? If this replicate did exceed the 10 cursor limit, is there ways to prevent this from happening?
That you in advance...
--------------

06/02/2015 23:06:00,Replicate CampaignMember,Error,1,S28,Replicate CampaignMember,exec sf_replicate 'salesforce''campaignMember',,Executed as user: NT AUTHORITY\SYSTEM. --- Starting SF_Replicate for campaignMember [SQLSTATE 01000] (Message 0) 23:06:00: Drop campaignMember_Previous if it exists. [SQLSTATE 01000] (Message 0) 23:06:00: Create campaignMember_Previous with new structure. [SQLSTATE 01000] (Message 0) 23:06:01: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 23:06:01: DBAmp Bulk Operations. V2.20.3 (c) Copyright 2006-2015 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 23:06:01: Populating local table campaignMember_Previous S28 / Salesforce_Repl . [SQLSTATE 01000] (Message 0) 23:06:02: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 23:06:02: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 00:13:16: Error: An error has occurred while fetching rows from salesforce.com. [SQLSTATE 01000] (Message 0) 00:13:16: Unable to find query cursor data for this QueryLocator (org 00D80000000diq5EAA path 5/00D80000000diq5EAA/G/01g3400002a1D7GAAU/10260000.cursor) please retry your query. [SQLSTATE 01000] (Message 0) 00:13:16: Error: Replication failed. [SQLSTATE 01000] (Message 0) Source: ForceAmpAPI.SQueryResults4.1 [SQLSTATE 01000] (Message 0) Description: Unable to find query cursor data for this QueryLocator (org 00D80000000diq5EAA path 5/00D80000000diq5EAA/G/01g3400002a1D7GAAU/10260000.cursor) please retry your query. [SQLSTATE 01000] (Message 0) 00:13:18: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000] (Message 0) 00:13:18: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "campaignMember_Previous" "S28" "Salesforce_Repl" "salesforce" [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 42000] (Error 50000). The step failed.,01:07:18,16,50000,,,,0
1 person has
this problem
+1
Reply
  • The 10 open queries at a time per salesforce user is a salesforce limit.

    You should evaluate your SQL job schedule to make sure that you stay under that limit.

    There is an advanced technique to workaround the limit. You can create a second linked server using a different sf user. Make sure the second sf user has the exact same sf security profile as the first so their "views" of sf data are identical.

    Then you can use the second linked server in some of the DBAmp commands. This effectively gives you 20 open queries.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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