You need to sign in to do that
Don't have an account?
Matt 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.
which line is generating the error?