Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

SF Refresh Win32 Error

Hi,

We are getting an error when are trying to do a refresh from the cloud for an object containing millions of records.
--- Starting SF_Refresh for Contact V3.3.3
11:45:41: Using Schema Error Action of yes
11:45:44: Using last run time of 2017-04-21 13:09:00
11:45:44: Run the DBAmp.exe program.
11:45:44: DBAmp Bulk Operations. V3.3.3 (c) Copyright 2006-2016 forceAmp.com LLC
11:45:44: Populating local table Contact_Delta2017-05-03T11:45:41.310 , AUQLDVA4 / salesforce_backups_uat .
11:45:45: DBAmp is using the SQL Native Client.
11:45:45: Opening SQL Server rowset
11:45:48: Using the bulkapi with polling every 60 seconds.
11:45:51: Job still running.
14:09:11: Job Complete.
14:14:21: Error: Unable to retrieve batch result.
14:14:21: Failed to read from reply.
Win32Error::
The connection with the server was terminated abnormally

14:14:21:
14:14:21: Retrying to retrieve batch result.
14:33:50: Error: Unable to retrieve batch result.
14:33:50: Failed to read from reply.
Win32Error::
The connection with the server was terminated abnormally

14:33:50:
14:33:50: Retrying to retrieve batch result.
14:41:23: Error: Unable to retrieve batch result.
14:41:23: Failed to read from reply.
Win32Error::
The connection with the server was terminated abnormally

14:41:23:
14:41:23: Error: DBAmp.exe was unsuccessful.
14:41:23: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe ExportBulk:bulkapi "Contact_Delta2017-05-03T11:45:41.310" "AUQLDVA4" "salesforce_backups_uat" "SALESFORCE_UAT" "where SystemModstamp>2017-04-21 13:09:00"
--- Ending SF_Refresh. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Refresh, Line 843
--- Ending SF_Refresh. Operation FAILED.
Thanks,
Karan Kapur
1 person has
this problem
+1
Reply
  • SF_Refresh is picking up the incremental changes

    SF_Replicate is do a full a backup.

    Have you already got a million row+ local table and do you think there are only a small number of changes ? Then run a sf_refresh WITHOUT bulkapi

    Do you think there are a huge number of changes ? Then skip the sf_refresh and run a sf_replicate with bulkapi

    I recommend you never use sf_refresh with the bulkapi option.
  • (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