[SalesForce] CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY – INVALID_CROSS_REFERENCE_KEY

I'm also getting a the following error from my apex test and trigger while validating. The error,test class and trigger are below.

Run Failures: TestAfterPOLogUpdateTest.myUnitTest System.DmlException:
Insert failed. First exception on row 0; first error:
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, TriggerNewYushinProd: execution
of AfterInsert caused by: System.DmlException: Insert failed. First
exception on row 0; first error: INVALID_CROSS_REFERENCE_KEY, Record
Type ID: this ID value isn't valid for the user: 012180000004huPAAQ:
[RecordTypeId]

Test Class:

    @IsTest
public class TestAfterPOLogUpdateTest {

    static testMethod void myUnitTest() {
        // TO DO: implement unit test
        
        test.startTest();

        PageReference pageRef = Page.OppTabDetailinsidesales2;
           
      Opportunity opp = new Opportunity();
        
          opp.Name ='Bob Inc.';
          opp.AccountId ='0017000000NAEsZ';
          opp.StageName='Quoting';
          opp.Who_is_quoting__c='Inside Sales';
          opp.CloseDate=System.today();
   
          insert opp;
          
        
          opp.Name ='Bob Inc.';
          opp.AccountId ='0017000000NAEsZ';
          opp.StageName='Quoting';
          opp.Who_is_quoting__c='Regional Manager';
          opp.CloseDate=System.today();
    
          update opp;
          
          Yushin_Product__c yus = new Yushin_Product__c ();
          yus.Account__c ='0017000000NAEsZ';
          yus.Opportunity__c='0063900000sutn9';
          yus.PO_Log__c='a4C39000000QFKO';
          yus.Equipment_Type__c= 'A-Axis';
         
          yus.Product_Detail_Report__c = 'EOAT-SM';
          yus.Discharge_Direction__c ='Clamp Traverse';
          yus.RecordTypeId='012390000006Dvb';
          
          
          insert yus;
          
               
          yus.Equipment_Type__c = 'Servo Trav 600 and under';
          yus.Model__c='RCII-100S-11-8.5';
          yus.Price__c =45080;
          yus.IMM_Mfr__c = 'Toshiba';
          yus.Status__c ='Sold';
          yus.Booked_Date__c = Date.newInstance(2016, 12, 9);
          yus.PO_Log__c='a4C39000000QFKO';
          yus.Discharge_Direction__c ='Clamp Traverse';
          yus.Product_Detail_Report__c = 's-R';
          yus.RecordTypeId='012390000006Dve';
        
          update yus;
          
          
          
          yus.Equipment_Type__c = 'Installation';
          yus.Product_Detail_Report__c = 'Installation';
          update yus;
          
          
          yus.Equipment_Type__c = 'EOAT';
          yus.Price__c = 499;
          yus.Model__c='HOP 750';
          update yus;
           
          
          yus.Equipment_Type__c = 'Safety Guarding';
          yus.Product_Detail_Report__c = 'AUTO-SM';
          yus.RecordTypeId='012390000006Dvb';
          update yus;
           
          yus.Equipment_Type__c = 'Conveyor';
          yus.Price__c =45080;
          yus.Status__c ='Sold';
          yus.Date_Booked__c = Date.newInstance(2016, 12, 9);
          yus.Date_Entered__c = Date.newInstance(2016, 12, 8);
          yus.Quantity__c= 1;
          yus.PO_Log__c='a4C39000000QFKO';
          yus.Product_Detail_Report__c = 'AUTO-SM';
          yus.RecordTypeId='012390000006DvZ';
          update yus;
           
          yus.Price__c =45080;
          yus.Equipment_Type__c = 'Servo Trav over 600';
          yus.Model__c='FRA-1530S-22-11-C1  ';
          yus.RecordTypeId='012390000006Dve';
          update yus;
           
         
          yus.Price__c =45080;
          yus.Equipment_Type__c = 'Adapter Plate';
          yus.Product_Detail_Report__c='Misc. Item';
          update yus;
           
          yus.Price__c =45080;
          yus.Equipment_Type__c = 'A-Axis';
          yus.Product_Detail_Report__c='EOAT-SM';
          yus.RecordTypeId='012390000006Dva';
          update yus;
          
          yus.Price__c =45080;
          yus.Equipment_Type__c = 'B-Axis';
          yus.RecordTypeId='012390000006Dva';
          update yus;
           
          yus.Price__c =45080;
          yus.Equipment_Type__c = 'Freight';
          yus.Product_Detail_Report__c='Freight';
          update yus;
           
          yus.Price__c =45080;
          yus.Equipment_Type__c = 'Degating Station';
          yus.Product_Detail_Report__c='AUTO-SM';
          update yus;
           
          yus.Equipment_Type__c = 'Installation';
          yus.Product_Detail_Report__c='Installation';
          update yus;
           
          yus.Equipment_Type__c = 'Hybrid';
          yus.Product_Detail_Report__c='SM-Hybrid';
          yus.RecordTypeId='012390000006Dve';
          
          update yus;
           
          yus.Equipment_Type__c = 'Software';
          yus.Product_Detail_Report__c='Software';
          update yus;
           
          yus.Equipment_Type__c = 'Servo Traverse Super Large 1300 and greater';
          yus.Model__c='RAII-a-3000SL';
          yus.RecordTypeId='012390000006Dve';
          update yus;
           
          yus.Equipment_Type__c = 'Spacer';
          yus.Product_Detail_Report__c='Misc. Item';
          update yus;
           
          yus.Equipment_Type__c = 'Stanchion';
          update yus;
          
          yus.Equipment_Type__c = 'Servo Trav over 600';
          yus.Model__c='YCII-800D-30-18';
          yus.Product_Detail_Report__c='LG-YC';
          yus.RecordTypeId='012390000006Dve';
          update yus;
           
          yus.Equipment_Type__c = 'System - SMALL';
          yus.Product_Detail_Report__c='AUTO-SM';
          update yus;
           
          yus.Equipment_Type__c = 'Collaborative robot';
          yus.Model__c='OB7';
          yus.Product_Detail_Report__c='SPECIAL';
          update yus;
           
          yus.Equipment_Type__c = 'Side-entry (horz)';
          yus.Model__c='SVR B50';
          yus.Product_Detail_Report__c='SM-SE';
          yus.RecordTypeId='012390000006Dve';
          update yus;
           
          yus.Equipment_Type__c = 'Side-entry (Vert)';
          yus.Product_Detail_Report__c='SM-SE';
          yus.RecordTypeId='012390000006Dve';
          update yus;
           
          yus.Equipment_Type__c = 'Parts';
          yus.Product_Detail_Report__c='Misc. Item';
          update yus;
          
          yus.Equipment_Type__c = 'Safety Guarding';
          yus.Product_Detail_Report__c='AUTO-SM';
          yus.RecordTypeId='012390000006Dvb';
          update yus;
           
           
           
         Request_for_Special_Payment__c rsp = new Request_for_Special_Payment__c ();  

            rsp.Opportunity_Name__c = '0063900000sutn9';
            rsp.Requestor_Submit_for_Approval__c = true;
            rsp.Request_Submitted_By__c = 'Bob Poliquin';
            rsp.Requestor_Date_Submitted__c=System.today();
            
            insert rsp;
            
            
            rsp.Opportunity_Name__c = '0063900000sutn9';
            rsp.Supervisor_Approved__c = true;
            rsp.Rejected_By__c='Chris Parillo';
            rsp.Supervisor_Approval_Date__c=System.today();
            
            update rsp;
            
            

      PO_Log__c pol = new PO_Log__c( Customer__c='0017000000NAEsZ',Opportunity__c='0063900000sutn9',Yushin_Product__c='a0639000020MH67', Order_Type__c='EOAT' );
      insert pol;
      
          pol.Opportunity__c='0063900000sutn9';
          pol.PO__c = '12345';
          pol.Sales_Order_Number__c = '12453';
          pol.Order_Type__c = 'Robot';
          pol.AddPLogOpps__c = true;
          pol.Notes__c= 'text';
          pol.Order_Configuration__c = 'ATC';
          pol.Sales_Order_Number__c = '189345';
          pol.AddPLogOpps__c = true;
      
          update pol;
          
          

      

      test.stopTest();
    }
}

