function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Matt HamptonMatt Hampton 

Help - Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY

Hello:

 

I am having some issues getting my Apex Code and Test Class deployed. I am attaching below. Any help would be appreciated as I am still new to Apex. 


There I am getting is system.DmlException: Insert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY

 

Apex Code

 

trigger QualificationUpdate on Video_Qualified_Address__c (after insert) {
Set<String> AddressSet = new Set<String>();
Set<String> LocSet = new Set<String>();
Set<String> ZipSet = new Set<String>();
                     for(Video_Qualified_Address__c s: Trigger.New)
                             {
                                      AddressSet.add(s.parsed_street_address__c);
                                      LocSet.add(s.loc__c);
                                      ZipSet.add(s.zip_code__c);
                              }
                              
list<Fioptics_Inquiry__c> gpon = [select id, name, fiber_qualified__c, street_address__c, location__c, zip_code__c from Fioptics_Inquiry__c where street_address__c IN: AddressSet
and location__c IN: LocSet
and zip_code__c IN: ZipSet];

        if(gpon.size()>0) 
        {Map<ID, Fioptics_Inquiry__c> toUpdate=new Map<ID, Fioptics_Inquiry__c>(); 
        Map<ID, String> FQAID = new Map<ID, String>(); 
        for(Fioptics_Inquiry__c FQAID2: gpon) {Map<String, Fioptics_Inquiry__c> FQAMap = new Map<String, Fioptics_Inquiry__c>(); 
        for(Fioptics_Inquiry__c foa: gpon) {FQAMAP.put(foa.street_address__c + '' + foa.location__c + '' + foa.zip_code__c, foa); } 
        for(Video_Qualified_Address__c s: Trigger.new) {if(FQAMAP.containsKey(s.parsed_street_address__c + '' + s.loc__c + '' + s.zip_code__c)) 
        {Fioptics_Inquiry__c cand = FQAMap.get(s.street_address__c + '' + s.loc__c + '' + s.zip_Code__c); 
        cand.fiber_qualified__c = TRUE; toUpdate.put(cand.id, cand); } } update toUpdate.values(); }

 

Test

 

@isTest
private class TestQualificationUpdate {
static testmethod void testmy(){

//Set up Video Qualified Address for each test
 
Fioptics_Inquiry__c sub1 = new Fioptics_Inquiry__c ();
Sub1.Name='Test Subscriber 1';
Sub1.Street_Address__c='123 MAIN ST';
Sub1.Location__c='APT 1';
Sub1.Zip_Code__c='45202';
insert sub1;

Video_Qualified_Address__c vqa1 = new Video_Qualified_Address__c();
vqa1.RecordTypeID='012C0000000GELv';
vqa1.Name='123 MAIN ST 45202 /APT1';
vqa1.Street_Address__c='123 MAIN ST';
vqa1.Parsed_Street_Address__c='123 MAIN ST';
vqa1.Loc__c='APT 1';
vqa1.Zip_Code__c='45202';
insert vqa1;

Fioptics_Inquiry__c subs1 = [SELECT ID, Fiber_Qualified__c FROM Fioptics_Inquiry__c where id=:sub1.id];
Video_Qualified_Address__c addy1 = [SELECT ID FROM Video_Qualified_Address__c where id=:vqa1.id];

system.assertequals(subs1.Fiber_Qualified__c, TRUE);

Fioptics_Inquiry__c sub2 = new Fioptics_Inquiry__c ();
Sub2.Name='Test Subscriber 2';
Sub2.Street_Address__c='456 MAIN ST';
Sub2.Zip_Code__c='45202';
insert sub2;

Video_Qualified_Address__c vqa2 = new Video_Qualified_Address__c();
vqa2.RecordTypeID='012C0000000GELv';
vqa2.Name='456 MAIN ST 45202';
vqa2.Parsed_Street_Address__c='456 MAIN ST';
vqa2.Zip_Code__c='45202';
insert vqa2;

Fioptics_Inquiry__c subs2 = [SELECT ID, Fiber_Qualified__c FROM Fioptics_Inquiry__c where id=:sub2.id];
Video_Qualified_Address__c addy2 = [SELECT ID FROM Video_Qualified_Address__c where id=:vqa2.id];

system.assertequals(subs2.Fiber_Qualified__c, TRUE);


Fioptics_Inquiry__c sub3 = new Fioptics_Inquiry__c ();
Sub3.Name='Test Subscriber 3';
Sub3.Street_Address__c='123 MAIN ST';
Sub3.Location__c='APT 1';
Sub3.Zip_Code__c='45202';
insert sub3;

Video_Qualified_Address__c vqa3 = new Video_Qualified_Address__c();
vqa3.RecordTypeID='012C0000000GELv';
vqa3.Name='321 MAIN ST 45202 /APT1';
vqa3.Parsed_Street_Address__c='321 MAIN ST';
vqa3.Loc__c='APT 1';
vqa3.Zip_Code__c='45202';
insert vqa3;

Fioptics_Inquiry__c subs3 = [SELECT ID, Fiber_Qualified__c FROM Fioptics_Inquiry__c where id=:sub3.id];
Video_Qualified_Address__c addy3 = [SELECT ID FROM Video_Qualified_Address__c where id=:vqa3.id];

system.assertequals(subs3.Fiber_Qualified__c, FALSE);

 Thanks in advance for any help you can provide.

 

dmchengdmcheng

which line is generating the error?