java.sql.SQLRecoverableException: IO Error: Invalid number format for port number in waae_webservices.log

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Seeing the below error message being repeated over and over again in the waae_webservices.log and waae_webservices_wrapper.log file:

java.sql.SQLRecoverableException IO Error: Invalid number format for port number

Environment

Release : 12

Component : Web Server (formerly known as Web Services)

Resolution

Most of the time this error is caused by the set.TNS_ADMIN line not being set so it does not know where to get the tnsnames.ora file to get the database information. After setting the TNS_ADMIN and bouncing the waae_webserver.<instance> process, resolves this error.

Unix machines

Go to the $AUTOUSER/webserver/conf directory

vi the wrapper.conf file and verify the set.ORACLE_HOME and set.TNS_ADMIN are set

example:

set.ORACLE_HOME = /app/oracle/product/19c/client_1

set.TNS_ADMIN = /app/oracle/product/19c/client_1/network/admin

 

Windows machines

Go to the %AUTOUSER%/webserver/conf directory

edit the wrapper.conf file and verify the set.ORACLE_HOME and set.TNS_ADMIN are set

example:

set.ORACLE_HOME = /app/oracle/product/19c/client_1

set.TNS_ADMIN = /app/oracle/product/19c/client_1/network/admin