Alert Message while executing the analytics

[PuspanjaliM]

Hi Team,

I created one analytics by "using SQL Query".

Query code

select u.username, u.employeetype, u.customproperty36, u.firstname, u.lastname , u.email , u.employeeid, u.customproperty7 as StartDate, u.CREATEDATE from users u where u.CREATEDATE > DATE_SUB(CURDATE(), INTERVAL 15 DAY) and u.statuskey = 1 and u.USERKEY not in ( select userkey from user_accounts where accountkey in (select accountkey from accounts where endpointkey = (select endpointkey from endpoints where endpointname='ActiveDirectory')))

But while trying to execute the analytic it's giving me below error.

How I can fix this.

[nimitdave]

You can try scheduling the analytics to a time when least number of jobs are running.

And if you are still facing the issue please raise an support ticket.

[rushikeshvartak]

Column name should not end with date keyword change column alias