Job stuck in status “Generating” in Activities Window

Document ID : KB000085088
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
  • 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:
    • ACTIVATE_UC_OBJECT
    • PREP_PROCESS_FILENAME
    • and others
Example for the error shown in WP log file and in the message 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'.

0EMb0000001Qokc.png

This has been observed specifically after updating to version 12.  The same object works fine in older versions.
 


 
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
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.
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
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
Additional Information:
Workaround :
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.