Cannot view details of an AS400

Document ID : KB000100730
Last Modified Date : 12/06/2018
Show Technical Document Details
Issue:
Attempting to view the details of an AS400 agent gets the following error:

Task details could not be retrieved. Runtime error in object 'XPROPERTIES_HOST(GET)', line '00123'. Converting string to numerical value is not possible. String ''. 
Cause:
This is a bug with the Automic Web Interface. 
Resolution:
Workaround:

Set up a SQLI VARA and put the following query (this is for a SQL database):

select OH_Name, HOST_HTYP_HW, HOST_HTYP_SW, HOST_HTYP_SWVers, HOST_CodeName, HOST_JCLVar, HOST_TcpIpAddr, HOST_Active, HOST_JobCnt, HOST_MaxWaiting, HOST_Daylight, HOST_LicenceClass, HOST_Version, HOST_PathJobReport, HOST_PathTemp, HOST_PathBin, HOST_MibMonitoring, HOST_LicCategory from OH O Inner join Host H on O.OH_Idnr = H.HOST_OH_Idnr where O.OH_Name = 'AGENTNAME01'

Replace AGENTNAME01 with the name of the Agent (such as Win01). This will get all of the information that would have been in the details page.

This issue will be fixed in the following versions:

Automation Web Interface 12.2.0 – Planned release June 29, 2018 
Automation Web Interface 12.1.3 – Planned release September 24, 2018 
Automation Web Interface 12.0.6 – Planned release September 10, 2018