function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
AhmedPotAhmedPot 

Getting error Max Size of insert update call is 200

Hi,

 

I'm getting Max Size of insert update call is 200 error when I'm trying to insert an array of type sObject4 with size of array more than 200.

 

    Dim so(300) As SObject4
    i = 19
  cntVal = 0
  While Cells(i, 1) <> ""    
    Set so(cntVal) = objSession.CreateObject("Fleet_List__c")

    so(cntVal)("Owner_Name__c") = Sheet1.Cells(i, 3).Value
    so(cntVal)("Asset_Name__c") = Sheet1.Cells(i, 4).Value

    cntVal = cntVal + 1
  i = i + 1
  Wend

    objSession.Create so, False   'commit the Sobject
    objSession.Refresh so, False

 

If size of array is set to 200, then it works fine.

 

Is there  any other better way to insert/update more than 200 records.

 

Awaiting any help on this.

 

Thanks,

Ahmed

 

jroyaltyjroyalty

From what I've seen, the connector itself does the updates in batches to avoid hitting this limit.  Your best option is probably to break the arrays down into sections 200 or less and update on each after that.

 

One alternative (I do not know if this will do anything in this situation or not) is to open the connector's options, and under the Advanced tab check the "Disregard the reasonable limits on max rows to Update" option.  Then try again and see if anything changes.