Stuck Rules Monitoring

[n1kh1l]

Hello All,

Is there any way to Set up an Analytics to monitor Stuck Rules in Execution Trail, or any other way to monitor the same?

Thanks.

[Darshanjain · Accepted solution]

Hi @n1kh1l 

you can create a analytics and create an email when you run the analytics to check 

Sql query: 

SELECT URR.USERRULERUNDATAKEY AS USERRULERUNDATAKEY , URR.USERKEY AS USERKEY , URR.JOBGROUP AS JOBGROUP ,
URR.CHANGEMAP AS CHANGEMAP , URR.RULETYPE AS RULETYPE , URR.DETECTIVE AS DETECTIVE ,
URR.BIRTHRIGHT AS BIRTHRIGHT , URR.PROCESSED AS PROCESSED , URR.COMMENTS AS COMMENTS ,
URR.JOBID AS JOBID , URR.PARENTJOBID AS PARENTJOBID , URR.UPDATEDATE AS UPDATEDATE ,
URR.EVENTSOURCE AS EVENTSOURCE ,
URR.NEWDATA AS NEWDATA, URR.OLDDATA AS OLDDATA ,
URR.RULEACTIONFAILED AS RULEACTIONFAILED, URR.RULEACTIONSUCCESSFUL AS RULEACTIONSUCCESSFUL ,
URR.RULEACTIONTOBEFIRED AS RULEACTIONTOBEFIRED , URR.TRAIL AS TRAIL , URR.USERHISTORYKEY AS USERHISTORYKEY ,U.USERNAME

FROM userrulerundata URR , USERS U WHERE
URR.USERKEY = U.USERKEY
ORDER BY URR.UPDATEDATE DESC;

Thanks

Darshan

[n1kh1l]

Hi Darshan,

Thanks, this is working, can you let me know if is there is a way to create actionable analytics with this query? 

[Darshanjain]

HI @n1kh1l 

No we dont have an option to retrigger those tasks, its only available va UI. If you need this feature you can raise it in Ideas portal as enhancement.

Thanks

Darshan