AAI 6.0.x - Database found but Automic Automation Intelligence tables do not exist.
Article ID: 195064
Updated On:
Products
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] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@75bfeef5 -- 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:
Additional Information
Note that in the upcoming 6.5 this driver will be included with the AAI installation.
Feedback
