"java.sql.SQLRecoverableException: IO Error: SO Exception was generated" error during autosys installation

Products

• Autosys Workload Automation

Issue/Introduction

When attempting to Install autosys, we received the following error:

===============================================================================
Database Validation
-------------------

Error:
[CAUAJM_E_112508] An error occurred while connecting to the "AUTOSYS_A"
database server.
 java.sql.SQLRecoverableException: IO Error: SO Exception was generated
(CONNECTION_ID=W0hws0m+Swi1rNm+bagMgQ==)

PRESS <ENTER> TO ACCEPT THE FOLLOWING (OK):

 

Environment

Release : 12.1

Resolution

Service_Name value was incorrect for the entry AUTOSYS_A  

 

Alias name  AUTOSYS_A  is correct, but the Service_name was wrong

 

AUTOSYS_A =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = autosyshost.us-east-1.rds.amazonaws.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = AUTOSYS_A)
    )
  )

Make sure the value in the service_name parameter above is correct and retry.