[SalesForce] System.DmlException: Insert failed. First exception on row 0; first error:

I have the error message above, but I am not sure, what else to take care of.
My Code is the following and the error is in a test class

My Code:

trigger AddAccEuroAISNo on Task (before insert, before update) {
for (Task a : trigger.new){ 
          if(Task.WhoId != null){
        String WhoIdString = String.valueof(a.WhoId);
            if (WhoIdString.substring(0,3) == '003'){
            Contact parent = [SELECT AccountId, Account.Name, Name, EuroAIS_Customer_Number__c  FROM Contact WHERE ID = :a.WhoId ];
            if(parent.AccountId  != null){
            a.Account__c = parent.Account.Name;
            a.EuroAISCustomerId__c = parent.EuroAIS_Customer_Number__c;
            a.Contact__c = parent.Name;
            }}}}}

The Error Message:

Test_MergeCasesController.caseMergeTestMethod(), Details: System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, AddAccEuroAISNo: execution of BeforeInsert caused by: System.NullPointerException: Attempt to de-reference a null object Trigger.AddAccEuroAISNo: line 5, column 1: [] Class.MergeCasesController.mergeCases: line 181, column 1 Class.Test_MergeCasesController.caseMergeTestMethod: line 48, column 1

Thanks a lot in advance for any help

Best Answer

The problem is that you are not setting a value for the WhoId on the Task that you are inserting.

What is essentially happening is this:

Task a = new Task();
String WhoIdString = String.valueof(a.WhoId);
system.debug(WhoIdString);
system.debug(WhoIdString.substring(0,3) == '003');

In this line of your code:

if(Task.WhoId != null){

it looks like you are attempting to check for null values, if you change it to:

if(a.WhoId != null){

you will not get the error message, but your test will also not cover the code inside the if block.

Related Solutions

[SalesForce] Execution of BeforeInsert caused by: System.NullPointerException: Attempt to de-reference a null object

The reason you are getting a NullPointerException here is because rts is null. Your code makes an assumption that the Id value of acc.RecordTypeId will be the name of an instance of your RecordTypeSetting__c custom setting. In this case, that assumption appears flawed. The most basic fix would be to add a null check on rts:

RecordTypeSetting__c rts = RecordTypeSetting__c.getInstance(acc.RecordTypeID);
if (rts != null)
{
    acc.RecordTypeId = GetNameFromOldId.get(rts.Record_Type_Name__c);
}

[SalesForce] System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY

You have to create your own test data. This line assumes you can split a string before checking if it is null:

Set<String> readOnlyprofiles = new Set<String>(Integration__c.getOrgDefaults().Account_Name_Read_Only_Profiles__c.split(','));

Instead, you must either add a null check, or have your test actually create this custom setting record.

String names = Integration__c.getOrgDefaults().Account_Name_Read_Only_Profiles__c;
Set<String> readOnlyProfiles = (names == null) ? new Set<String>() : new Set<String>(names.split(',')

Or in your test:

insert new Integration__c(Account_Name_Read_Only_Profiles__c='foo,bar,etc');

Granted, there are probably better ways to check if the running user has a permission. I highly recommend you instead consider using a Custom Permission and then just assigning it to the profiles you would like to whitelist.

if (Trigger.isUpdate && FeatureManagement.checkPermission('IsAccountNameReadOnly'))

Best Answer

Related Solutions

[SalesForce] Execution of BeforeInsert caused by: System.NullPointerException: Attempt to de-reference a null object

[SalesForce] System.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY

Related Topic