Thursday, December 5, 2019

System.LimitException: Too many DML statements: 1

Exception:

If you use below code it will throw an error System.LimitException: Too many DML statements: 1 ,it is because you have an dml statement in your aura-method which is enabled for cache.

public with sharing class GetAllAccountsCntrl {
   @AuraEnabled(cacheable=true)
    public static List<Account> processAllAccounts() 
 {
        List<Account> lstAcc = new List<Account>();
  for(Account acc:[SELECT Id, Name,AccountSource,Website, Createddate FROM Account Limit 10])
  {
      acc.Name = 'LWC Testing...';
   lstAcc.add(acc);
  }
  Database.update(lstAcc,false);
  return lstAcc;
    }

}






Workaround:

Please remove (cacheable=true) from your method declared above,then this will work without any error

public with sharing class GetAllAccountsCntrl {
   @AuraEnabled
    public static List<Account> processAllAccounts() 
 {
        List<Account> lstAcc = new List<Account>();
  for(Account acc:[SELECT Id, Name,AccountSource,Website, Createddate FROM Account Limit 10])
  {
      acc.Name = 'LWC Testing...';
   lstAcc.add(acc);
  }
  Database.update(lstAcc,false);
  return lstAcc;
    }

}


Please comment or write us if you have any queries/requirements.

Please like,follow,bookmark,subscribe this site to receive daily updates.




Hope this helps you..Enjoy..!

5 comments:

  1. refreshApex is not working if cacheable=true removed.

    ReplyDelete
  2. I have removed cacheable = true and i m not even using wire but still getting too many dml statements : 1
    How do i fix this

    ReplyDelete
    Replies
    1. use @AuraEnabled(cacheable=false) and try. it will work.

      Delete
    2. I had tried with (cacheable=false). Still getting the same issue.

      Delete