WCC 12.1 upgrade issue pointing to old EEM hostname

Products

• Autosys Workload Automation

Issue/Introduction

I'm trying to upgrade WCC from 12.0.01 to 12.1. 
I'm stuck on the installer at this section:

===============================================================================
CA EEM Properties
-----------------

Specify the EiamAdmin administrator information to upgrade the CA EEM policies
for Web UI.
CA EEM server(s):        eemserver.DOMAIN.COM
Administrator password:

 

the EEM server mentioned was decommissioned months ago and no longer exists, and this instance of WCC has never actually used this EEM server before. 
this EEM server was an old RHEL6 server we moved away from a long time ago. 
quite honestly, I don't even know how this instance of WCC even knows about this EEM server as it was never connected to it.

 

Now, we did repoint this WCC server to the DB being used by the above server, so i'm presuming something in the DB still has a record of the above EEM server. 
however, this instance of WCC isn't even using it.

 

how can we address so that the installer uses the correct EEM server? 
just not sure what the installer is querying to find this info.

 

Environment

Autosus  12.X
WCC

Cause

The WCC Oracle table CFG_GLOBAL_PREF had a reference to an old EEM server.
This was not seen when using WCC_CONFIG to display the EEM configuration.

The cawa_installer.log shows:
2023-03-21 10:23:43,043 [main] DEBUG com.ca.autosys.db.connection.DBOperations(63) - Running query: SELECT PREFVALUE FROM CFG_GLOBAL_PREF WHERE PREFKEY=?
2023-03-21 10:23:43,044 [main] DEBUG com.ca.autosys.db.connection.DBOperations(153) - Query params:
2023-03-21 10:23:43,045 [main] DEBUG com.ca.autosys.db.connection.DBOperations(157) - [1 : internal.eem.host]
2023-03-21 10:23:43,072 [main] DEBUG com.ca.wla.ae.installer.database.WCCDatabase(51) - Found preValue = eemserver.DOMAIN.COM

Resolution

Manually update the WCC Oracle table CFG_GLOBAL_PREF to the correct EEM HOSTname.
then rerun the installer.