ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ERROR [JammerManager] Interrupted: com.termalabs.server.cache.UncorrectedCurrentStateTableException: Unable to read CurrentState table after correcting data.


Article ID: 239701


Updated On:


Automic Automation Intelligence


Error seen in jaws.log after restarting AAI.

2022-04-17 05:19:36,187 INFO  [JammerManager] Started to run JammerManager sequence
2022-04-17 05:19:36,188 INFO  [JammerManager] Jammer for APPLICATION_LANDSCAPE not implemented
2022-04-17 05:19:36,193 INFO  [CurrentStateVendorImpl] Initializing Current State cache.
2022-04-17 05:19:39,540 WARN  [CurrentStateVendorImpl] Invalid data found in CurrentState table.  Will attempt fixup.
2022-04-17 05:20:15,056 INFO  [JawsDbIntegrityUtil] Successfully committed RecentStateType table fixes
2022-04-17 05:20:18,378 ERROR [JammerManager] Interrupted: com.termalabs.server.cache.UncorrectedCurrentStateTableException: Unable to read CurrentState table after correcting data.
 at com.termalabs.server.cache.CurrentStateVendorImpl.repairCurrentStates(
 at com.termalabs.server.cache.CurrentStateVendorImpl.initializeAllCurrentStates(
 at com.termalabs.server.system.JammerManager.doFirstTimeProcessing(
 at com.termalabs.server.system.JammerManager.run2(
 at com.termalabs.server.system.ApplicationControllerService$
 at java.util.TimerThread.mainLoop(
Caused by: com.termalabs.common.datastore.DataAccessException: Error while executing query: "from CurrentState cs left join fetch cs.mostRecentRun left join fetch cs.mostRecentRun.parent"
 at com.termalabs.common.connection.hibernate.RichQueryCommon.executeAndTime(
 at com.termalabs.common.connection.hibernate.RichQueryCommon.list(
 at com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSetUnfiltered(
 at com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSet(
 at com.termalabs.server.hibernate.jaws.HibernateCurrentStateData.getAllCurrentStates(
 at com.termalabs.server.cache.CurrentStateVendorImpl.getAllCurrentStates(
 ... 7 in common
Caused by: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.termalabs.common.hibernate.jaws.JobRun#UUID[AXT9mdImB3o=]]


This can be caused by any abrupt interruption in the database connection while AAI is processing data.


Release : 6.4.2-1



1. Stop the AAI service.


2. Run the select query below:

--References to missing parent job runs

select s.schedulerName, count(*) from JobRun jr, JobScheduler s where jr.parentJobRunId not in (select jobRunId from JobRun) and jr.jobSchedulerId = s.jobSchedulerId group by s.schedulerName


3. If the query above returns any value other then 0, please run the update statement below:


-- Resolution

update JobRun

set parentJobRunId = null

where parentJobRunId not in (select jobRunId from JobRun);


4. With an Oracle database, please make sure to commit the changes by running:



5. Start up the AAI service. 

Additional Information

There are also some other queries that can be run to check for AAI database inconsistencies that may be  needed depending on the error, see  AAI Database Inconsistency Queries.