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

Another FAHttp::Send::WinHttpReceiveResponse issue

I have the latest version of DBamp running.
I am running an automated job using SF_Replicate on 20 different objects on a nightly basis.

Every night the exact same object fails with FAHttp::Send::WinHttpReceiveResponse. The rest of the objects replicate just fine.

When I use SF_Replicate during the day for this object it works just fine.

I have moved the object around from being the 1st to run to last and a few in between. But same resulting error.

It is the OpportunityLineItem object and it only has 50 columns and less than 80K rows.

I am not sure how to research more into what is happening. Any ideas what I should be looking for?
1 person has
this question
+1
Reply
  • Can you post the entire message output of that sf_replicate ?
  • (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

  • Here is the result in the DBAmp_Log table
    SPName Status Message LogTime
    SF_Replicate:957 Failed Ending - Operation Failed. 2013-11-09 00:50:49.280
    SF_Replicate:957 Message The server returned an invalid or unrecognized response
    2013-11-09 00:50:49.277
    SF_Replicate:957 Message Win32Error:: 2013-11-09 00:50:49.273
    SF_Replicate:957 Message 00:50:49: FAHttp::Send::WinHttpReceiveResponse 2013-11-09 00:50:49.270
    SF_Replicate:957 Message 00:50:49: Error: RunQuery failed with com_error. 2013-11-09 00:50:49.263
    SF_Replicate:957 Message 00:49:47: Opening SQL Server rowset 2013-11-09 00:50:49.260
    SF_Replicate:957 Message 00:49:47: DBAmp is using the SQL Native Client. 2013-11-09 00:50:49.257
    SF_Replicate:957 Message 00:49:47: Populating local table OpportunityLineItem_Previous , USOLACRPSSQL01 / SalesForce . 2013-11-09 00:50:49.250
    SF_Replicate:957 Message 00:49:47: DBAmp Bulk Operations. V2.17.7 (c) Copyright 2006-2013 forceAmp.com LLC 2013-11-09 00:50:49.247
    SF_Replicate:957 Starting Parameters: SALESFORCE OpportunityLineItem 2013-11-09 00:49:47.547
  • (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

  • Here is the result from the output of the job step

    ecuted as user: XXXXXX. --- Starting SF_Replicate for OpportunityLineItem [SQLSTATE 01000] (Message 0) 00:21:04: Drop OpportunityLineItem_Previous if it exists. [SQLSTATE 01000] (Message 0) 00:21:04: Create OpportunityLineItem_Previous with new structure. [SQLSTATE 01000] (Message 0) 00:21:04: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 00:21:04: DBAmp Bulk Operations. V2.17.7 (c) Copyright 2006-2013 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 00:21:04: Populating local table OpportunityLineItem_Previous , USOLACRPSSQL01 / SalesForce . [SQLSTATE 01000] (Message 0) 00:21:04: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 00:21:04: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 00:22:05: Error: RunQuery failed with com_error. [SQLSTATE 01000] (Message 0) 00:22:05: FAHttp::Send::WinHttpReceiveResponse [SQLSTATE 01000] (Message 0) Win32Error:: [SQLSTATE 01000] (Message 0) The server returned an invalid or unrecognized response [SQLSTATE 01000] (Message 0) 00:22:05: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000] (Message 0) 00:22:05: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "OpportunityLineItem_Previous" "USOLACRPSSQL01" "SalesForce" "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.
  • (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

  • Can you send me an email to support at force amp.com so we can setup a time for a web meeting to take a look ?
  • (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