Insight on Rule Run Job

[NPY]

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:

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

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

[rushikeshvartak]

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='?'

https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v24x/Release-Notes-24-2.htm

[NPY]

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.

[rushikeshvartak]

Please check logs

[NPY]

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

[rushikeshvartak]

Please share full logs in txt format