Autosys Scheduler stopped updating in AAI - ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Article ID: 212778
Updated On:
Products
Issue/Introduction
Our AAI/JAWS application is showing as "Online and Delayed" in System Tools.
Additionally, the Dashboard area shows: "As Of: 04/14/21 6:34:53 AM PDT" but it is now almost 11 AM. We have already tried restarting the app but it seems to have had no effect.
INFO [AbstractDbSessionHandler] Testing connection with default syntax for scheduler "PRD (PRD)" (primary)
WARN [C3P0ConnectionProvider] No JDBC Driver class was specified by property hibernate.connection.driver_class
WARN [BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7280feb1 -- 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 (1). Last acquisition attempt exception: : java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
ERROR [JDBCExceptionReporter] Connections could not be acquired from the underlying database!
Environment
Release : 6.0.2
Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR BMC
Resolution
Errors indicate an error connecting to the Autosys database.
Please verify the Autosys database is up and running and that nothing is blocking the network connection.
If you recently upgraded to AAI 6.x and your Autosys schedulers are using Oracle, you will need to install the Oracle jdbc driver if you do not already have it installed.
https://docs.automic.com/documentation/webhelp/english/ALL/components/TERMA/latest/AAI%20Guides/Content/AAI_Topics/Release_Notes_6_0_0/Support-for-Non-Redistributable-Database-Drivers.htm
Additional Information
Note that in the upcoming 6.4.6 the Oracle driver will be included with the AAI installation.
Feedback
