7017 Bug - Tickets set as resolved
We have been having an issue with tickets set as resolved. Seems like this query also hangs our MSSQL server:
SELECT WorkOrder.WORKORDERID,WorkOrder.REQUESTERID,WorkOrder.CREATEDBYID,WorkOrder.CREATEDTIME,WorkOrder.RESPONDEDTIME,WorkOrder.DUEBYTIME,WorkOrder.COMPLETEDTIME,WorkOrder.TIMESPENTONREQ,WorkOrder.TITLE,WorkOrder.DESCRIPTION,WorkOrder.MODEID,WorkOrder.SLAID,WorkOrder.WORKSTATIONID,WorkOrder.DEPTID,WorkOrder.SITEID,WorkOrder.AUTOCLOSETIME,WorkOrder.CLOSEAUTHKEY,WorkOrder.TEMPLATEID,WorkOrder.ISPARENT,WorkOrderStates.WORKORDERID,WorkOrderStates.CATEGORYID,WorkOrderStates.SUBCATEGORYID,WorkOrderStates.ITEMID,WorkOrderStates.OWNERID,WorkOrderStates.ASSIGNEDTIME,WorkOrderStates.STATUSID,WorkOrderStates.PRIORITYID,WorkOrderStates.LEVELID,WorkOrderStates.ISOVERDUE,WorkOrderStates.ISESCALATED,WorkOrderStates.ISREAD,WorkOrderStates.SHOWNOTESTOTECH,WorkOrderStates.NOTIFICATIONSTATUS,WorkOrderStates.REQAPPROVAL,WorkOrderStates.APPR_STATUSID,WorkOrderStates.IMPACTID,WorkOrderStates.IMPACTDETAILS,WorkOrderStates.URGENCYID,WorkOrderStates.REQUESTTYPEID,WorkOrderStates.REOPENED,WorkOrderStates.CLOSEACCEPTED,WorkOrderStates.CLOSE_COMMENTS,WorkOrder_Fields.WORKORDERID,WorkOrder_Fields.UDF_LONG1,WorkOrder_Fields.UDF_LONG2,WorkOrder_Fields.UDF_CHAR1,WorkOrder_Fields.UDF_CHAR2,WorkOrder_Fields.UDF_CHAR3,WorkOrder_Fields.UDF_CHAR4,WorkOrder_Fields.UDF_CHAR5,WorkOrder_Fields.UDF_CHAR6,WorkOrder_Fields.UDF_DATE1,WorkOrder_Fields.UDF_DATE2,WorkOrder_Fields.UDF_LONG3,WorkOrder_Fields.UDF_LONG4,WorkOrder_Fields.UDF_CHAR7,WorkOrder_Fields.UDF_CHAR8,WorkOrder_Fields.UDF_CHAR9,WorkOrder_Fields.UDF_CHAR10,WorkOrder_Fields.UDF_CHAR11,WorkOrder_Fields.UDF_CHAR12,WorkOrder_Fields.UDF_DATE3,WorkOrder_Fields.UDF_DATE4,RequestResolution.REQUESTID,RequestResolution.RESOLUTION,RequestResolution.LASTUPDATEDTIME,RequestResolver.REQUESTID,RequestResolver.TECHNICIANID,WorkOrder_Threaded.THD_WOID,WorkOrder_Threaded.WORKORDERID,WorkOrder_Queue.WORKORDERID,WorkOrder_Queue.QUEUEID,WorkOrder_Queue.CREATEDTIME,WorkOrder_Queue.ISESCALATED,RequestCharges.REQUESTCHARGEID,RequestCharges.WORKORDERID,RequestCharges.OWNERID,RequestCharges.DESCRIPTION,RequestCharges.HH2COMPLETEREQUEST,RequestCharges.MM2COMPLETEREQUEST,RequestCharges.AMOUNT,RequestCharges.DATETIME,RequestCharges.EXECUTEDTIME,WorkOrderToDescription.WORKORDERID,WorkOrderToDescription.FULLDESCRIPTION FROM WorkOrder INNER JOIN WorkOrderStates ON WorkOrder.WORKORDERID=WorkOrderStates.WORKORDERID LEFT JOIN WorkOrder_Fields ON WorkOrder.WORKORDERID=WorkOrder_Fields.WORKORDERID LEFT JOIN RequestResolution ON WorkOrder.WORKORDERID=RequestResolution.REQUESTID LEFT JOIN RequestResolver ON WorkOrder.WORKORDERID=RequestResolver.REQUESTID LEFT JOIN WorkOrder_Threaded ON WorkOrder.WORKORDERID=WorkOrder_Threaded.WORKORDERID LEFT JOIN WorkOrder_Queue ON WorkOrder.WORKORDERID=WorkOrder_Queue.WORKORDERID LEFT JOIN RequestCharges ON WorkOrder.WORKORDERID=RequestCharges.WORKORDERID LEFT JOIN WorkOrderToDescription ON WorkOrder.WORKORDERID=WorkOrderToDescription.WORKORDERID WHERE (WorkOrder.WORKORDERID = 1880)
It happens on every ticket that is set as resolve. This issue just started with the newest "HOTFIX". I've opened a support ticket, but it always takes ServiceDesk support forever to get back to you. Anyone else seen or had an issue like this before?
SELECT WorkOrder.WORKORDERID,WorkOrder.REQUESTERID,WorkOrder.CREATEDBYID,WorkOrder.CREATEDTIME,WorkOrder.RESPONDEDTIME,WorkOrder.DUEBYTIME,WorkOrder.COMPLETEDTIME,WorkOrder.TIMESPENTONREQ,WorkOrder.TITLE,WorkOrder.DESCRIPTION,WorkOrder.MODEID,WorkOrder.SLAID,WorkOrder.WORKSTATIONID,WorkOrder.DEPTID,WorkOrder.SITEID,WorkOrder.AUTOCLOSETIME,WorkOrder.CLOSEAUTHKEY,WorkOrder.TEMPLATEID,WorkOrder.ISPARENT,WorkOrderStates.WORKORDERID,WorkOrderStates.CATEGORYID,WorkOrderStates.SUBCATEGORYID,WorkOrderStates.ITEMID,WorkOrderStates.OWNERID,WorkOrderStates.ASSIGNEDTIME,WorkOrderStates.STATUSID,WorkOrderStates.PRIORITYID,WorkOrderStates.LEVELID,WorkOrderStates.ISOVERDUE,WorkOrderStates.ISESCALATED,WorkOrderStates.ISREAD,WorkOrderStates.SHOWNOTESTOTECH,WorkOrderStates.NOTIFICATIONSTATUS,WorkOrderStates.REQAPPROVAL,WorkOrderStates.APPR_STATUSID,WorkOrderStates.IMPACTID,WorkOrderStates.IMPACTDETAILS,WorkOrderStates.URGENCYID,WorkOrderStates.REQUESTTYPEID,WorkOrderStates.REOPENED,WorkOrderStates.CLOSEACCEPTED,WorkOrderStates.CLOSE_COMMENTS,WorkOrder_Fields.WORKORDERID,WorkOrder_Fields.UDF_LONG1,WorkOrder_Fields.UDF_LONG2,WorkOrder_Fields.UDF_CHAR1,WorkOrder_Fields.UDF_CHAR2,WorkOrder_Fields.UDF_CHAR3,WorkOrder_Fields.UDF_CHAR4,WorkOrder_Fields.UDF_CHAR5,WorkOrder_Fields.UDF_CHAR6,WorkOrder_Fields.UDF_DATE1,WorkOrder_Fields.UDF_DATE2,WorkOrder_Fields.UDF_LONG3,WorkOrder_Fields.UDF_LONG4,WorkOrder_Fields.UDF_CHAR7,WorkOrder_Fields.UDF_CHAR8,WorkOrder_Fields.UDF_CHAR9,WorkOrder_Fields.UDF_CHAR10,WorkOrder_Fields.UDF_CHAR11,WorkOrder_Fields.UDF_CHAR12,WorkOrder_Fields.UDF_DATE3,WorkOrder_Fields.UDF_DATE4,RequestResolution.REQUESTID,RequestResolution.RESOLUTION,RequestResolution.LASTUPDATEDTIME,RequestResolver.REQUESTID,RequestResolver.TECHNICIANID,WorkOrder_Threaded.THD_WOID,WorkOrder_Threaded.WORKORDERID,WorkOrder_Queue.WORKORDERID,WorkOrder_Queue.QUEUEID,WorkOrder_Queue.CREATEDTIME,WorkOrder_Queue.ISESCALATED,RequestCharges.REQUESTCHARGEID,RequestCharges.WORKORDERID,RequestCharges.OWNERID,RequestCharges.DESCRIPTION,RequestCharges.HH2COMPLETEREQUEST,RequestCharges.MM2COMPLETEREQUEST,RequestCharges.AMOUNT,RequestCharges.DATETIME,RequestCharges.EXECUTEDTIME,WorkOrderToDescription.WORKORDERID,WorkOrderToDescription.FULLDESCRIPTION FROM WorkOrder INNER JOIN WorkOrderStates ON WorkOrder.WORKORDERID=WorkOrderStates.WORKORDERID LEFT JOIN WorkOrder_Fields ON WorkOrder.WORKORDERID=WorkOrder_Fields.WORKORDERID LEFT JOIN RequestResolution ON WorkOrder.WORKORDERID=RequestResolution.REQUESTID LEFT JOIN RequestResolver ON WorkOrder.WORKORDERID=RequestResolver.REQUESTID LEFT JOIN WorkOrder_Threaded ON WorkOrder.WORKORDERID=WorkOrder_Threaded.WORKORDERID LEFT JOIN WorkOrder_Queue ON WorkOrder.WORKORDERID=WorkOrder_Queue.WORKORDERID LEFT JOIN RequestCharges ON WorkOrder.WORKORDERID=RequestCharges.WORKORDERID LEFT JOIN WorkOrderToDescription ON WorkOrder.WORKORDERID=WorkOrderToDescription.WORKORDERID WHERE (WorkOrder.WORKORDERID = 1880)
It happens on every ticket that is set as resolve. This issue just started with the newest "HOTFIX". I've opened a support ticket, but it always takes ServiceDesk support forever to get back to you. Anyone else seen or had an issue like this before?