[SalesForce] Get Error record on bulk upsert

I'm upserting a list of SObjects using Database.upsert and I need to know which records are not inserted.

This is an example:

  Account[] accts = new List<Account>{
        new Account(Name='Account1'),
        new Account(Name='Accoun2')};
    Database.upsertResult[] srList = Database.insert(accts, false);

    // Iterate through each returned result
    for (Database.upsertResult sr : srList) {
        if (sr.isSuccess()) {
            // Operation was successful, so get the ID of the record that was processed
            System.debug('Successfully inserted account. Account ID: ' + sr.getId());
        }
        else {
            // Operation failed, so get all errors                
            for(Database.Error err : sr.getErrors()) {
                System.debug('The following error has occurred.');                    
                System.debug(err.getStatusCode() + ': ' + err.getMessage());
                System.debug('Account fields that affected this error: ' + err.getFields());
            }
        }
    }

Is there any way to get the record that caused the error from Database.upsertResult ??

Best Answer

Change your loop from for-each to indexed:

for(Integer idx = 0; idx < srList.size(); idx++) {
    if(srList[idx].isSuccess()) {
        ...
    } else {
        ...
    }
}

srList[idx] will correspond to accts[idx].

This is guaranteed in the documentation:

An array of Database.UpsertResult objects is returned with the upsert database method. Each element in the UpsertResult array corresponds to the sObject array passed as the sObject[] parameter in the upsert Database method; that is, the first element in the UpsertResult array matches the first element passed in the sObject array, the second element corresponds with the second element, and so on. If only one sObject is passed in, the UpsertResults array contains a single element.

Related Solutions

[SalesForce] Specific User returns empty query

I would suggest to bulkify a query like this:

List<User> users = [Select id from User where name = 'Data Admin' limit 1];
if ( users.size() > 0 ) {
   ID DataAdmin = users[0].Id;
}

In such case you won't receive error even if your user sharing settings do not allow him to access Data Admin user record.

======

Also, user locale setting might matter. Because in different language you might have different separator between First Name and Last Name and the query might be different like Data|Admin instead of Data Admin, so you might try to query upon LastName or change user locale or language.

[SalesForce] Content Document Link: FIELD_INTEGRITY_EXCEPTION, Document with ID: * is already linked with the entity with ID: *: Linked Entity ID:

You need to put a check to verify if ContentDocumentLink records exist before putting it into final list ContentDocumentList. Logic will be like this.

trigger ContentVersionTrigger on ContentVersion (after insert) {
    if(!TriggerRunOnce.hasAlreadyfired())
    {
        List<user> users = [select user.id, user.Email, user.FirstName, user.LastName, user.profile.name, user.Username, user.IsActive 
        FROM user, user.profile 
        where user.LastName IN ('***','***') and user.IsActive=true];
        Set<Id> contentDocumentIdSet = new Set<Id>();

        for(ContentVersion cv:trigger.new)
        {
            if(cv.ContentDocumentId != null)
            {
                contentDocumentIdSet.add(cv.ContentDocumentId);
            }
        }

        List<ContentDocumentLink> lstContentDocumentlink = [SELECT ContentDocumentId, LINKEDENTITYID 
                                                            FROM ContentDocumentLink WHERE ContentDocumentId IN:contentDocumentIdSet];


        List<ContentDocumentLink> ContentDocumentList = new List<ContentDocumentLink>();


        for(ContentVersion cv:trigger.new)
        {
            system.debug('at 5 '+cv);
            if(cv.ContentDocumentId != null && !lstContentDocumentlink.contains(cv.ContentDocumentId))
            {
                for(user u:users){
                    if(u.Id != cv.OwnerId){
                        ContentDocumentLink cdl = new ContentDocumentLink(ContentDocumentId=cv.ContentDocumentId,LINKEDENTITYID = u.Id,SHARETYPE='C');
                        ContentDocumentList.add(cdl);  
                    }
                }
            }
        }

        insert ContentDocumentList;
        TriggerRunOnce.setAlreadyfired();
    }
}

Best Answer

Related Solutions

[SalesForce] Specific User returns empty query

[SalesForce] Content Document Link: FIELD_INTEGRITY_EXCEPTION, Document with ID: *** is already linked with the entity with ID: ***: Linked Entity ID:

Related Topic

[SalesForce] Content Document Link: FIELD_INTEGRITY_EXCEPTION, Document with ID: * is already linked with the entity with ID: *: Linked Entity ID: