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

Error given while running Upsert

I'm new to DBamp and Salesforce and I am trying to Upsert some test data to a Salesforce sandbox before moving live data. I am only trying to push data over and the columns match up with those in Salesforce. My external ID is "PSEP_contact_cid__c". SF_DEVFULLBOX is the name of our Salesforce sandbox.

Here is the Upsert I am running.

exec SF_Bulkops 'Upsert:bulkapi','SF_DEVFULLBOX','SF_PushTest','PSEP_contact_cid__c'

I am getting this message when running that upsert.

--- Starting SF_BulkOps for SF_PushTest V3.1.5
13:48:58: Run the DBAmp.exe program.
13:48:58: DBAmp Bulk Operations. V3.1.5 (c) Copyright 2006-2015 forceAmp.com LLC
13:48:58: Upserting Salesforce using SF_PushTest (DBASE2 / PSEP_test) .
13:48:58: DBAmp is using the SQL Native Client.
13:48:59: Warning: BulkAPI operations without a Sort column could perform slowly.
13:48:59: SF_Bulkops will poll every 60 seconds for up to 3600 seconds.
13:48:59: Error: Unable to create Salesforce Table Object.
13:48:59: Error: DBAmp.exe was unsuccessful.
13:48:59: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe upsert:bulkapi SF_PushTest "DBASE2" "PSEP_test" "SF_DEVFULLBOX" "ID" " "
--- Ending SF_BulkOps. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 141
SF_BulkOps Error: 13:48:58: DBAmp Bulk Operations. V3.1.5 (c) Copyright 2006-2015 forceAmp.com LLC13:48:58: Upserting Salesforce using SF_PushTest (DBASE2 / PSEP_test) .13:48:58: DBAmp is using the SQL Native Client.13:48:59: Warning: BulkAPI operations without a Sort column could perform slowly.13:48:59: SF_Bulkops will poll every 60 seconds for up to 3600 seconds.13:48:59: Error: Unable to create Salesforce Table Object.
1 person has
this problem
+1
Reply