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

Error: ClientInputError. Failed to read request. Exceeded max size limit of

I'm getting the following error when loading EmailMessage or FeedItems. How is this max size determined? How can we get around it?
1 person has
this problem
+1
Reply
  • (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

  • --- Starting SF_BulkOps for EmailMessage_Insert V3.6.3
    23:22:16: Run the DBAmp.exe program.
    23:22:16: DBAmp Bulk Operations. V3.6.3 (c) Copyright 2006-2017 forceAmp.com LLC
    23:22:16: Inserting EmailMessage_Insert (DESKTOP-0B1QT46 /xxStaging).
    23:22:17: DBAmp is using the SQL Native Client.
    23:22:17: Batch size reset to 2500 rows per batch.
    23:22:19: Sort column will be used to order input rows.
    23:22:19: SF_Bulkops will poll every 60 seconds for up to 28800 seconds.
    23:22:21: Warning: Column 'CreatedById' ignored because it not insertable in the EmailMessage object.
    23:22:21: Warning: Column 'CreatedDate' ignored because it not insertable in the EmailMessage object.
    23:22:21: Job 7500U000000wWhSQAU created.
    23:22:36: Error: ClientInputError. Failed to read request. Exceeded max size limit of 10000000
    23:22:36: Error: Stopping because unable to create batch.
    23:22:37: Job aborted.
    23:22:37: 1415 rows read from SQL Table.
    23:22:37: Errors occurred. See Error column of row and above messages for more information.
    23:22:37: Percent Failed = 100.000.
    23:22:37: Error: DBAmp.exe was unsuccessful.
    23:22:37: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:bulkapi,batchsize(2500) EmailMessage_Insert "DESKTOP-0B1QT46" "XXStaging" "XX" " "
    --- Ending SF_BulkOps. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 223 [Batch Start Line 130]
    SF_BulkOps Error: 23:22:16: DBAmp Bulk Operations. V3.6.3 (c) Copyright 2006-2017 forceAmp.com LLC23:22:16: Inserting EmailMessage_Insert (DESKTOP-0B1QT46 / xxStaging).23:22:17: DBAmp is using the SQL Native Client.23:22:17: Batch size reset to 2500 rows per batch.23:22:19: Sort column will be used to order input rows.23:22:19: SF_Bulkops will poll every 60 seconds for up to 28800 seconds.23:22:21: Warning: Column 'CreatedById' ignored because it not insertable in the EmailMessage object.23:22:21: Warning: Column 'CreatedDate' ignored because it not insertable in the EmailMessage object.23:22:21: Job 7500U000000wWhSQAU created.23:22:36: Error: ClientInputError. Failed to read request. Exceeded max size limit of 1000000023:22:36: Error: Stopping because unable to create batch.23:22:37: Job aborted.23:22:37: 1415 rows read from SQL Table.23:22:37: Errors occurred. See Error column of row and above messages 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

  • The max size of the data of the batch is 10 meg. You need fewer records in the batch. Try using a batchsize of 1000 or 500.
  • (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

  • Justin,

    The problem is TableLoader doesn't use this and then you get:

    Error: The Batchsize option cannot be specified with the BulkAPI.

    So, can you not use TableLoader for "big" data moves?
  • (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

  • TableLoader uses the new BulkAPI2, which means you don't need to specify a batchsize because Salesforce does that internally for you. The BulkAPI2 won't let us submit a batchsize.

    Try using TableLoader without specifying a batchsize.
  • (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

  • That's how I run it when it throws the error of "Exceeded max size limit of 1000000023:22:36". Is there a workaround for this?
  • (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

  • Can you send me the complete message output of when you ran it with TableLoader and without the batchsize?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • That is what I posted above, or do you need something else?

    --- Starting SF_BulkOps for EmailMessage_Insert V3.6.3
    23:22:16: Run the DBAmp.exe program.
    23:22:16: DBAmp Bulk Operations. V3.6.3 (c) Copyright 2006-2017 forceAmp.com LLC
    23:22:16: Inserting EmailMessage_Insert (DESKTOP-0B1QT46 /xxStaging).
    23:22:17: DBAmp is using the SQL Native Client.
    23:22:17: Batch size reset to 2500 rows per batch.
    23:22:19: Sort column will be used to order input rows.
    23:22:19: SF_Bulkops will poll every 60 seconds for up to 28800 seconds.
    23:22:21: Warning: Column 'CreatedById' ignored because it not insertable in the EmailMessage object.
    23:22:21: Warning: Column 'CreatedDate' ignored because it not insertable in the EmailMessage object.
    23:22:21: Job 7500U000000wWhSQAU created.
    23:22:36: Error: ClientInputError. Failed to read request. Exceeded max size limit of 10000000
    23:22:36: Error: Stopping because unable to create batch.
    23:22:37: Job aborted.
    23:22:37: 1415 rows read from SQL Table.
    23:22:37: Errors occurred. See Error column of row and above messages for more information.
    23:22:37: Percent Failed = 100.000.
    23:22:37: Error: DBAmp.exe was unsuccessful.
    23:22:37: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:bulkapi,batchsize(2500) EmailMessage_Insert "DESKTOP-0B1QT46" "XXStaging" "XX" " "
    --- Ending SF_BulkOps. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 223 [Batch Start Line 130]
    SF_BulkOps Error: 23:22:16: DBAmp Bulk Operations. V3.6.3 (c) Copyright 2006-2017 forceAmp.com LLC23:22:16: Inserting EmailMessage_Insert (DESKTOP-0B1QT46 / xxStaging).23:22:17: DBAmp is using the SQL Native Client.23:22:17: Batch size reset to 2500 rows per batch.23:22:19: Sort column will be used to order input rows.23:22:19: SF_Bulkops will poll every 60 seconds for up to 28800 seconds.23:22:21: Warning: Column 'CreatedById' ignored because it not insertable in the EmailMessage object.23:22:21: Warning: Column 'CreatedDate' ignored because it not insertable in the EmailMessage object.23:22:21: Job 7500U000000wWhSQAU created.23:22:36: Error: ClientInputError. Failed to read request. Exceeded max size limit of 1000000023:22:36: Error: Stopping because unable to create batch.23:22:37: Job aborted.23:22:37: 1415 rows read from SQL Table.23:22:37: Errors occurred. See Error column of row and above messages 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

  • That is from an SF_BulkOps, not from an SF_TableLoader command.
  • (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

  • You're completely correct. Here's one that just ran now trying to upload Attachments:

    --- Starting SF_TableLoader for Attachment_Insert V3.6.3
    11:45:00: Run the DBAmpNet2.exe program.
    11:45:00: DBAmpNet2 3.6.3.0 (c) Copyright 2015-2017 forceAmp.com LLC
    11:45:00: Parameters: insert Attachment_Insert DESKTOP-0B1QT46 XXXStaging GRANICUSSB
    11:45:00: Using the Salesforce SOAP API.
    11:45:02: Drop Attachment_Insert_Result if it exists.
    11:45:02: Create Attachment_Insert_Result with new structure.
    11:45:03: Warning: Column TheKey ignored because it does not exist in the attachment object.
    11:45:03: Warning: Column Sort ignored because it does not exist in the attachment object.
    11:45:43: Error: Unable to make changes to Salesforce object.
    11:45:43: System.Web.Services.Protocols.SoapHeaderException: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:46:39: Error: Unable to make changes to Salesforce object.
    11:46:39: System.Web.Services.Protocols.SoapHeaderException: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:47:17: Error: Unable to make changes to Salesforce object.
    11:47:17: System.Web.Services.Protocols.SoapHeaderException: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:48:02: Error: Unable to make changes to Salesforce object.
    11:48:02: System.Web.Services.Protocols.SoapHeaderException: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:48:41: Error: Unable to make changes to Salesforce object.
    11:48:41: System.Web.Services.Protocols.SoapHeaderException: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:49:27: Error: Unable to make changes to Salesforce object.
    11:49:27: System.Web.Services.Protocols.SoapHeaderException: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:50:16: Error: Unable to make changes to Salesforce object.
    11:50:16: System.Web.Services.Protocols.SoapException: EXCEEDED_MAX_SIZE_REQUEST: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:51:13: Error: Unable to make changes to Salesforce object.
    11:51:13: System.Web.Services.Protocols.SoapException: EXCEEDED_MAX_SIZE_REQUEST: Maximum size of request reached. Maximum size of request is 52428800 bytes.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at DBAmpNet2.sforce.SforceService.create(sObject[] sObjects)
    at DBAmpNet2.BulkOpsSoap.LoadRecords()
    11:51:32: 1651 rows read from SQL Table.
    11:51:32: 1600 rows failed. See Error column of row for more information.
    11:51:32: 51 rows successfully processed.
    11:51:32: Errors occurred. See Error column of row for more information.
    11:51:32: DBAmpNet2 Operation FAILED.
    11:51:32: Percent Failed = 96.900.
    11:51:32: Error: DBAmpNet2.exe was unsuccessful.
    11:51:32: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsSoap "INSERT" "Attachment_Insert" "DESKTOP-0B1QT46" "XXXStaging" "XXXSB" " "
    --- Ending SF_TableLoader. Operation FAILED.
  • (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

  • Try the following: SF_TableLoader 'insert:bulkapi', 'linked_server', 'Attachment_Insert'

    insert your linked server where linked_server is.
  • (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

  • Justin, I had already ran the attachments so couldn't again, but ran cases. Similar error:

    --- Starting SF_TableLoader for Case_Insert V3.6.3
    16:13:11: Run the DBAmpNet2.exe program.
    16:13:11: DBAmpNet2 3.6.3.0 (c) Copyright 2015-2017 forceAmp.com LLC
    16:13:11: Parameters: insert Case_Insert DESKTOP-0B1QT46 xxxStaging xxxSB
    16:13:11: Using the Salesforce bulkapi2 API.
    16:13:14: Sort column will be used to order input rows.
    16:13:14: Warning: Column Legacy_xxx_ID__c ignored because it does not exist in the case object.
    16:13:14: Warning: Column Id ignored because it does not exist in the case object.
    16:13:14: Warning: Column Sort ignored because it does not exist in the case object.
    16:13:16: Drop Case_Insert_Result if it exists.
    16:13:16: Create Case_Insert_Result with new structure.
    16:13:16: Drop Id column.
    16:13:16: Add Id column.
    16:13:16: Add Error column.
    16:13:16: 23820 rows read from SQL Table.
    16:13:16: Job 7500U000000wbxpQAA created on salesforce.
    16:13:22: Using the bulkapi with polling every 60 seconds
    16:13:38: Job still running.
    16:13:53: Job still running.
    16:14:53: Job still running.
    16:15:53: Job still running.
    16:16:54: Job still running.
    16:17:54: Error: null:InvalidBatch : InvalidBatch : Failed to parse CSV. Exceeded max file size: 10000162. Max file size in characters should be less than or equal to 10000000:InvalidBatch : InvalidBatch : Failed to parse CSV. Exceeded max file size: 1001
    8507. Max file size in characters should be less than or equal to 10000000
    16:17:54: Error: Job failed and partial result was discarded.
    16:17:54: DBAmpNet2 Operation FAILED.
    16:17:54: Error: DBAmpNet2.exe was unsuccessful.
    16:17:54: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsBulk "INSERT:bulkapi" "Case_Insert" "DESKTOP-0B1QT46" "xxxStaging" "xxxSB" " "
    --- Ending SF_TableLoader. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_TableLoader, Line 308 [Batch Start Line 471]
    SF_TableLoader Error: 16:13:11: DBAmpNet2 3.6.3.0 (c) Copyright 2015-2017 forceAmp.com LLC16:13:11: Parameters: insert Case_Insert DESKTOP-0B1QT46 xxxStaging xxxSB16:13:11: Using the Salesforce bulkapi2 API.16:13:14: Sort column will be used to order input rows.16:13:14: Warning: Column Legacy_xxx_ID__c ignored because it does not exist in the case object.16:13:14: Warning: Column Id ignored because it does not exist in the case object.16:13:14: Warning: Column Sort ignored because it does not exist in the case object.16:13:16: Drop Case_Insert_Result if it exists.16:13:16: Create Case_Insert_Result with new structure.16:13:16: Drop Id column.16:13:16: Add Id column.16:13:16: Add Error column.16:13:16: 23820 rows read from SQL Table.16:13:16: Job 7500U000000wbxpQAA created on salesforce.16:13:22: Using the bulkapi with polling every 60 seconds16:13:38: Job still running.16:13:53: Job still running.16:14:53: Job still running.16:15:53: Job still running.16:16:54: Job still running.16:17:54: Error: null:InvalidBatch : InvalidBatch : Failed to parse CSV. Exceeded max file size: 10000162. Max file size in characters should be less than or equal to 10000000:InvalidBatch : InvalidBatch : Failed to parse CSV. Exceeded max file size: 10018507. Max file size in characters should be less than or equal to 1000000016:17:54: Error: Job failed and partial result was discarded.16:17:54: DBAmpNet2 Operation FAILED.
  • (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

  • It looks like a bug in salesforce where the bulk api 2 is not correctly building the correct size batch.

    I would try sf_bulkops as an alternative.
  • (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