After upgrading AAI to 24.2 AAI fails to initialize and there is an error stating "Numeric overflow"
search cancel

After upgrading AAI to 24.2 AAI fails to initialize and there is an error stating "Numeric overflow"

book

Article ID: 403101

calendar_today

Updated On:

Products

Automation Analytics & Intelligence

Issue/Introduction

After upgrading to AAI 24.2 you may see the errors below in the jaws.log and the AAI service will fail to fully initialize.

If you are using an Oracle database you may see:

ERROR [JammerManager] Interrupted
com.termalabs.common.datastore.DataAccessException: Error while executing query: "from CurrentState cs left join fetch cs.mostRecentRun left join fetch cs.mostRecentRun.parent"
        at deployment.aai.war/com.termalabs.common.connection.hibernate.RichQueryCommon.executeAndTime(RichQueryCommon.java:1060) ~[jaws-common-connection-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.common.connection.hibernate.RichQueryCommon.list(RichQueryCommon.java:980) ~[jaws-common-connection-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSetUnfiltered(RichQuery.java:181) ~[jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSet(RichQuery.java:161) ~[jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.hibernate.jaws.HibernateCurrentStateData.getAllCurrentStates(HibernateCurrentStateData.java:84) ~[jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.cache.CurrentStateVendorImpl.getAllCurrentStates(CurrentStateVendorImpl.java:431) ~[jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.cache.CurrentStateVendorImpl.initializeAllCurrentStates(CurrentStateVendorImpl.java:379) ~[jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.cache.CurrentStateVendorImpl$Proxy$_$$_WeldClientProxy.initializeAllCurrentStates(Unknown Source) ~[jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.system.JammerManager.doFirstTimeProcessing(JammerManager.java:471) ~[jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.system.JammerManager.run2(JammerManager.java:377) [jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.system.JammerManager.run(JammerManager.java:307) [jaws-server-base-24.2.0.jar:?]
        at deployment.aai.war/com.termalabs.server.app.startup.JammerManagerControl$1.run(JammerManagerControl.java:140) [jaws-server-base-24.2.0.jar:?]
        at java.base/java.util.TimerThread.mainLoop(Timer.java:566) [?:?]
        at java.base/java.util.TimerThread.run(Timer.java:516) [?:?]
Caused by: org.hibernate.exception.GenericJDBCException: Could not extract column [18] from JDBC ResultSet [ORA-17026: Numeric overflow

 

If you are using a SQL Server database you may see:

ERROR [JammerManager] Interrupted
com.termalabs.common.datastore.DataAccessException: Error while executing query: "from CurrentState cs left join fetch cs.mostRecentRun left join fetch cs.mostRecentRun.parent"
    at deployment.aai.war/com.termalabs.common.connection.hibernate.RichQueryCommon.executeAndTime(RichQueryCommon.java:1060) ~[jaws-common-connection-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.common.connection.hibernate.RichQueryCommon.list(RichQueryCommon.java:980) ~[jaws-common-connection-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSetUnfiltered(RichQuery.java:181) ~[jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.hibernate.RichQuery$CollectionQuery.asSet(RichQuery.java:161) ~[jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.hibernate.jaws.HibernateCurrentStateData.getAllCurrentStates(HibernateCurrentStateData.java:84) ~[jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.cache.CurrentStateVendorImpl.getAllCurrentStates(CurrentStateVendorImpl.java:431) ~[jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.cache.CurrentStateVendorImpl.initializeAllCurrentStates(CurrentStateVendorImpl.java:379) ~[jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.cache.CurrentStateVendorImpl$Proxy$_$$_WeldClientProxy.initializeAllCurrentStates(Unknown Source) ~[jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.system.JammerManager.doFirstTimeProcessing(JammerManager.java:471) ~[jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.system.JammerManager.run2(JammerManager.java:377) [jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.system.JammerManager.run(JammerManager.java:307) [jaws-server-base-24.2.0.jar:?]
    at deployment.aai.war/com.termalabs.server.app.startup.JammerManagerControl$1.run(JammerManagerControl.java:140) [jaws-server-base-24.2.0.jar:?]
    at java.base/java.util.TimerThread.mainLoop(Timer.java:566) [?:?]
    at java.base/java.util.TimerThread.run(Timer.java:516) [?:?]
Caused by: org.hibernate.exception.DataException: Could not extract column [21] from JDBC ResultSet [Numeric overflow in conversion of value 2,784,582,000 to INTEGER.] [n/a]

Environment

AAI 24.2

Resolution

This is resolved in 24.2 HF1 which can be downloaded from the link below:

https://support.broadcom.com/web/ecx/solutiondetails?aparNo=99112495&os=MULTI-PLATFORM

Powered by Wolken Software