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.

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


Article ID: 195064


Updated On:


Automic Automation Intelligence


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(
 at com.mchange.v2.c3p0.DriverManagerDataSource.driver(
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(
 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(
 at com.mchange.v2.resourcepool.BasicResourcePool$
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$


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



Release : 6.0.1



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):
       All testing has been done with the Basic package, version v19., 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  


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: