Troubleshooting
Problem
Upgrade a 9.4 environment to 10.1 than switch the MDM and DDM from the 9.4 workstation to the new 10.1 workstation.
Symptom
After the DDM switch pool details are not visible for the pool defined under the DDM. The following message is returned:
AWSJOM177E An error occurred getting the definition of the workstation "<POOL_NAME>". The workload broker server is currently unreachable.
AWSJOM177E An error occurred getting the definition of the workstation "<POOL_NAME>". The workload broker server is currently unreachable.
Cause
DDM DWB.PPS_PRODUCT_PROPERTIES tables do not contain the expected values
Diagnosing The Problem
Definition of POOL under the DDM is not displayed. The following error is returned:
AWSJOM177E An error occurred getting the definition of the workstation "<POOL_NAME>". The workload broker server is currently unreachable.
AWSJOM177E An error occurred getting the definition of the workstation "<POOL_NAME>". The workload broker server is currently unreachable.
DDM DWB.PPS_PRODUCT_PROPERTIES tables do not contain the expected values
Resolving The Problem
To resolve the issue a few fields from the DDM DWB.PPS_PRODUCT_PROPERTIES table may need to be changed.
DomainManager.Workstation.DomainId this is the domain id under which the pool is defined this field is present under the MDM MDL.DOM_DOMAINS table
for example:
from the MDM DB run the following query: select hex(CAST(DOM_ID as VARCHAR(100))) as DOM_ID,DOM_NAME from MDL.DOM_DOMAINS order by DOM_NAME
this will return the list of domain id and domain name we need to verify that the domain id match the actual domain name
Note: the DomainManager.Workstation.DomainId report the domain id separated by dash in the following format xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx (8-4-4-4-12)
Verify the actual value is the expected one
for example:
from the MDM DB run the following query: select hex(CAST(DOM_ID as VARCHAR(100))) as DOM_ID,DOM_NAME from MDL.DOM_DOMAINS order by DOM_NAME
this will return the list of domain id and domain name we need to verify that the domain id match the actual domain name
Note: the DomainManager.Workstation.DomainId report the domain id separated by dash in the following format xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx (8-4-4-4-12)
Verify the actual value is the expected one
DomainManager.Workstation.Name this is the workstation name of the new DM
Verify the actual value is the expected one this value can be found from conman cli or from MDM MDL.WKS_WORKSTATIONS table
Verify the actual value is the expected one this value can be found from conman cli or from MDM MDL.WKS_WORKSTATIONS table
MasterDomainManager.HostName this is the full qualified host name or the IP of the new MDM
Verify the actual value is the expected one this value can be found from conman cli or from MDM MDL.WKS_WORKSTATIONS table
MasterDomainManager.Name this is the workstation name of the new MDM
Verify the actual values is the expected one this value can be found from conman cli or from MDM MDL.WKS_WORKSTATIONS table
MasterDomainManager.URIs this is the list of the MDM to be contacted by the DDM
The list must contains in the first position the new MDM and in second position the new BKM
Verify the actual value is the expected one this value can be found from conman cli or from MDM MDL.WKS_WORKSTATIONS table
MasterDomainManager.Name this is the workstation name of the new MDM
Verify the actual values is the expected one this value can be found from conman cli or from MDM MDL.WKS_WORKSTATIONS table
MasterDomainManager.URIs this is the list of the MDM to be contacted by the DDM
The list must contains in the first position the new MDM and in second position the new BKM
DomainManager.Workstation.Address this is the full qualified host name or the IP of the new DDM
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS8GJD","label":"IBM Workload Automation"},"ARM Category":[{"code":"a8m0z0000000CenAAE","label":"Technote"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
29 August 2023
UID
ibm17028716