Email Notification to manager is not working

[rajsannidhi]

Email notification is not working, it used to work not sure what causing the issue, below is the email body and using binding variable ${userEmail} to send email to manager, 

A new vendor has been created

<table>
<tr>
<th>VendorUsername</th>
<th>First Name</th>
<th>Last Name</th>
<th>Company</th>
<th>Employeetype</th>
<th>Manager Name</th>
<th>Date Created</th>
<th>CREATEDBY</th> </tr>
<% int count=Integer.parseInt("${ANALYTICSDATA.size()}"); for(int i=0;i<count;i=i+1){%> <tr>
<td>${ANALYTICSDATA.'VendorUsername'[i]}</td>
<td>${ANALYTICSDATA.'First Name'[i]}</td>
<td>${ANALYTICSDATA.'Last Name'[i]}</td>
<td>${ANALYTICSDATA.'company'[i]}</td>
<td>${ANALYTICSDATA.'employeetype'[i]}</td>
<td>${ANALYTICSDATA.'Manager Name'[i]}</td>
<td>${ANALYTICSDATA.'Date Created'[i]}</td>
<td>${ANALYTICSDATA.'CREATEDBY'[i]}</td> </tr> <% } %> </table>

Analytics Query

select
u.username AS 'VendorUsername',
u.FIRSTNAME as 'First Name',
u.LASTNAME AS 'Last Name',
u.Companyname as company,
u.employeetype as employeetype,
u.CREATEDATE as 'date created',
m.displayname as 'Manager Name',
m.email as 'Manager Email',
m.username AS 'USERNAME',
u.OWNER as Owner,
u.createdby as 'CREATEDBY'
from users u,
users m
where u.CREATEDATE > NOW() - INTERVAL 24 HOUR
and u.manager = m.userkey
and u.statuskey = 1
and u.employeetype in ('Vendor','Contractor')
and u.orgunitid in ('ABC')

Logs

[rushikeshvartak]

This is known product defect in 24.5 please raise support ticket

[rajsannidhi]

@rushikeshvartak Thank you will submit a support ticket. But it was working couple months ago.