Count of records processed during batch

Question

I have a batch apex in which I am trying to insert 1000 records at a time. I am using Database.insert() to insert the records.For this is there any way to get the count of records that has been inserted successfully and the count of records that has failed during insert?

Thanks!

Answer 1

For that you'll need to use Database.SaveResult and iterate through the results to check whether it's a success or a fail:

Database.SaveResult[] saveResult = Database.insert(accounts, false);
Integer counter = 0;

for (Database.SaveResult sr : saveResult) 
{
    if (sr.isSuccess()) 
    {
        counter++;
    }
}

system.debug(counter); // Total number of successfully inserted accounts

Answer 2

Can't give you code but you can proceed with following hints:-

• Implement Database.stateful with your batchable inteface
• Declare two/one instance variable which will store failed and successful insert records information

• Leverage Database.insert result as:

  Database.SaveResult[] srList = Database.insert(accts, false);

  // Iterate through each returned result
  for (Database.SaveResult sr : srList) {
      if (sr.isSuccess()) {
          // Operation was successful, so get the ID of the record that was processed
          // fill list with successfult IDs + sr.getId()); // new Ids
      }
      else {
          // Operation failed, so get all errors                
          for(Database.Error err : sr.getErrors()) {
              // get error fields and other stuff from Error class
          }
      }
  }
  

• After it, in finish() method you can collect and process information for failed and successful records.

Answer 3

You have to implement Database.Stateful in your batch class and then you can have instance variables that don't lose state between batches.

global class implements Database.Batchable<sobject>, Database.stateful{

  public String query = 'Select id from Opportunity' ; 
  public Integer totalAmtOfRecords = 0; 

  global Database.QueryLocator start(Database.BatchableContext BC) {
     return Database.getQueryLocator(query);
   }

   global void execute(Database.BatchableContext BC, List<sobject> scope) {  
      totalAmtOfRecords += scope.size();
      //your logic ...
    }

     global void finish(Database.BatchableContext BC) {
        // Print Total amount of records processed in Batch Job
        system.debug('Total amount of records processed :' + totalAmtOfRecords);  
     }

   }

For more details check : How To Get Total Amount Of Records Processed In Batch Job In 10 Minutes And Still Look Your Best