Unable to launch AAI GUI post OS patching (RHEL) - JDBC and SQL exceptions in log files

Products

• Automic Automation Intelligence

Issue/Introduction

Getting below error when trying to launch AAI application GUI:


Uncaught JawsException occurred

Exception detail:

com.termalabs.common.JawsException: org.hibernate.exception.GenericJDBCException: Cannot open connection

                at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)

                at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)

                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

                at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

                at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

                at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

                at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)

                at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)

                at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)

                at com.termalabs.common.connection.hibernate.GenericSessionImpl.beginTransactionWithoutCommitCheck(GenericSessionImpl.java:202)

                at com.termalabs.common.connection.hibernate.GenericSessionImpl.<init>(GenericSessionImpl.java:174)

                at com.termalabs.server.hibernate.jaws.JawsSessionImpl.<init>(JawsSessionImpl.java:39)

                at com.termalabs.server.hibernate.JawsSessionFactoryImpl.makeSession(JawsSessionFactoryImpl.java:60)

                at com.termalabs.server.hibernate.jaws.HibernateDataAccess.createSession(HibernateDataAccess.java:47)

                at com.termalabs.server.hibernate.jaws.HibernateLicenseData.createSession(HibernateLicenseData.java:25)

                at com.termalabs.server.cache.LicenseDataVendorImpl$Cache.<init>(LicenseDataVendorImpl.java:214)

                at com.termalabs.server.cache.LicenseDataVendorImpl.getCache(LicenseDataVendorImpl.java:201)

                at com.termalabs.server.cache.LicenseDataVendorImpl.getLicenses(LicenseDataVendorImpl.java:238)

                at com.termalabs.server.cache.LicenseVendorImpl.getLicense(LicenseVendorImpl.java:89)

                at com.termalabs.server.cache.LicenseVendorImpl.getCurrentLicenseInfo(LicenseVendorImpl.java:278)

                at com.termalabs.server.cache.LicenseVendorImpl.getCurrentLicenseInfo(LicenseVendorImpl.java:266)

                at com.termalabs.server.ejb3.LicenseManagerEJB.getCurrentJawsLicense(LicenseManagerEJB.java:54)

                ... 12 skipped

                at com.termalabs.server.ejb3.RequestScopeEJB3Interceptor.invoke(RequestScopeEJB3Interceptor.java:94)

                ... 89 skipped

                at com.sun.proxy.$Proxy2.getCurrentJawsLicense(Unknown Source)

                at com.termalabs.client.main.JawsStartup$6.get(JawsStartup.java:1241)

                at com.termalabs.client.main.JawsStartup$6.get(JawsStartup.java:1237)

                at com.termalabs.client.model.ModelManagerUtil$1.processRequest(ModelManagerUtil.java:46)

                at com.termalabs.client.util.request.RequestWorker$1.construct(RequestWorker.java:107)

                at com.termalabs.client.util.SwingWorker$2.run(SwingWorker.java:130)

                at java.lang.Thread.run(Unknown Source)

 

Caller:

                at com.termalabs.client.model.ModelManagerUtil.performAsynchronousGet(ModelManagerUtil.java:58)

                at com.termalabs.client.main.JawsStartup.getLicense(JawsStartup.java:1248)

                at com.termalabs.client.main.JawsStartup.start(JawsStartup.java:331)

                at com.termalabs.client.main.JawsStartup.lambda$startAfterDelay$1(JawsStartup.java:285)

                at javax.swing.Timer.fireActionPerformed(Unknown Source)

                at javax.swing.Timer$DoPostEvent.run(Unknown Source)

                at java.awt.event.InvocationEvent.dispatch(Unknown Source)

                at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

                at java.awt.EventQueue.access$500(Unknown Source)

                at java.awt.EventQueue$3.run(Unknown Source)

                at java.awt.EventQueue$3.run(Unknown Source)

                at java.security.AccessController.doPrivileged(Native Method)

                at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

                at java.awt.EventQueue.dispatchEvent(Unknown Source)

                at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

                at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

                at java.awt.EventDispatchThread.run(Unknown Source)




    

Environment

Release : 6.0.1

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Cause

In hibernate.log had the following error:

2020-08-09 02:23:40,385 WARN  [BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7a01e6da -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: : java.sql.SQLException: ORA-28001: the password has expired

Resolution

The root cause of you problem is the password to the AAI DB expired:

java.sql.SQLException: ORA-28001: the password has expired

==================================

Please run the /config/run.sh &

and update the Database Tab with the correct login credentials. You can test it from this window as well.