12-03-2023 08:11:00 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\40076_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\40076_Clickedfile.png'.
12-03-2023 08:11:08 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\40076_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\40076_Clickedfile.png'.
12-03-2023 08:12:48 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30575\42051_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30575\42051_Clickedfile.png'.
12-03-2023 08:20:33 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30572\14250_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30572\14250_Clickedfile.png'.
12-03-2023 08:21:37 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30512\52215_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30512\52215_Clickedfile.png'.
12-03-2023 08:41:44 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'.
12-03-2023 08:41:53 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'.
12-03-2023 08:42:11 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'.
12-03-2023 08:42:19 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'.
12-03-2023 08:42:28 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30556\90212_Clickedfile.png'.
12-03-2023 09:33:34 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28970\10757_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28970\10757_Clickedfile.png'.
12-03-2023 09:33:50 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28970\10757_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28970\10757_Clickedfile.png'.
12-03-2023 09:34:12 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28970\10757_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28970\10757_Clickedfile.png'.
12-03-2023 09:35:06 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28969\64147_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28969\64147_Clickedfile.png'.
12-03-2023 09:35:14 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28969\64147_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28969\64147_Clickedfile.png'.
12-03-2023 09:44:42 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'.
12-03-2023 09:44:47 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'.
12-03-2023 09:44:48 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'.
12-03-2023 09:44:58 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\35338_Clickedfile.png'.
12-03-2023 09:45:12 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\76933_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28935\76933_Clickedfile.png'.
12-03-2023 12:32:49 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30535\14756_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30535\14756_Clickedfile.png'.
12-03-2023 01:24:13 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30573\39071_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30573\39071_Clickedfile.png'.
12-03-2023 01:42:12 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\84886_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\84886_Clickedfile.png'.
12-03-2023 01:49:31 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30532\36705_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30532\36705_Clickedfile.png'.
12-03-2023 02:47:29 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28965\81249_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28965\81249_Clickedfile.png'.
12-03-2023 02:47:37 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28965\81249_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28965\81249_Clickedfile.png'.
12-03-2023 02:54:21 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28969\64147_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\28969\64147_Clickedfile.png'.
12-03-2023 02:56:13 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\29624\58596_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\29624\58596_Clickedfile.png'.
12-03-2023 02:56:41 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\29624\58596_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\29624\58596_Clickedfile.png'.
12-03-2023 03:18:58 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\29885\33642_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\29885\33642_Clickedfile.png'.
12-03-2023 04:24:17 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30656\48030_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30656\48030_Clickedfile.png'.
12-03-2023 05:58:37 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\84886_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\84886_Clickedfile.png'.
12-03-2023 06:00:27 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\23786_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\23786_Clickedfile.png'.
12-03-2023 06:05:32 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\76095_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\76095_Clickedfile.png'.
12-03-2023 06:05:44 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\76095_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30576\76095_Clickedfile.png'.
12-03-2023 06:15:45 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'.
12-03-2023 06:15:56 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'.
12-03-2023 06:16:19 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'.
12-03-2023 06:20:10 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ##  ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0)  when 1 then 'Created'  when 2 then 'Scheduled'  when 3 then 'Assigned'  when 4 then 'Confirmed'  when 5 then 'Pending'  when 6 then 'InProgress'  when 7 then 'Completed'  when 8 then 'Closed'  when 9 then 'Cancelled'  when 10 then 'None'  when 11 then 'Rejected'  when 12 then 'Arrived'  when 13 then 'Approved'  when 14 then 'InTransit'  end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users,  mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description,  (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory,  et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active  from et_work_order wo  left outer join mst_departments on mst_departments.id = wo.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK  left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_users on mst_users.id = wo.created_by_user_pk  left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk  left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id)  Where 1=1  and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 187)  or wo.Department_PK = (select department_id from mst_users where id = 187)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 187)  or ifnull(mst_departments.strict_wo_list,0) = 0  or ifnull(mst_sub_departments.strict_wo_list,0) = 0  )  And ifnull(wo.wo_status_pk,0) = 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 187)   order by wo.ID desc 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
12-03-2023 06:22:36 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30557\34026_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30557\34026_Clickedfile.png'.
12-03-2023 06:25:30 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30551\38207_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30551\38207_Clickedfile.png'.
12-03-2023 06:25:38 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30551\38207_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30551\38207_Clickedfile.png'.
12-03-2023 06:32:27 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30370\93678_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30370\93678_Clickedfile.png'.
12-03-2023 07:55:28 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'.
12-03-2023 07:55:30 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'.
12-03-2023 07:55:45 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\98440_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\98440_Clickedfile.png'.
12-03-2023 07:56:12 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\Clickedfile.png'.
12-03-2023 07:56:35 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\55365_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\55365_Clickedfile.png'.
12-03-2023 07:57:01 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\52365_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\52365_Clickedfile.png'.
12-03-2023 07:57:08 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\52365_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\\52365_Clickedfile.png'.
12-03-2023 08:04:46 ## Exception ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30578\89666_Clickedfile.png'. ## CMRIDataService.Download_Attachment ##  ## Could not find a part of the path 'E:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\30578\89666_Clickedfile.png'.