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

Insight on Rule Run Job

NPY
New Contributor III
New Contributor III

Hello,

We are running a monthly report to get the details for failed jobs for past one month. The report has a high number of items with jobname as 'RULE RUN JOB' and Sav Response as 'FAILURE' as below:

NPY_0-1715108444658.png

I checked with these JOB IDS on the execution trail but it won't give any results as shown below:

NPY_1-1715108635905.png

NPY_2-1715108793646.png

Can you please provide some insights on what these jobs are, how these jobs are triggered, and where to find the details of these failed job IDs (for example users and users' attribute changed, rule that is supposed to be triggered and so on).

Thank you

 

 

5 REPLIES 5

rushikeshvartak
All-Star
All-Star

This is known issue and fixed in latest version

 

It was code issue 

2024-02-20T12:13:38-05:00-ecm-domain.JobcontrolController-http-nio-8080-exec-65-lc9k4-DEBUG-checking RuleRunJob status
 
2024-02-20T12:13:38-05:00-ecm--null-lc9k4--20-Feb-2024 17:13:38.691 WARNING [http-nio-8080-exec-65] groovy.sql.Sql.asSql In Groovy SQL please do not use quotes around dynamic expressions (which start with $) as this means we cannot use a JDBC PreparedStatement and so is a security hole. Groovy has worked around your mistake but the security hole is still there. The expression so far is: SELECT count(*) as count FROM qrtz_fired_triggers where JOB_NAME='?'

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

NPY
New Contributor III
New Contributor III

Hi Rushikesh,

I see that it was supposed to be resolved in 24.2 but we are currently in 24.4 and getting the Failure Status in rule run job eventhough I cannot see those Job IDs in execution trail.

Please check logs


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

NPY
New Contributor III
New Contributor III

This is what I have in the logs when I search for the timeframe.

NPY_2-1715176116057.png

 

NPY_1-1715176094400.pngNPY_3-1715176168955.png

 

 

 

Please share full logs in txt format


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