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.

Autosys Scheduler stopped updating in AAI - ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

book

Article ID: 212778

calendar_today

Updated On:

Products

Automic Automation Intelligence

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] [email protected]b1 -- 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