Unable to login to WCC new PRODUCTION WCC server caused by invalid number format for port number

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• Autosys Workload Automation

Issue/Introduction

A new production server was installed today and after startup, unable to get login page.

Following error messages are found back in CA-wcc.log

INFO   | jvm 1    | 2020/05/10 05:59:41 |     3688 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:41 |     3688 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:41 |     3688 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:41 |     3688 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:41 |     3688 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:44 |     3691 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:44 |     3691 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:44 |     3691 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:44 |     3691 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:44 |     3691 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:44 |     3691 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:49 |     3696 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:49 |     3696 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:49 |     3696 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:49 |     3696 | Caused by: oracle.net.ns.NetException: Invalid number format for port number

INFO   | jvm 1    | 2020/05/10 05:59:49 |     3696 | java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

Environment

Release : 11.4

Component : CA Workload Automation AE (AutoSys)

Cause

For an unknown reason, the database port for the REPORTING database was not configured during installation.

Resolution

Run following commands to see for which database the port number is missing

cd $CA_WCC_INSTALL_LOCATION/bin

./wcc_config.sh -u <userid> -p <password> --displaydb --dbapp WCC

./wcc_config.sh -u <userid> -p <password> --displaydb --dbapp REPORTING

Probably it will be for REPORTING database that the fields are missing.
You can use the same command to give the missing information:

./wcc_config.sh -u <userid> -p <password> --dbplatform <db_platform> --dbuser <db_user> --dbpassword <db_password> --dbhost <db_host> --dbport <db_port> --dbname <db_name> [--dbapp <WCC|REPORTING>] [--dbtnsname <tns_name>] [- - dbtnspath <tns_path>]

 

Additional Information

Example:

./wcc_config.sh -u xxxxxxx --displaydb --dbapp WCC
Password:
Logging in as 'xxxxxxxx' - SUCCESS

Database server connection
TNS name of the database connection: WCCPROD
Path to the tnsnames.ora file: /app/ora/product/12.2.0.1/db_1/network/admin
Platform: oracle
User: wccdbadmin
Password: *****

./wcc_config.sh -u xxxxxx --displaydb --dbapp REPORTING
Password:
Logging in as 'xxxxxx' - SUCCESS

Database server connection
Host Name:
Port:
Database instance name:
Platform: oracle
User: wccdbadmin
Password: *****

Use following command to give the required  REPORTING information

./wcc_config.sh -u xxxxxxx --dbplatform oracle --dbuser wccdbadmin --dbpassword <password> --dbtnsname WCCPROD --dbtnspath "/app/ora/product/12.2.0.1/db_1/network/admin" --dbapp REPORTING