Apex Code Development You need to sign in to do that
Don't have an account?
LeadorContactId field on campaign member suddently not accessible
I am working with an Org, and I have used the LeadOrContactID standard field on Campaign Member as a convinient lookup to a campaign member without having to have a decision element to determine which type of ID is being used, and to do a seperate lookup.
I have this on one flow that is around 10 months old, and has been working perfectly. I needed another flow on Campaign Member yesterday, so I used it again. I completely tested and it was working fine as of yesterday end of day.
At about 10:30 this morning, I began getting users emailing about errors with records that involved both of these flows that could not save because of an error. When digging in to it, I found that the Lookup portions of the flow were failing, becasue the flow could not find a Campaign Member record when using the LeadOrContactID as one of the criteria.
So I figured I would create a custom LeadOrContactId field, using a formula field. I verified on the page layout that the field is returning the correct lead or contact ID. But the flow still fails, for the same reason - It looks like it cannot be used as the criteria for lookup.
I re-crafted both flows with decision elements to take care of this.
Any idea why both flows would quit so suddenly?
I have this on one flow that is around 10 months old, and has been working perfectly. I needed another flow on Campaign Member yesterday, so I used it again. I completely tested and it was working fine as of yesterday end of day.
At about 10:30 this morning, I began getting users emailing about errors with records that involved both of these flows that could not save because of an error. When digging in to it, I found that the Lookup portions of the flow were failing, becasue the flow could not find a Campaign Member record when using the LeadOrContactID as one of the criteria.
So I figured I would create a custom LeadOrContactId field, using a formula field. I verified on the page layout that the field is returning the correct lead or contact ID. But the flow still fails, for the same reason - It looks like it cannot be used as the criteria for lookup.
I re-crafted both flows with decision elements to take care of this.
Any idea why both flows would quit so suddenly?
Hi Craig,
Greetings!
It could be the data issue while dealing with the different records.So,can you please provide us the exact error message(which you got in the mail) to confirm the root cause.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Warm Regards,
Shirisha Pathuri
It is not possible to check the exact error with the provided Gack Id as the issue is with the flow.
So,can you please copy paste the complete email content to check the flow of the execution and assit you.
Also,in future if you see any issues with the Process builder or flow the I would suggest you to create the debug logs with the finest on Workflow rules to capture the logs which will give you the complete execution which will give you an idea on the root cause of the issue.
Thank you!
Flow Details
Flow API Name: Task_Set_date_of_last_Communication_activity_for_campaign_member
Type: Autolaunched Flow
Version: 1
Status: Active
Org: STARC Systems (00D410000007oad)
Flow Interview Details
Interview Label: Task - Set date of last Communication activity for campaign member 5/1/2020 9:53 AM
Current User: Erin Buehler (0052M000008dFHq)
Start time: 5/1/2020 9:53 AM
Duration: 0 seconds
How the Interview Started
Erin Buehler (0052M000008dFHq) started the flow interview.
Some of this flow's variables were set when the interview started.
varTaskId = 00T2M00003i2zyFUAQ
FAST LOOKUP: Task_Information
Find all Task records where:
Id Equals {!varTaskId} (00T2M00003i2zyFUAQ)
Store the values of these fields in Task_Information: WhoId, OwnerId, Id
Result
Successfully found records.
FAST LOOKUP: Matching_Campaign_Members
Find all CampaignMember records where:
LeadOrContactId Equals {!Task_Information.WhoId} (0032M00002gZwppQAC)
Store the values of these currently referenced fields in Matching_Campaign_Members: Last_Sales_Activity_By__c, Last_Sales_Activity_Date__c, Id
Because Matching_Campaign_Members is passed to an action, subflow, or Lightning component, store the values of all CampaignMember fields that the running user has acces to.
Result
Failed to find records.
Flow Details
Flow API Name: Task_Set_date_of_last_Communication_activity_for_campaign_member
Type: Autolaunched Flow
Version: 1
Status: Active
Org: STARC Systems (00D410000007oad)
Flow Interview Details
Interview Label: Task - Set date of last Communication activity for campaign member 5/1/2020 9:53 AM
Current User: Erin Buehler (0052M000008dFHq)
Start time: 5/1/2020 9:53 AM
Duration: 0 seconds
How the Interview Started
Erin Buehler (0052M000008dFHq) started the flow interview.
Some of this flow's variables were set when the interview started.
varTaskId = 00T2M00003i2zyFUAQ
FAST LOOKUP: Task_Information
Find all Task records where:
Id Equals {!varTaskId} (00T2M00003i2zyFUAQ)
Store the values of these fields in Task_Information: WhoId, OwnerId, Id
Result
Successfully found records.
FAST LOOKUP: Matching_Campaign_Members
Find all CampaignMember records where:
LeadOrContactId Equals {!Task_Information.WhoId} (0032M00002gZwppQAC)
Store the values of these currently referenced fields in Matching_Campaign_Members: Last_Sales_Activity_By__c, Last_Sales_Activity_Date__c, Id
Because Matching_Campaign_Members is passed to an action, subflow, or Lightning component, store the values of all CampaignMember fields that the running user has acces to.
Result
Failed to find records.