Analytics issue - Alert: Control execution is taking longer than expected.

[Saksi]

Hi, 

When i am trying to run the below query it is returning the result in Data Analyzer and Dry run in analytics. But it is throwing the error "Alert: Control execution is taking longer than expected. You will be notified when the result is ready."  while executing. Only 6 records are expected to return from this query not sure why it is getting timed out.

I have created the analytics to use it in the dashboard in ES tile format. But as analytics is not running due to which data is not being displayed in dashboard.

Query used for analytics: 

SELECT
e.endpointname,
t.endpoint,
COUNT(CASE WHEN t.tasktype = 2 THEN 1 END) AS 'Revoke',
COUNT(CASE WHEN t.tasktype = 14 THEN 1 END) AS 'Disable',
COUNT(CASE WHEN t.tasktype = 12 THEN 1 END) AS 'Update',
COUNT(CASE WHEN t.tasktype = 3 THEN 1 END) AS 'Create',
COUNT(CASE WHEN t.tasktype NOT IN (2, 3, 12, 14) THEN 1 END) AS 'Other '
FROM
arstasks t
INNER JOIN
endpoints e ON t.endpoint = e.endpointkey
WHERE
t.status = 1
AND t.endpoint IN (3, 7, 9, 10, 2, 2266)
GROUP BY
e.endpointname, t.endpoint;

[Raghu]

@Saksi  try below

SELECT
e.endpointname,
t.endpoint,
COUNT(CASE WHEN t.tasktype = 2 THEN 1 END) AS 'Revoke',
COUNT(CASE WHEN t.tasktype = 14 THEN 1 END) AS 'Disable',
COUNT(CASE WHEN t.tasktype = 12 THEN 1 END) AS 'Updatee',
COUNT(CASE WHEN t.tasktype = 3 THEN 1 END) AS 'Create',
COUNT(CASE WHEN t.tasktype NOT IN (2, 3, 12, 14) THEN 1 END) AS 'Other '
FROM
arstasks t
INNER JOIN
endpoints e ON t.endpoint = e.endpointkey
WHERE
t.status = 1
AND t.endpoint IN (3, 7, 9, 10, 2, 2266)
GROUP BY
e.endpointname, t.endpoint

[rushikeshvartak]

SELECT e.endpointname,
       t.endpoint,
       Count(CASE
               WHEN t.tasktype = 2 THEN 1
             END) AS 'Revoke Access',
       Count(CASE
               WHEN t.tasktype = 14 THEN 1
             END) AS 'Disable Access',
       Count(CASE
               WHEN t.tasktype = 12 THEN 1
             END) AS 'Update Access',
       Count(CASE
               WHEN t.tasktype = 3 THEN 1
             END) AS 'Create Access',
       Count(CASE
               WHEN t.tasktype NOT IN ( 2, 3, 12, 14 ) THEN 1
             END) AS 'Other Access'
FROM   arstasks t
       INNER JOIN endpoints e
               ON t.endpoint = e.endpointkey
WHERE  t.status = 1
       AND t.endpoint IN ( 3, 7, 9, 10,
                           2, 2266 )
GROUP  BY e.endpointname,
          t.endpoint;

[Manu269]

@Saksi what we were informed is that guardrail has been implemented due to which if the query takes longer time than you see this message.

Though you can attach an email template once anlytics execution completes.

[Saksi]

It worked thank you Raghu and Rushikesh, but i am curious to know what was the issue as the query is exactly same which i provided.

[rushikeshvartak · Accepted solution]

Update / create are internal words hence i have added access keyword

[Raghu · Accepted solution]

@Saksi  Some of keys words not allow .

Example : date,status ..etc  it wont allow so you need append new word  or change the word

[Saksi]

Thank you Rushikesh and Raghu. I have accepted the solution.