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

SF_Replicate : Error: SetProxyInfo failed. Proxy not used

DBAmp version: 3.1.5
SFDC linked server works with sql statements, like select, insert, delete. However, SF_Replicate doesn't work (see the error detailed as below). Turn on the tracing and from the tracing file response is recorded correctly. xp_cmdshell is working without issue.

Error: SetProxyInfo failed. Proxy not used.
Error: DBAmp.exe was unsuccessful.
Error: Command string is c:\Software\DBAmp\DBAmp.exe Export "Territory__c_Previous" "localdb" "salesforce backups" "SFDC"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 288
--- Ending SF_Replicate. Operation FAILED.
1 person has
this problem
+1
Reply
  • Can you post the complete message output from your sf_replicate ?

    Also,

    1. In the DBAmp Configuration Program Options page, is "Use Proxy" checked ?
    2. In the DBAmp Connfiguration Program Options page, is the SQL Login string "Trusted_Connections=yes"
    3. On the linked server Security, are there NO mappings of local to remote user ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Thanks for the quick response, Bill. Yes to 1 and 2; No mapping of local to remote user for 3. I am using sql server 2012.

    --- Starting SF_Replicate for Territory__c V3.1.5
    14:16:19: Drop Territory__c_Previous if it exists.
    14:16:19: Create Territory__c_Previous with new structure.
    14:16:20: Run the DBAmp.exe program.
    14:16:20: DBAmp Bulk Operations. V3.1.5 (c) Copyright 2006-2015 forceAmp.com LLC
    14:16:20: Populating local table Territory__c_Previous , LocalDB / salesforce backups .
    14:16:22: DBAmp is using the SQL Native Client.
    14:16:22: Opening SQL Server rowset
    14:16:22: Error: SetProxyInfo failed. Proxy not used.
    14:16:23: Error: DBAmp.exe was unsuccessful.
    14:16:23: Error: Command string is C:\DBAmp\DBAmp.exe Export "Territory__c_Previous" "LocalDB" "salesforce backups" "SFDC"
    --- Ending SF_Replicate. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 288
    --- Ending SF_Replicate. Operation FAILED.
  • (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

  • So the issue is that the sf_replicate is technically running under the SQL Server Service account and not your windows account.

    Is there a proxy userid and password on the Options page ?

    Are you using the Proxy ConfigURL or Proxy URL ?

    Would it be possible to ask you network guys to add a "direct" rule to the firewall so that you do not need to configure a proxy ?
  • (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

  • Hi Bill,

    I'm getting this error while running SF_Replicate. Below is the message.
    Could you please help me out.

    --- Starting SF_Replicate for AccountTeamMember V3.3.4
    16:57:33: Parameters: SALESFORCE AccountTeamMember Version: V3.3.4
    16:57:33: Drop AccountTeamMember_Previous if it exists.
    16:57:33: Create AccountTeamMember_Previous with new structure.
    16:57:34: Run the DBAmp.exe program.
    16:57:35: DBAmp Bulk Operations. V3.3.4 (c) Copyright 2006-2016 forceAmp.com LLC
    16:57:35: Populating local table AccountTeamMember_Previous , SSIVASUBRA00508 / salesforce backups .
    16:57:38: DBAmp is using the SQL Native Client.
    16:57:38: Opening SQL Server rowset
    16:57:38: Error: Failed to execute command to retrieve session id.
    Source: (null)
    Description: (null)
    Source: (null)
    Description: (null)
    16:57:38: Error: Unable to populate salesforce session id. Retrying...
    16:57:38: Error: Failed to execute command to retrieve session id.
    Source: (null)
    Description: (null)
    Source: (null)
    Description: (null)
    16:57:38: Error: DBAmp.exe was unsuccessful.
    16:57:38: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "AccountTeamMember_Previous" "SSIVASUBRA00508" "salesforce backups" "SALESFORCE"
    --- Ending SF_Replicate. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 332 [Batch Start Line 9]
    --- Ending SF_Replicate. Operation FAILED.
  • (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