Binding variable ${userEmail} doesn't work in EIC v23.6. Any alternate variable?

[subash10]

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.

[pmahalle]

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.

[subash10]

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".

[pmahalle]

@subash10 Provide your analytics query. Also, check whether its working in data analyzer?

[subash10]

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;

[sk]

Did you try to recreate the analytics? Also I assume this is V2 analytics right?

[subash10]

Yes, I tried it and it doesn't work either.

[sk]

@subash10 : Can you pls share the email template?

[subash10 · Accepted solution]

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.