Skip to main content

System.FinalException: Sobject rows does not allow errors:

Sometimes we need to show error message from trigger using add error method. This post is all about what are the challenge i faced to display error message.
My requirement is showing error message if an opportunity which is not linked to contact are updated.As we know opportunitycontactrole is junction object which will relate both opportunity and contact. 
So It is so simple, I went for Opportunity beofore update.
trigger OpportunityBeforeUpdate on Opportunity (before update) {       
       OpportynitySequesncecontroller.beforeUpdate();
}
public class OpportynitySequesncecontroller {
      public void static beofeUpdate(){     
               // others logic are there cos many operation might be there on before update
              OpportynityManagement .validateOppty(trigger.newmap)
      }
}
public class OpportynityManagement {
      public void static validateOppty(Map<Id,Opportunity> newOpptyMap){     
               // logic to show error 
      }
}
OpportynityManagement .validateOppty(trigger.newmap) wiil throw error like below 
Error Error: Compile Error: Method does not exist or incorrect signature: OpportunityManagement.validateOppty(Map<Id,SObject>) 



To resolve this error we need to change way of invocation 
public class OpportynitySequesncecontroller {
      public void static beofeUpdate(){     
               // others logic are there cos many operation might be there on before update
              map<Id,Opportunity> newOpptyMap = (map<Id,Opportunity>)trigger.newMap;
              OpportynityManagement .validateOppty(newOpptyMap )
      }
}
Now this the method where adderror method is used.
public static void validateOppty(map<Id,Opportunity> newOpptyMap){
Id SalesOpsRecordTypeId = Schema.SObjectType.Opportunity.getRecordTypeInfosByName().get('Test Sales Opportunity').getRecordTypeId();
list<Opportunity> listOfOpportunity;
if(!newOpptyMap.keyset().isEmpty()){
listOfOpportunity = [SELECT id,(SELECT id FROM opportunitycontactroles) FROM opportunity WHERE recordtypeid =:SalesOpsRecordTypeId AND Id IN :newOpptyMap.keyset()];
for(Opportunity opp:listOfOpportunity){
if(opp.opportunitycontactroles.size() == 0 ){
opp.get(opp.id).addError('Oppotunity can not be modified since it is not having any contacts');
}
}
}
 
}

This code will be complied successfully, but when we update an oppty we can get this exception 
To resolve the above issue method needs to be modified.
public static void validateOppty(map<Id,Opportunity> newOpptyMap){
Id SalesOpsRecordTypeId = Schema.SObjectType.Opportunity.getRecordTypeInfosByName().get('Test Sales Opportunity').getRecordTypeId();
list<Opportunity> listOfOpportunity;
if(!newOpptyMap.keyset().isEmpty()){
listOfOpportunity = [SELECT id,(SELECT id FROM opportunitycontactroles) FROM opportunity WHERE recordtypeid =:SalesOpsRecordTypeId AND Id IN :newOpptyMap.keyset()];
for(Opportunity opp:listOfOpportunity){
if(opp.opportunitycontactroles.size() == 0 && newOpptyMap.containskey(opp.id)){
newOpptyMap.get(opp.id).addError('Oppotunity can not be modified since it is not having any contacts');
}
}
}
 
}

Labels:

Comments

Salesforce Index said…
Thank you for providing such an amazing solution to this error.
27 April 2023 at 00:28
Post a Comment

Popular posts from this blog

How to Create a Tooltip in Lightning Datatable ?

Imagine you have a datatable displaying a list of Contact records , and one of the columns shows the Account Name . The Account Name is a hyperlink that allows users to navigate to the Account record page. But what if users want to take a quick glance at some key Account fields —like Phone or Address—without navigating to the Account record? In Salesforce Classic, this was achieved using the Mini Page Layout feature from standard page. However, in Lightning Experience, we can implement a similar feature by adding a tooltip to the data table. Solution Overview: We’ll create a Lightning Web Component (LWC) that: Displays a data table with a clickable Account Name . Provides a tooltip that shows the Account's Phone and Address fields when users hover over the Account Name. Implementation Steps: 1. Data Preparation We need to retrieve the following fields for each Contact and its associated Account: Contact Fields : Name, Phone, Email Account Fields : Name, Phone, Billing Addre...
Post a Comment
Read more

How to Create/Delete file attachments(Content Document) through Apex ?

 There are 3 standard salesforce objects to store file attachments. Content Document, ContentDocumentVersion, ContentDocumentLink.  Here is the article to talk about these objects and relationship.  https://www.forcetalks.com/blog/contentdocument-and-contentversion-in-salesforce-an-overview/ ContentDocumentVersion ContentDocumentLink This post is all about how to create/delete content document though Apex. Here is code snippet // Insert Content Version record ContentVersion contentVersionRec = new ContentVersion(Title='filename',PathOnClient ='FileName.pdf',VersionData = bodyBlob,origin = 'H'); INSERT contentVersionRec; // this will insert one record in ContentDocument and ContentVersion , ContentDocument  is parent and  ContentVersion is child record // get contentdocument id contentVersionRec = [SELECT Id, Title, ContentDocumentId FROM ContentVersion WHERE Id = :contentVersionRec .Id LIMIT 1]; // Create Content Document Link record- This will attach ...
Post a Comment
Read more

Lifecycle hooks in LWC

There are 3 phase of LWC component  1. Mounting  A. constructor, B. connnectedCallback C. render D. renderedCallback 2. UnMounting  A. disconnectedcallback 3. Error  A.errorcallback Note - render is not lifecycle hook, it is protected method of Lightning element class. Mounting Phase LWC Creation and Render Life cycle Constructor Method ·        This method called when component is instantiated and It flows from parent to child component. ·        Need to call Super() inside constructor method ·        Can’t access any component properties or child component because it’s not ready yet. ·        Host element can be accessed through “this. template” inside constructor method. ·        Don’t add any attributes to host inside constructor C   constructor (){          super (); //...
Post a Comment
Read more