Trigger:

   trigger TriggerNewYushinProd on Opportunity ( after insert, after update) {
    
    List<Yushin_Product__c> yus = new List<Yushin_Product__c>();
    List<Yushin_Product__c> yusToDelete = new List<Yushin_Product__c>();
    
    Map<Id, List<Yushin_Product__c>> existingYusMap = new Map<Id, List<Yushin_Product__c>>();
    
    for(Yushin_Product__c yu :[SELECT Id, Opportunity__c, Account__c, Equipment_Type__c from Yushin_Product__c where Opportunity__c IN :Trigger.newMap.keyset()]){
        List<Yushin_Product__c> yushinProducts = existingYusMap.get(yu.Opportunity__c);
        if (yushinProducts == null) {
            yushinProducts = new List<Yushin_Product__c>();
        }
        yushinProducts.add(yu);
        existingYusMap.put(yu.Opportunity__c, yushinProducts);
    }
    
    
    
    for(Opportunity o : Trigger.new)  {
        if (Trigger.IsInsert || Trigger.oldMap.get(o.Id).Product_Type__c == null) {
            if(o.Product_Type__c != null && o.Product_Type__c.contains('Robot'))               
            {                
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='Robot'; 
                y.RecordTypeId='012180000004huP';               
                yus.add(y);
            }
            
            if(o.Product_Type__c != null && o.Product_Type__c.contains( 'EOAT'))                
            {
                
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='EOAT';
                y.RecordTypeId='012180000004huU';               
                yus.add(y);
            }
            
            if(o.Product_Type__c != null && o.Product_Type__c.contains('Conveyor'))               
            {                
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='Conveyor';
                y.RecordTypeId='012180000004huZ';
                yus.add(y);
            }
            
            if(o.Product_Type__c != null && o.Product_Type__c.contains('Other'))               
            {                
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='Other';
                yus.add(y);
            }
        }
        else if (Trigger.IsUpdate && Trigger.oldMap.get(o.Id).Product_Type__c != null) {
            if(o.Product_Type__c != null && o.Product_Type__c.contains('Robot') && !Trigger.oldMap.get(o.Id).Product_Type__c.contains('Robot'))
            {
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='Robot';
                y.RecordTypeId='012180000004huP'; 
                yus.add(y);
            }
            
            if((o.Product_Type__c == null || !o.Product_Type__c.contains('Robot')) && Trigger.oldMap.get(o.Id).Product_Type__c.contains('Robot'))
            {
                List<Yushin_Product__c> yPs = existingYusMap.get(o.Id);
                for (Yushin_Product__c yP : yPs) {
                    if (yP.Equipment_Type__c == 'Robot') {
                        yusToDelete.add(yP);
                    }
                }
            }
            
            if(o.Product_Type__c != null && o.Product_Type__c.contains('EOAT') && !Trigger.oldMap.get(o.Id).Product_Type__c.contains('EOAT'))
            {                    
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='EOAT';  
                y.RecordTypeId='012180000004huU';                 
                yus.add(y);
            }
            
            if((o.Product_Type__c == null || !o.Product_Type__c.contains('EOAT')) && Trigger.oldMap.get(o.Id).Product_Type__c.contains('EOAT'))
            {
                List<Yushin_Product__c> yPs = existingYusMap.get(o.Id);
                for (Yushin_Product__c yP : yPs) {
                    if (yP.Equipment_Type__c == 'EOAT') {
                        yusToDelete.add(yP);
                    }
                }
            }
            
            if(o.Product_Type__c != null && o.Product_Type__c.contains('Conveyor') && !Trigger.oldMap.get(o.Id).Product_Type__c.contains('Conveyor'))                    
            {                    
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='Conveyor';
                y.RecordTypeId='012180000004huZ';
                yus.add(y);
            }
            
            if((o.Product_Type__c == null || !o.Product_Type__c.contains('Conveyor')) && Trigger.oldMap.get(o.Id).Product_Type__c.contains('Conveyor'))
            {
                List<Yushin_Product__c> yPs = existingYusMap.get(o.Id);
                for (Yushin_Product__c yP : yPs) {
                    if (yP.Equipment_Type__c == 'Conveyor') {
                        yusToDelete.add(yP);
                    }
                }
            }
            
            if(o.Product_Type__c != null && o.Product_Type__c.contains('Safety Guarding') && !Trigger.oldMap.get(o.Id).Product_Type__c.contains('Safety Guarding'))                    
            {                    
                Yushin_Product__c y=new Yushin_Product__c();
                y.Opportunity__c=o.Id;
                y.Account__c=o.AccountId; 
                y.Equipment_Type__c='Safety Guarding';
                y.RecordTypeId='012180000004hue';
                yus.add(y);
            }
            
            if((o.Product_Type__c == null || !o.Product_Type__c.contains('Safety Guarding')) && Trigger.oldMap.get(o.Id).Product_Type__c.contains('Safety Guarding'))
            {
                List<Yushin_Product__c> yPs = existingYusMap.get(o.Id);
                for (Yushin_Product__c yP : yPs) {
                    if (yP.Equipment_Type__c == 'Safety Guarding') {
                        yusToDelete.add(yP);
                    }
                }
            }
        }
    }  
 
    if(yus.size()>0)
        insert yus;
    if(yusToDelete.size()>0)
        database.delete(yusToDelete);
}

