When I select an email template in Analytics, an error is displayed.

[JohnDoe]

Hello.

I want the Saviynt administrator to be emailed when running OOTB Analytics named "Alert-Failed Application Import Jobs."
But when I select the email template in Send Email As Attachment, I get the message "Operation not allowed as you are entering a value that resembles or contains script code."

I tried with other email templates and the result is the same.
On the other hand, with other Analytics, you can select those email templates without any problem.

What is the cause of this problem?

[sudeshjaiswal]

Hello @JohnDoe,

Please validate your analytics query, it contains some special characters due to which you are getting these errors.

Thanks.

[JohnDoe]

The following is the Analytics Query of the corresponding Analytics.
From what I can see, I can't find any special characters that might be a problem, could you check?

select jobid, jobname, jobstartdate, jobenddate, SAVRESPONSE, case when ecm.EXTERNALCONNECTION is not null then (select e.ENDPOINTNAME from endpoints e where e.SECURITYSYSTEMKEY IN (select s.SYSTEMKEY from securitysystems s where s.EXTERNALCONNECTION IN (select e.EXTERNALCONNECTIONKEY from externalconnection e where e.CONNECTIONNAME=ecm.EXTERNALCONNECTION)) limit 1) when ecm.SYSTEMNAME is not null then (select e.ENDPOINTNAME from endpoints e where e.SECURITYSYSTEMKEY = (select s.systemkey from securitysystems s where s.SYSTEMNAME = ecm.SYStemNAME ) limit 1) else null end as ENDPOINTNAME, case when ecm.EXTERNALCONNECTION is not null then (select e.ENDPOINTKEY from endpoints e where e.SECURITYSYSTEMKEY IN (select s.SYSTEMKEY from securitysystems s where s.EXTERNALCONNECTION IN (select e.EXTERNALCONNECTIONKEY from externalconnection e where e.CONNECTIONNAME=ecm.EXTERNALCONNECTION)) limit 1) when ecm.SYSTEMNAME is not null then (select e.ENDPOINTKEY from endpoints e where e.SECURITYSYSTEMKEY = (select s.systemkey from securitysystems s where s.SYSTEMNAME = ecm.SYStemNAME ) limit 1) else null end as endpointKey from ecmimportjob ecm where ecm.SAVRESPONSE !='success';

[sudeshjaiswal]

Hello @JohnDoe,

Can you please clean/delete the history and run the analytics again?
and please check the logs.

Thanks

[rushikeshvartak]

Alert keyword is blocked in name , hence change name of analytics. Alert keyword is removed from blocklist from v23.4 onwards