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

SF_Refresh Fail on some tables only.

Hi,
We get an error on SF_Refresh on some tables only. It started last saturday.
The SF_Replicate still works on those tables. We change nothing regarding our storeProcs using DBAmp and it worked well before. Here is a example of a successful replicate followed by a refresh failure:

EXEC [dbo].[SF_Replicate]
@table_server = SALESFORCE,
@table_name = Color__C

----- Starting SF_Replicate for Color__C
--09:47:17: Drop Color__C_Previous if it exists.
--09:47:17: Create Color__C_Previous with new structure.
--09:47:18: Run the DBAmp.exe program.
--09:47:18: DBAmp Bulk Operations. V2.18.9 (c) Copyright 2006-2014 forceAmp.com LLC
--09:47:18: Populating local table Color__C_Previous , DBS-PRD-01 / salesforce backups .
--09:47:19: DBAmp is using the SQL Native Client.
--09:47:19: Opening SQL Server rowset
--09:47:28: 19623 rows copied.
--09:47:28: Drop Color__C if it exists.
--09:47:28: Rename previous table from Color__C_Previous to Color__C
--Caution: Changing any part of an object name could break scripts and stored procedures.
--09:47:28: Create primary key on Color__C
----- Ending SF_Replicate. Operation successful.

EXEC [dbo].[SF_Refresh]
@table_server = SALESFORCE,
@table_name = Color__C,
@schema_error_action = N'YES',
@verify_action = N'NO ',
@bulkapi_option = N'BULKAPI'

----- Starting SF_Refresh for Color__C
--09:47:41: Using Schema Error Action of yes
--09:47:41: Using last run time of 2016-04-26 09:17:00
--09:47:41: Run the DBAmp.exe program.
--09:47:41: DBAmp Bulk Operations. V2.18.9 (c) Copyright 2006-2014 forceAmp.com LLC
--09:47:41: Populating local table Color__C_Delta2016-04-26T09:47:41.223 , DBS-PRD-01 / salesforce backups .
--09:47:41: DBAmp is using the SQL Native Client.
--09:47:41: Opening SQL Server rowset
--09:47:42: Using the bulkapi with polling every 60 seconds.
--09:47:42: Job still running.
--09:47:57: Job Complete.
--09:47:57: Error: Unable to retrieve batch result.
--09:47:57: Error: Http Request returned a zero length result.
--09:47:57: Retrying to retrieve batch result.
--09:47:58: Error: Unable to retrieve batch result.
--09:47:58: Error: Http Request returned a zero length result.
--09:47:58: Retrying to retrieve batch result.
--09:47:58: Error: Unable to retrieve batch result.
--09:47:58: Error: Http Request returned a zero length result.
--09:47:58: Error: DBAmp.exe was unsuccessful.
--09:47:58: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe ExportBulk:BULKAPI "Color__C_Delta2016-04-26T09:47:41.223" "DBS-PRD-01" "salesforce backups" "SALESFORCE" "where SystemModstamp>2016-04-26 09:17:00"
----- Ending SF_Refresh. Operation FAILED.
--Msg 50000, Niveau 16, État 1, Procédure SF_Refresh, Ligne 661
----- Ending SF_Refresh. Operation FAILED.

Can you help us with that?

Thank you

Brice
1 person has
this problem
+1
Reply