Best Answer

As I can see in your code you have hardcoded the ID of records and Record types, this is a bit problematic.

Now the code you have written references recordTypeID. Record type you created in your Sandbox will have different ID than the one you created in Live.

Thus while validating, it gives you that exception that it could not find the(Sandbox recordtype Id) in the prod environment.

You have to remove hardcoding using custom lables or Describe generic method.

Related Solutions

[SalesForce] Test Class for a trigger failure: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY

Let's break down the error message you received:

System.DmlException: Insert failed. This is where the error was thrown. During all of the processing that happens behind the scenes of an insert (e.g. triggers, validation rules, workflows, etc), something went wrong.

First exception on row 0; If the failed insert included multiple rows to insert, this would tell you which row caused the first failure.

first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, This is a fairly catch-all error that just means an insert/update/upsert failed; keep reading for more info.

changeUnauthorizedClockinOwner: execution of BeforeInsert Now we are getting somewhere. The actual error occured in the trigger changeUnauthorizedClockinOwner during execution of a Before Insert call.

caused by: System.QueryException: List has no rows for assignment to SObject And here we are - the root cause. "List has no rows for assignment to SObject" happens when you assign a query to an SObject variable instead of a list variable, and the query returns no records.

A brief aside to discuss this error: Consider these three queries:

