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

WinHttpReceiveResponse Server Error on OpportunitySplit

As of this weekend I started receiving the following error when running a SF_RefreshAll. It appears that the only object with a problem is the OpportunitySplit object. All other objects refresh fine. I also tried a SF_ReplicateAll and drop the OpportunitySplit table and tried a replicate for just that object but I still get the same error. Any suggestions on how to fix this?

--- Starting SF_Refresh for OpportunitySplit
15:03:59: Using last run time of 2013-10-11 17:21:00
OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "SFWinInet::Send::WinHttpReceiveResponse Server Error".
Error: SF_Refresh failed for table OpportunitySplit
Error 7320, Severity 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1005"."CreatedById" "Col1008","Tbl1005"."CreatedDate" "Col1009","Tbl1005"."Id" "Col1010","Tbl1005"."IsDeleted" "Col1011","Tbl1005"."LastModifiedById" "Col1012","Tbl1005"."LastModifiedDate" "Col1013","Tbl1005"."OpportunityId" "Col1014","Tbl1005"."Split" "Col1015","Tbl1005"."SplitAmount" "Col1016","Tbl1005"."SplitNote" "Col1017","Tbl1005"."SplitOwnerId" "Col1018","Tbl1005"."SplitPercentage" "Col1019","Tbl1005"."SystemModstamp" "Col1006" FROM "OpportunitySplit" "Tbl1005" WHERE "Tbl1005"."SystemModstamp">?" against OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".
1 person has
this problem
+1
Reply
  • With the version of DBAmp you have installed, we are getting only a general error message ("Server Error") and not the specific salesforce server message.

    There are 2 options:

    1. Upgrade to the latest version of DBAmp using the instructions at http://www.forceamp.com/upgrade.htm The latest version of DBAMp provide much more detailed information that will allow us to diagnosis the issue.

    2. If you are unable to upgrade now and have the sf Data Loader, try to do an export of that object while logged in to the data loader as the same sf user the linked server uses. You should get a detailed error message. Report that message back to us for interpretation.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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