Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Issue with Analytics

AS5278
Regular Contributor II
Regular Contributor II

Hi,

We have written an SQL Query to get some details related to a Campaign(Progress, Status..etc). When we run this query in data Analyzer it runs fine and we get 4 records.

But when we put this in Analytics Query we get the error:

"Alert: Control execution is taking longer than expected. You will be notified when the result is ready"

This never runs. Why is this even happening?

Below is the query:

SELECT DISTINCT
campaign_name as 'Campaign Name',
certification.CERT_NAME as 'Certification Name',
concat(users.firstname, ' ', users.lastname) as 'Certifier Name',
users.email AS 'Certifier Email',
certification.progress AS 'Certification Progress',
CASE
WHEN certification.status = 4 THEN 'Expired'
WHEN certification.status IN (3,8)THEN 'Locked'
WHEN certification.status IN (0 , 1) THEN 'Pending'
WHEN certification.status = 7 THEN 'Discontinued'
WHEN certification.status = 2 THEN 'Ready to Submit'
WHEN certification.status = 6 THEN 'Preview'
WHEN certification.status = 10 THEN 'Fully Executed'
END AS 'Certification Status'
FROM
certification,
campaign,
users
WHERE
certification.CAMPAIGNKEY = campaign.id
AND certification.certifier = users.userkey
AND campaign.id IN ('9659');

From looking at previous threads in the forum I got to know that Saviynt behaves this way if the column names end with some words which Saviynt uses for elastic search. For ex: - Date, date

But in my query, I have no such column name which is ending with the date keyword. Why is it throwing this alert then?.

Please advise.

Thanks,

Atul Singh

 

xurde
2 REPLIES 2

rushikeshvartak
All-Star
All-Star

Try below

SELECT DISTINCT campaign_name                                AS 'Campaign Name',
                certification.cert_name                      AS
                'Certification Name',
                Concat(users.firstname, ' ', users.lastname) AS 'Certifier Name'
                ,
                users.email                                  AS
                'Certifier Email',
                certification.progress                       AS
                'Certification Progress',
                CASE
                  WHEN certification.status = 4 THEN 'Expired'
                  WHEN certification.status IN ( 3, 8 )THEN 'Locked'
                  WHEN certification.status IN ( 0, 1 ) THEN 'Pending'
                  WHEN certification.status = 7 THEN 'Discontinued'
                  WHEN certification.status = 2 THEN 'Ready to Submit'
                  WHEN certification.status = 6 THEN 'Preview'
                  WHEN certification.status = 10 THEN 'Fully Executed'
                END                                          AS
                'Certification State'
FROM   certification,
       campaign,
       users
WHERE  certification.campaignkey = campaign.id
       AND certification.certifier = users.userkey
       AND campaign.id IN ( '9659' ); 

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

AS5278
Regular Contributor II
Regular Contributor II

@rushikeshvartak 

Changing 'Certification Status' to 'Certification State' fixed it. Seems like column names shouldn't end with status as well. Thanks.

xurde