removeProcessRun JMX operation could not remove the job

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

A long-running Release Automation process could not be terminated in ROC UI.

The UI displayed "Failed to get job status for job: <jobid>".

It is possible to remove the process using removeProcessRun JMX operation 

How to remove hung processes via JMX

But this operation failed to remove the process

Environment

Release Automation - All Versions

Resolution

To find the cause why JMX removeProcessRun operation could not remove the process some logs in SQL trace are needed :

 

1. Open JMX page
   
   http://nac_server_name:20203/mbean?objectname=Logging%3Atype%3DLog4j
   
   Replace nac_server_name by the name of NAC server
   
   Default login / password is nolio/nolio
   
   
   
2. Click Invoke button for "turnOnHibernateSQLLogging" and "turnOnHibernateBindParameterLogging"
   
   
   
   
   
3. Try again to remove the job using JMX removeProcessRun
   
   

4. Collect the logs <RA_HOME>/logs/nolio_dm_all*.log of NAC and open a case at Broadcom Support with these logs.
   
   

5. invoke this to disable SQL Logging :

   "turnOffHibernateSQLLogging" and "turnOffHibernateBindParameterLogging"

   as these logging settings generate a lot of extra logs and could affect the Nolio performance.

Additional Information

In the log we should see something like :

 

2026-06-30T14:13:30.672Z [Thread-80] DEBUG (com.nolio.platform.server.dataservices.services.execution.JobTerminatorServiceImpl:533) - stopping job[id=<jobid>]
2026-06-30T14:13:30.672Z [Thread-80] DEBUG (com.nolio.platform.server.dataservices.services.execution.JobTerminatorServiceImpl:142) - stopping job [<jobid>].
...
2026-06-30T14:13:30.810Z [ExecutionServiceWorker-5] INFO  (com.nolio.platform.server.dataservices.services.execution.JobTerminatorServiceImpl:301) - Canceling job [<jobid>].
...
2026-06-30T14:13:32.628Z [Thread-80] DEBUG (com.nolio.platform.server.dataservices.services.execution.cache.JobsCacheImpl:106) - job [id=<jobid>] removed from from cache.
2026-06-30T14:13:32.629Z [Thread-80] DEBUG (com.nolio.platform.server.dataservices.services.execution.control.JobLocksCacheImpl:101) - job[id=<jobid>] lock removed from cache.
...
2026-06-30T14:13:32.630Z [Thread-80] DEBUG (com.nolio.platform.server.dataservices.services.execution.eventbus.ExecutionEventBusImpl:137) - event bus for job <jobid> was removed.
2026-06-30T14:13:32.631Z [Thread-80] DEBUG (org.hibernate.engine.jdbc.spi.SqlStatementLogger:144) - /* delete com.nolio.platform.server.dataservices.services.execution.model.onlineentities.ExecutionJob */ delete from execution_jobs where ID=?
2026-06-30T14:13:32.632Z [Thread-80] TRACE (org.hibernate.type.descriptor.sql.BasicBinder:64) - binding parameter [1] as [BIGINT] - [<jobid>]