File: C:\AssetWorks\FASuite\main-ms\Logs\202606\20260617\WebModules\MSMAIN\sqlerr.log

• ==========[ 06/17/2026 10:54:55 ]==========

• SQL LEAK DETECTION (Idle) Registered: True - Time idle: 25 seconds - loc_work_order_loc=KHLOC

• work_order_yr=2021

• work_order_no=34

• SELECT ST.LOC_WORK_ORDER_LOC, ST.WORK_ORDER_YR, ST.WORK_ORDER_NO, ST.TASK_TASK_CODE, TSK_MAIN.completion_status, TSK_MAIN.qty_labor_hrs_chargd, TSK_MAIN.WARRANTY,TSK_MAIN.WAC_WAC_CODE, TSK_MAIN.ROW_ID, TSK_MAIN.TASK_TYPE, TSK_MAIN.QTY_LABOR_HRS_EST, TSK_MAIN.PRI_PRIORITY_CODE, TSK_MAIN.datetime_completed, TSK_MAIN.task_proc_version, TSK_MAIN.class_task_proc_version,(SELECT DESCRIPTION FROM WAC_MAIN WHERE WAC_WAC_CODE=TSK_MAIN.WAC_WAC_CODE) AS WAC_DESC,(SELECT FINAL_STATUS FROM WAC_MAIN WHERE WAC_WAC_CODE=TSK_MAIN.WAC_WAC_CODE) AS WAC_FINAL_STATUS,(SELECT DESCRIPTION FROM DES_MAIN WHERE TASK_TASK_CODE=ST.TASK_TASK_CODE) AS DESCRIPTION FROM TSK_MAIN RIGHT OUTER JOIN (SELECT SRV_TASKS.TASK_TASK_CODE, SRV_MAIN.LOC_WORK_ORDER_LOC, SRV_MAIN.WORK_ORDER_YR, SRV_MAIN.WORK_ORDER_NO FROM SRV_TASKS INNER JOIN SRV_MAIN ON SRV_TASKS.SRV_ID=SRV_MAIN.UNIQUE_ID WHERE LOC_WORK_ORDER_LOC=@loc_work_order_loc AND WORK_ORDER_YR=@work_order_yr AND WORK_ORDER_NO=@work_order_no UNION SELECT SRV_MAIN.TASK_TASK_CODE, SRV_MAIN.LOC_WORK_ORDER_LOC, SRV_MAIN.WORK_ORDER_YR, SRV_MAIN.WORK_ORDER_NO FROM SRV_MAIN WHERE LOC_WORK_ORDER_LOC=@loc_work_order_loc AND WORK_ORDER_YR=@work_order_yr AND WORK_ORDER_NO=@work_order_no AND SRV_MAIN.TASK_TASK_CODE IS NOT NULL) ST ON TSK_MAIN.LOC_WORK_ORDER_LOC=ST.LOC_WORK_ORDER_LOC AND TSK_MAIN.WORK_ORDER_YR=ST.WORK_ORDER_YR AND TSK_MAIN.WORK_ORDER_NO=ST.WORK_ORDER_NO AND TSK_MAIN.TASK_TASK_CODE=ST.TASK_TASK_CODE WHERE (TASK_TYPE IS NULL OR TASK_TYPE='R' OR TASK_TYPE='P')

• ==========[ 06/17/2026 10:59:55 ]==========

• SQL LEAK DETECTION (Idle) Registered: True - Time idle: 22 seconds - status=PENDING

• loc_work_order_loc=KHLOC

• work_order_yr=2025

• work_order_no=20

• SELECT x_datetime_insert,x_userid_insert,row_id,loc_issue_loc,emp_requested,loc_work_order_loc,work_order_yr,task_task_code,position_install,part_part_no,part_suffix,description,qty,wac_wac_code,comment_requested,(SELECT SERIALIZED

•                                     FROM   PCL_MAIN

•                                     WHERE  PCL_PART_CLASSIF = (SELECT PCL_PART_CLASSIF

•                                                                FROM   PTS_MAIN

•                                                                WHERE  PART_PART_NO = PTD_RETURN_REQUESTS.PART_PART_NO

•                                                                AND    PART_SUFFIX  = PTD_RETURN_REQUESTS.PART_SUFFIX)) AS SERIALIZED,(SELECT SERIAL_NO

•                                     FROM   PTD_MAIN

•                                     WHERE  PTD_MAIN.unique_id = PTD_RETURN_REQUESTS.issue_unique_id) AS INSTALLED_SERIAL,(SELECT REMOVED_SERIAL_NO

•                                     FROM   PTD_MAIN

•                                     WHERE  PTD_MAIN.unique_id = PTD_RETURN_REQUESTS.issue_unique_id) AS REMOVED_SERIAL FROM EMSDBA.PTD_RETURN_REQUESTS WHERE loc_work_order_loc = @loc_work_order_loc AND work_order_yr = @work_order_yr AND work_order_no = @work_order_no AND (status=@status)  ORDER BY task_task_code ASC,part_part_no ASC,part_suffix ASC,x_datetime_insert ASC

• ==========[ 06/17/2026 11:04:55 ]==========

• SQL LEAK DETECTION (Idle) Registered: True - Time idle: 51 seconds - loc_work_order_loc=KHLOC

• work_order_yr=2025

• work_order_no=2

• SELECT NO_PARTIAL_ISSUE,request_id,ROW_ID FROM EMSDBA.PTS_REQUEST_MAIN WHERE loc_work_order_loc = @loc_work_order_loc AND work_order_yr = @work_order_yr AND work_order_no = @work_order_no AND (EXISTS(SELECT REQUEST_ID FROM PTS_REQUEST WHERE Notify_Flag='Y' AND REQUEST_ID=PTS_REQUEST_MAIN.REQUEST_ID AND LOC_WORK_ORDER_LOC='KHLOC' AND WORK_ORDER_YR='2025' AND WORK_ORDER_NO='2'))