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

Error while executing "Upsert" using SF_BulkOps

When I am running the following script, I am getting an error
EXEC SF_BulkOps 'Upsert','SALESFORCE','Order_History__c_Upserts','External_ID__c'

Error message is as follows:
--- Starting SF_BulkOps for Order_History__c_Upserts
06:42:12: Run the DBAmp.exe program.
06:42:12: DBAmp Bulk Operations. V2.17.7 (c) Copyright 2006-2013 forceAmp.com LLC
06:42:12: Upserting Salesforce using Order_History__c_Upserts (WIN-SRVADLD0H9M / SFDC) .
06:42:13: DBAmp is using the SQL Native Client.
06:42:13: SOAP Headers:
06:43:24: 8060 rows read from SQL Table.
06:43:24: 34 rows failed. See Error column of row for more information.
06:43:24: 8026 rows successfully processed.
06:43:24: Errors occurred. See Error column of row for more information.
06:43:24: Error: DBAmp.exe was unsuccessful.
06:43:24: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe upsert Order_History__c_Upserts "WIN-SRVADLD0H9M" "SFDC" "SALESFORCE" "External_ID__c" " "
--- Ending SF_BulkOps. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 124
SF_BulkOps Error: 06:42:12: DBAmp Bulk Operations. V2.17.7 (c) Copyright 2006-2013 forceAmp.com LLC06:42:12: Upserting Salesforce using Order_History__c_Upserts (WIN-SRVADLD0H9M / SFDC) .06:42:13: DBAmp is using the SQL Native Client.06:42:13: SOAP Headers: 06:43:24: 8060 rows read from SQL Table.06:43:24: 34 rows failed. See Error column of row for more information.06:43:24: 8026 rows successfully processed.06:43:24: Errors occurred. See Error column of row for more information.
1 person has
this problem
+1
Reply
  • The error column contains the error message for that row from the salesforce server:

    On_Order_History_Create: execution of BeforeInsert caused by: System.ListException: Duplicate id in list: 003A000001IuWaoIAF Trigger.On_Order_History_Create: line 23, column 1

    In this case, you have a BeforeInsert trigger that is failing because there are unexpected duplicate ids. I do not know your trigger code and cannot help further.

    Please contact the authors of the On_Order_History_Create trigger and give them the details of the row and the contents of the Error column. That will help them identify what line in their code is failing.

    Please let me know if you have any questions.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated