AAI 6.0.x - Database found but Automic Automation Intelligence tables do not exist.

book

Article ID: 195064

calendar_today

Updated On:

Products

Automic Automation Intelligence

Issue/Introduction

After installing AAI 6.0.x or later the services fail to connect to the database.

The config tool database test has the error:


Database found but Automic Automation Intelligence tables do not exist.

 

hibernate.log shows:


2020-07-14 12:20:13,836 WARN  [BasicResourcePool] [email protected]f5 -- 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: No suitable driver
 at java.sql.DriverManager.getDriver(DriverManager.java:315)
 at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:224)
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

 

Jaws.log shows:

2020-07-14 12:16:50,758 WARN  [ParameterVendorImpl] No value for parameter: autosys.jobStreamExpirationJob; using default value: Duration[12:00:00]: org.hibernate.exception.GenericJDBCException: Cannot open connection

 

Server.log shows:

2020-07-14 10:59:10,719 ERROR [org.jboss.stdio.AbstractLoggingWriter] Exception in thread "Thread-88" org.hibernate.exception.GenericJDBCException: Cannot open connection

 

Environment

Release : 6.0.1

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

Starting with AAI 6.0.0 the Oracle JDBC drivers are no longer included with the installation.

You must 

To connect Automic Automation Intelligence to any Oracle database (scheduler database or Automic Automation Intelligence database), the following procedure is required.

1. Ensure that the Java version you have installed is Java 1.8.x. No other versions of java are supported at this time.

2. To determine the version of Java you have installed, enter the following command from a command line:
       java -version

3. Install Oracle Instant Client (which can be downloaded from the Oracle website):
       https://www.oracle.com/database/technologies/instant-client.html
       All testing has been done with the Basic package, version v19.3.0.0.0, however the Light package should also work.  Additional tools packages are not required (SQL*Plus, Tools, SDK, etc)

4. Locate the ojdbc8.jar file from the installation.
       Ubuntu: /usr/lib/oracle/19.3/client64/lib/ojdbc8.jar

       Windows: Unzip the installation package to a directory of your choice.  The file is in the root of the unzipped package  


      RHEL:
            /usr/lib/oracle/19.3/client64/lib/ojdbc8.jar


5. Copy ojdbc8.jar from the installation directory (above) to the {Automic_Automation_Intelligence}/jboss/standalone/deployments
 directory on the Automic Automation Intelligence platform server.  You should now be able to run the Config Tool and the Automic Automation Intelligence server. No changes are required for Automic Automation Intelligence
 INSIGHT. The Oracle driver has been packaged and licensed for distribution by Tibco Software and made available as part of the embedded BI server.

 

This is documented in the Release Notes link below:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/automic-automation-intelligence/6-0-0/Release_Notes_0/Support-for-Non-Redistributable-Database-Drivers.html#concept.dita_bc1d8e83-3d09-4a44-9298-33d3aaa0d553

 

 

Attachments