Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/04/2023 03:51 AM
Binding variable ${userEmail} doesn't work in EIC v23.6.
We have analytics where there are records for each user. The mail doesn't go out to the users when we use ${userEmail} binding variable.
This was working fine in 5.5 SP 3.8 and stopped working when we migrated to EIC v23.6.
Any idea of the alternate variable we can use. Please let me know.
Thank You.
Solved! Go to Solution.
10/04/2023 03:53 AM - edited 10/04/2023 03:55 AM
Hi @subash10 ,
What's the error you are getting in the logs? Also make sure "Send Email As Attachment" checkbox is true in analytics. Sometime during migration that checkbox get unchecked, we faced this issue.
10/04/2023 04:07 AM
No error in logs. Just that nothing is there in TO field in the logs. Also "Send email as attachment is checked and email template".
10/04/2023 04:52 AM
@subash10 Provide your analytics query. Also, check whether its working in data analyzer?
10/04/2023 05:34 AM
QUERY : select distinct u.username as 'USERNAME', count(sr.riskcode) as 'VIOLATION COUNT', sr.LASTIMPORTDATE as 'whendetected' from sodrisks sr inner join risks r on r.riskid = sr.RISKKEY and sr.status = 1 inner join sodrisk_entitlement se on se.SODKEY = sr.SODKEY inner join riskowners ro on ro.RISKID = r.riskid inner join users u on u.USERKEY = ro.OWNERUSERKEY group by u.username;
10/05/2023 07:09 AM
Did you try to recreate the analytics? Also I assume this is V2 analytics right?
10/06/2023 05:40 AM
Yes, I tried it and it doesn't work either.
10/06/2023 06:31 AM
11/24/2023 03:08 AM
The problem here was that it was missing "From" in the email template. It worked in 5.5 without From but it doesn't work in 23.6. It is fixed now. Thank you for all the help.