Jammer is failing: Error while executing query: "from CurrentState cs left join fetch cs.mostRecentRun left join fetch cs.mostRecentRun.parent"

Products

• Automation Analytics & Intelligence

Issue/Introduction

The Jammer is failing with the error message in the jaws.log.

 

2024-09-26 17:10:01,012 ERROR [JammerManager] Interrupted
com.termalabs.server.cache.UncorrectedCurrentStateTableException: Unable to read CurrentState table after correcting data.
        at com.termalabs.server.cache.CurrentStateVendorImpl.repairCurrentStates(CurrentStateVendorImpl.java:411) ~[jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.cache.CurrentStateVendorImpl.initializeAllCurrentStates(CurrentStateVendorImpl.java:381) ~[jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.system.JammerManager.doFirstTimeProcessing(JammerManager.java:402) ~[jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.system.JammerManager.run2(JammerManager.java:309) [jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.system.JammerManager.run(JammerManager.java:239) [jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.system.ApplicationControllerService$2.run(ApplicationControllerService.java:269) [jaws-server-base-6.5.4.jar:?]
        at java.util.TimerThread.mainLoop(Timer.java:555) [?:1.8.0_421]
        at java.util.TimerThread.run(Timer.java:505) [?:1.8.0_421]
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(RichQueryCommon.java:1052) ~[jaws-common-connection-6.5.4.jar:?]
        at com.termalabs.common.connection.hibernate.RichQueryCommon.list(RichQueryCommon.java:974) ~[jaws-common-connection-6.5.4.jar:?]
        at com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSetUnfiltered(RichQuery.java:176) ~[jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSet(RichQuery.java:156) ~[jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.hibernate.jaws.HibernateCurrentStateData.getAllCurrentStates(HibernateCurrentStateData.java:81) ~[jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.cache.CurrentStateVendorImpl.getAllCurrentStates(CurrentStateVendorImpl.java:419) ~[jaws-server-base-6.5.4.jar:?]
        at com.termalabs.server.cache.CurrentStateVendorImpl.repairCurrentStates(CurrentStateVendorImpl.java:409) ~[jaws-server-base-6.5.4.jar:?]
        ... 7 more

 

Environment

Product: Automation Analytics & Intelligence v6.5.x

Cause

Product defect

Resolution

The issue has been fixed from AAI v24.0.0 HF1.

Additional Information

Release notes:
https://docs.automic.com/documentation/webhelp/english/AAI/24.0/TERMA_DOCU/24.0/AAI%20Guides/Content/Release_Notes/Release_Notes_24_0_0_1.htm