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

SF_Replicate with pkchunk now failing

Wondering if you have seen this before, and might have a solution. This is something new to us.

All attempts at the refresh or replication of a large'ish SalesForce object (with about 2m rows) started failing last night, and we cannot get the process to succeed. Note: this process runs nightly, and has been doing so successfully for quite some time.

I've been trying a replicate manually this morning, with no success:

EXEC SalesForce..SF_Replicate 'SALESFORCE' ,'xtma_Individual_Email_Result__c' ,'pkchunk,batchsize(20000)';

Error from SQL session above:

--- Starting SF_Replicate for xtma_Individual_Email_Result__c V3.1.5
07:56:23: Drop xtma_Individual_Email_Result__c_Previous if it exists.
07:56:23: Create xtma_Individual_Email_Result__c_Previous with new structure.
07:56:24: Run the DBAmp.exe program.
07:56:42: Error: DBAmp.exe was unsuccessful.
07:56:42: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export:pkchunk,batchsize(20000) "xtma_Individual_Email_Result__c_Previous" "WAIODSPRODDB" "SalesForce" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 288
--- Ending SF_Replicate. Operation FAILED.

Windows Error from Application Event Log (nothing in system log)

Event ID 1000
Faulting application name: DBAmp.exe, version: 0.0.0.0, time stamp: 0x5637c0da
Faulting module name: DBAmp.exe, version: 0.0.0.0, time stamp: 0x5637c0da
Exception code: 0xc0000005
Fault offset: 0x0000000000025de3
Faulting process id: 0xeef8
Faulting application start time: 0x01d1a54a06f4f7e9
Faulting application path: C:\Program Files\DBAmp\DBAmp.exe
Faulting module path: C:\Program Files\DBAmp\DBAmp.exe

I think I was able to change the DBAmp Trace Level to "All" for a quick repro of the error. I can provide if it would be helpful. I don't see a mechanism to do so on this screen, though.
1 person has
this problem
+1
Reply