search cancel

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

book

Article ID: 190577

calendar_today

Updated On:

Products

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

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: WCCPROD1
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 WCCPROD1A --dbtnspath "/app/ora/product/12.2.0.1/db_1/network/admin" --dbapp REPORTING