Error Message :
UCUDB: Invalid value in Boolean field 'HOST_SmLinkFlag'.
When a Job with the following characteristics is executed, the error below occurs and the Job is stuck in a status of Generating (system return code 1572) in the Activities Window.
20170301/173215.557 - U00003594 UCUDB Ret: '3518' opcode: 'UPWC' SQL Stmnt: 'UPDATE HOST SET HOST_OH_Idnr = ?,HOST_HTYP_HW = NULL,HOST_HTYP_SW = NULL,HOST_HTYP_SWVers = NULL,HOST_CodeName = NULL,HOST_JCLVar = NULL,HOST_HostAttrType = NULL,HOST_TcpIpAddr = NULL,HOST_TcpIpPort = ?,HOST_Active = ?,HOST_JobCnt = ?,HOST_MaxWaiting = ?,HOST_Daylight = NULL,HOST_LicenceClass = NULL,HOST_Version = NULL,HOST_JobMd = NULL,HOST_PathBin = NULL,HOST_PathJobReport = NULL,HOST_PathTemp = NULL,HOST_ProcessName = NULL,HOST_VolumeTemp = NULL,HOST_ProcessMask = NULL,HOST_LoginMask = NULL,HOST_MibMonitoring = ?,HOST_MibInfo = NULL,HOST_LicCategory = NULL,HOST_MaxWaitingFT = ?,HOST_FTCount = ?,HOST_HostRoles = NULL,HOST_MaxResJob = ?,HOST_MaxResFT = ?,HOST_Authenticated = ?,HOST_CPName = NULL,HOST_CITName = NULL,HOST_TrustedIPs = NULL,HOST_CITCN = NULL,HOST_CITOU = NULL,HOST_SmPhrase = NULL,HOST_SmTcpIpPort = ?,HOST_SmDisplayName = NULL,HOST_SmLookupFlag = ?,HOST_SmLinkFlag = ?,HOST_HostName = NULL,HOST_NetArea = NULL,HOST_PathBackup = NULL,HOST_PathCache = NULL,HOST_TargetVersion = NULL,HOST_Up'20170301/173215.557 - U00003620 Routine 'UCGENX_R' forces trace because of error.20170301/173215.557 - U00003518 UCUDB: Invalid value in Boolean field 'HOST_SmLinkFlag'.20170301/173215.921 - U00011801 Error in Server routine 'UCGENX_R', Server: 'WO12#WP001' AE system: 'WO12'.20170301/173215.926 - U00003518 UCUDB: Invalid value in Boolean field 'HOST_SmLinkFlag'.
<Please see attached file for image>
Root Cause: A job object fails after activate_uc_object, if job object uses an agent-group. Error "U00003518 UCUDB: Invalid value in Boolean field 'HOST_SmLinkFlag'." is shown.
OS Version: N/A
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Component(s): AE Server and Initialdata
Automation Engine 12.1.0 - Available
Automation Engine 12.0.2 - Available
Automation Engine 12.0.1 HF2 - Available
There is no workaround found for this bug. However, ALL three characteristics mentioned above must exist for this issue to occur. So the Job may be modified so that not all 3 characteristics exist in order to mitigate the bug.
Affected tasks can be removed from the activity window using the function Modify status manually.