Account a1 = [Select id, name from Account where name='Acme, Inc.'];

Account a2 = [Select id, name from Account where name='Acme, Inc.' limit 1];

list<Account> accts = [Select id, name from Account where name='Acme, Inc.'];

The first query will only work (without throwing an exception) if there is EXACTLY 1 Account named "Acme, Inc." If there are 0 or 2+ accounts, the result can't be assigned to an SObject. The second query will handle the 2+ scenario, as the limit ensures only 1 record will be returned, but if there are 0 accounts, the above error will be thrown. The third query handles all of these cases; if there are 0 accounts, the result is an empty list; you can test (accts.size()==0) in your code. If you know you only want the first result, you can still use limit 1 and assign to the list variable. Just remember that limit 1 only limits the maximum results, not the minimum; it doesn't make it safe to blindly assign to a singular SObject variable.

As a rule, you should always assign a query result to a list and test the list. If your logic has a good reason to believe that exactly one record should exist (e.g., querying for a Profile), you should wrap the query in a try-catch block and gracefully handle any errors.

Back to breaking down the error:

Trigger.changeUnauthorizedClockinOwner: line 10, column 1: [] Here's where you tried to assign a query an SObject. The line number doesn't match up to your code above, which I assume you may have truncated or reformatted for this site. Take a look in the Developer Console or editor of your choice and see what query starts on line 10.

