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

Getting error while inserting record in salesforce custom object using BULKOPS

Getting error while inserting record in salesforce custom object using BULKOPS
I am getting following error

--- Starting SF_BulkOps for Insert_Customer_Account__c
10:11:50: Run the DBAmp.exe program.
10:11:50: DBAmp Bulk Operations. V2.16.6 (c) Copyright 2006-2013 forceAmp.com LLC
10:11:50: Inserting Insert_Customer_Account__c (SRINISHA-VAIO / salesforce backups).
10:11:50: DBAmp is using the SQL Native Client.
10:11:53: SOAP Headers:
10:11:53: Error: Unable to create Salesforce Table Object.
10:11:53: 1 rows read from SQL Table.
10:11:53: 0 rows successfully processed.
10:11:53: Errors occurred. See Error column of row for more information.
10:11:53: Error: DBAmp.exe was unsuccessful.
10:11:53: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert Insert_Customer_Account__c "SRINISHA-VAIO" "salesforce backups" "SALESFORCE" " "
--- Ending SF_BulkOps. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 125
SF_BulkOps Error: 10:11:50: DBAmp Bulk Operations. V2.16.6 (c) Copyright 2006-2013 forceAmp.com LLC10:11:50: Inserting Insert_Customer_Account__c (SRINISHA-VAIO / salesforce backups).10:11:50: DBAmp is using the SQL Native Client.10:11:53: SOAP Headers: 10:11:53: Error: Unable to create Salesforce Table Object.10:11:53: 1 rows read from SQL Table.10:11:53: 0 rows successfully processed.10:11:53: Errors occurred. See Error column of row for more information.

I have followed as below mentioned steps and i have inserted 1000 records in table of "Insert_Customer_Account__c"

select * from Customer_Account__c

select *,Cast('' as nvarchar(255)) as Error
into Insert_Customer_Account__c
from SALESFORCE...Customer_Account__c
where 1 = 0

select * from Insert_Customer_Account__c

Exec SF_BulkOps 'insert', 'SALESFORCE', 'Insert_Customer_Account__c'

-----------------------------------------------------------------------------
Exec SF_BulkOps 'insert', 'SALESFORCE', 'Insert_Customer_Account__c'
----------------------------------------------------------------------------
1 person has
this problem
+1
Reply
  • "Unable to create Salesforce Table Object. "

    Your staging table name is incorrect. The name must begin with the full name of the object:

    Customer_Account__c_Insert
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Hi Bill Emerson,

    I have changed staging table name as per you sail like but now i am getting following the error

    Error column values seems to be "storage limit exceeded" and Null is not a Boolean

    storage limit exceeded
    storage limit exceeded
    storage limit exceeded
    NULL is not a valid boolean
    NULL is not a valid boolean
    NULL is not a valid boolean
    NULL is not a valid boolean

    ------------------------------
    exec sf_bulkops 'Insert','SALESFORCE','Customer_Account__c_Insert'
    -------------------------------------------

    --- Starting SF_BulkOps for Customer_Account__c_Insert
    23:51:45: Run the DBAmp.exe program.
    23:51:45: DBAmp Bulk Operations. V2.16.6 (c) Copyright 2006-2013 forceAmp.com LLC
    23:51:45: Inserting Customer_Account__c_Insert (SRINISHA-VAIO / salesforce backups).
    23:51:45: DBAmp is using the SQL Native Client.
    23:51:46: SOAP Headers:
    23:51:50: 99 rows read from SQL Table.
    23:51:50: 99 rows failed. See Error column of row for more information.
    23:51:50: 0 rows successfully processed.
    23:51:50: Errors occurred. See Error column of row for more information.
    23:51:50: Error: DBAmp.exe was unsuccessful.
    23:51:50: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert Customer_Account__c_Insert "SRINISHA-VAIO" "salesforce backups" "SALESFORCE" " "
    --- Ending SF_BulkOps. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 125
    SF_BulkOps Error: 23:51:45: DBAmp Bulk Operations. V2.16.6 (c) Copyright 2006-2013 forceAmp.com LLC23:51:45: Inserting Customer_Account__c_Insert (SRINISHA-VAIO / salesforce backups).23:51:45: DBAmp is using the SQL Native Client.23:51:46: SOAP Headers: 23:51:50: 99 rows read from SQL Table.23:51:50: 99 rows failed. See Error column of row for more information.23:51:50: 0 rows successfully processed.23:51:50: Errors occurred. See Error column of row for more information.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • "Storage Limit Exceeded"

    The message is from salesforce and indicates that you have exceeded your storage quota on salesforce. Therefore, you will not be allowed to insert any more records into that org.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • This reply was removed on 2015-04-27.
    see the change log
  • This reply was removed on 2015-06-19.
    see the change log
  • This reply was removed on 2016-04-29.
    see the change log