Error: Upsert failed. First exception on row 1; first-error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY

Created by Alsabana Sahubarali, Modified on Mon, 4 Nov, 2024 at 9:12 AM by Alsabana Sahubarali

The full error looks like this:

Upsert failed. First exception on row 1; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, JobContact_CascadeJobs: execution of AfterInsert caused by: System.DmlException: Update failed. First exception on row 0 with id a086000000SuQU8AAN; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, Job_UpdateClientAccountStatus: execution of AfterUpdate caused by: System.DmlException: Update failed. First exception on row 0 with id 0016000000cFWesAAG; first error: FIELD_FILTER_VALIDATION_EXCEPTION, Value does not exist or does not match filter criteria.: [Marketing_Ask_Global_Sub_Campaign__c] Class.Job_UpdateClientAccountStatus.executeProcessing: line 183, column 1 Trigger.Job_UpdateClientAccountStatus: line 49, column 1: [] Class.JobContact_CascadeJobs.execute: line 22, column 1 Class.JobContactTrigger.execute: line 35, column 1 Trigger.JobContact_CascadeJobs: line 4, column 1: []

Error is in expression '{!saveJobContacts}' in component <apex:commandButton> in page job_selectemployees: Class.Job_SelectEmployees.saveByEmployees: line 199, column 1
Class.Job_SelectEmployees.saveJobContacts: line 173, column 1

An unexpected error has occurred. Your development organization has been notified.

The key words are: Value does not exist or does not match filter criteria.: [Marketing_Ask_Global_Sub_Campaign_c]

ThisÂ errorÂ occurs when the global and global sub campaign values are not from the same family. For exampleÂ Global Campaign = Internet and Global Sub = Print Ads. The idea is to track marketing down to the job levelÂ (e.g. user adds an extra clean because of MACS special when they originally came in from Direct Mail).Â The root cause is ticketed to be fixed, but in the meantime aligning your campaigns will prevent the error.