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

Upsert Failing

I am trying to upsert 41,000 records and am getting errors. I have verified the records are in the upsert table. I then run the 'Upsert:bulkapi' command and get the following error. Also, when I check the upsert table and only 37 records now exist.

--- Starting SF_BulkOps for Opportunity_bulkupsert
15:29:21: Run the DBAmp.exe program.
15:29:22: DBAmp Bulk Operations. V2.13.5 (c) Copyright 2006-2011 LLC
15:29:22: Upserting Salesforce using Opportunity_bulkupsert (FFC-SQL2SF / Salesforce Backup) .
15:29:22: DBAmp is using the SQL Native Client.
15:30:52: Error: Update for SQL Table failed.
Source: Microsoft SQL Server Native Client 10.0
Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Source: Microsoft SQL Server Native Client 10.0
Description: Cursor operation conflict
15:30:52: Error: Unable to update table with the Transmitted message.
15:30:53: 3301 rows read from SQL Table.
15:30:53: 1 rows failed. See Error column of row for more information.
15:30:53: 0 rows processed.
15:30:53: Errors occurred. See Error column of row and above messages for more information.
15:30:53: Error: DBAmp.exe was unsuccessful.
15:30:53: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe upsert:bulkapi Opportunity_bulkupsert "FFC-SQL2SF" "Salesforce Backup" "Salesforce" "Application_Number__c"
--- Ending SF_BulkOps. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 92
--- Ending SF_BulkOps. Operation FAILED.

Any ideas on what the problem is and how I can fix it?
1 person has
this question