Stack Trace Class.TestChangeUnauthorizedClockinOwner.TESTOwnerChange: line 39, column 1 Finally, a list of the method calls leading to the error; in this case, it's just the code that invoked the trigger; Line 39 is sure to be an insert statement.

With the line numbers not matching up, it's a little hard to be sure, but I'm pretty sure that your trigger's query to assign newOwner is returning no results. Why? You are querying Clock_in_out_Date__c for the newly inserted record, but you are in the before trigger, so the record has not been inserted yet. You need to query the HR_Data_User__c table directly.

You also need to "bulkify" your trigger. Even if you expect these records to only be inserted one-at-a-time, the system can gather up several inserts and process them at once. See the online docs for more on bulkification. Here's your trigger, properly bulkified to update the owner via the HR_Data_User__r relationship. Note that this code assumes HR_Data_User__c will never be null on an inserted record (just as your code did).

trigger changeUnauthorizedClockinOwner on Clock_in_out_Date__c (before insert, before update) {
// Get the record type id based on name Unplanned Outage
    RecordType unplannedOutage = [select Id from RecordType where Name = 'Unplanned Outage' and SobjectType = 'Clock_in_out_Date__c' limit 1];

    //gather all of the HR_Data_User__c Ids for all of the records being inserted
    set<id> hrIds = new set<id>();
    for(Clock_in_out_Date__c newRecord: trigger.new) {
        hrIds.add(newRecord.HR_Data_User__c);
    }

    //look up the owners; building a map of HR_Data_User__c Ids to HR_Data_User__c objects
    map<id, HR_Data_User__c> userMap = new map<id, HR_Data_User__c>([select id, OwnerId from HR_Data_User__c where id in hrIds]);

    // Update the owner when it matches the Unplanned Outage ID          
    for(Clock_in_out_Date__c newRecord: trigger.new) {
        //if HR_Data_User__c is null, we can't lookup the correct user, so skip
        if (newRecord.HR_Data_User__c!=null) {
            if (newRecord.RecordTypeId==unplannedOutage.id){
                newRecord.OwnerId=userMap.get(newRecord.HR_Data_User__c).OwnerId;
            }
        }
    }
}

[SalesForce] CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: execution of AfterInsert

By the looks of it, there must be a code in your trigger that is trying to create new or update a product's pricebook entry.

When you don't use the annotation SeeAllData=true, your test class doesn't have access to the existing data in your instance. It only has access to whatever records you are creating in your test methods. In this case, you are inserting a product but when your trigger runs it looks for the product's pricebook entry and can not create/update it because it doesn't have access to the pricebooks.

At this point creating pricebooks in your test methods is not supported

"Inserting a pricebook entry for a product isn’t feasible from a test since the standard pricebook isn’t accessible and can’t be created in a running test. Also, inserting a pricebook entry for a custom pricebook isn’t supported since this requires defining a standard pricebook. For such situations, annotate your test method with IsTest(SeeAllData=true) so that your test can access organization data."

Quoted text from here - which leaves you with only 1 option, you answered it yourself - adding the annotation SeeAllData=true which will allow your test methods to get access to existing data including the pricebooks

Best Answer

Related Solutions

[SalesForce] Test Class for a trigger failure: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY

[SalesForce] CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: execution of AfterInsert

Related Topic