SFDC Issue in Runtime engine while bulk DML operation

Salesforce Issue in partial record processing in bulk DML operation


Here we will go through the issue related to partial record processing in bulk DML operations for example. Data loader, or database.insert( listSobject, false ).

What is partial update?

To understand the issue, first let’s understand partial update.
Suppose we try to insert 5 records into Lead object and 1 fails 4 succeeds. This is called partial records processing in bulk DMLs.

Scenario

Let’s execute a scenario and prove that there is an issue with Salesforce partial record processing .
  1. Suppose we have a trigger as shown below. This sets the email field for all the newly inserted leads.



2.       Now suppose we insert below listed leads using data loader. Since we know that Company is mandatory on lead object, So last lead ‘Lead10’ should fail and all other should be successfully inserted. Also for success full leads email id should be set to ‘testemail@domain.com’ by trigger.


3.       Now go to SFDC and check if the inserted leads are having proper values. You will find that 9 leads which inserted successfully have Email field empty.




  1.  Expected output was to have all 9 leads with email id populated by trigger.
It seems to be the issue in sfdc with its Runtime engine which handles bulk DML. 
ave a look on the previous post to identify how runtime engine works.

Comments

Post a Comment

Popular posts from this blog

Secure Apex Code with User Mode Database Operations (Generally Available)

  The new  Database  and  Search  methods support an  accessLevel  parameter that lets you run database and search operations in user mode instead of in the default system mode. This feature, now generally available, includes some changes since the last release. Apex code runs in system mode by default, which means that it runs with substantially elevated permissions over the user running the code. To enhance the security context of Apex, you can specify user mode access for database operations. Field-level security (FLS) and object permissions of the running user are respected in user mode and it always applies sharing rules. In system mode, the class sharing keywords control the sharing rules. Where:  This change applies to Lightning Experience and Salesforce Classic in Enterprise, Performance, Unlimited, and Developer editions. How:  You can indicate the mode of the operation by using  WITH USER_MODE  or  WITH SYSTEM_MODE ...
Read more

Use the System.enqueueJob Method to Specify a Delay in Scheduling Queueable Jobs

Image
  A new optional override adds queueable jobs to the asynchronous execution queue with a specified minimum delay (0–10 minutes). Using the  System.enqueue(queueable, delay)  method ignores any org-wide enqueue delay setting. The delay is ignored during Apex testing. Where:  This change applies to Lightning Experience and Salesforce Classic in Enterprise, Performance, Unlimited, and Developer editions. How:  Here are some cases where it can be beneficial to adjust the timing before the queueable job runs. If the external system is rate-limited and can be overloaded by chained queueable jobs that are making rapid callouts. When polling for results, and executing too fast can cause wasted usage of the daily async Apex limits. This example adds a job for delayed asynchronous execution by passing in an instance of your class implementation of the  Queueable  interface for execution. There’s a minimum delay of 5 minutes before the job is executed. Integer de...
Read more

IsVisibleInSelfService on Task salesforce

I was working on assignment which required me to access Tasks and show on customer portal. I written the apex code and fired SOQL, but to my surprise none of Tasks were fetched. I thought its a permission issue from profile or sharing access issue. However at the end I found that there is a field on task object called  IsVisibleInSelfService  which derives the visibility of the tasks for customer portals. Even Apex code can't find the task if this boolean field is not set to true. Probably its trivial information but usefull when you are not aware of this :)
Read more