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.
Example for the error shown in WP log file and in the message window:
- Job (JOBS) uses a Host Group (HOSTG)
- Job has “Generate at runtime” activated – is generated at runtime
- Job uses a script function which interrupts the script processing, for example:
- and others
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'.
This has been observed specifically after updating to version 12. The same object works fine in older versions.