17-07-2023 11:08:48 ## Exception ## The process cannot access the file 'D:\KWTCMRI2\CMRIApp\Attachments\EtWorkOrder\41809\34910_Clickedfile.png' because it is being used by another process. ## FCMRIDataService.SaveUpdate_DocumentAttachment ##  ## The process cannot access the file 'D:\KWTCMRI2\CMRIApp\Attachments\EtWorkOrder\41809\34910_Clickedfile.png' because it is being used by another process.
17-07-2023 03:48:12 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:49:04 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:48:04', 41741, 101, '', '56554_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', '', 47.6625898, 29.5474438, '2023-07-17 15:47:11') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:49:33 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 226)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:49:38 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:50:00 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:50:22 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:49:22', 41741, 101, '', '56554_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', '', 47.6625898, 29.5474438, '2023-07-17 15:47:11') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:50:22 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:50:32 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 225)  or wo.Department_PK = (select department_id from mst_users where id = 225)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 225)  or ifnull(mst_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 = 225)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:51:01 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:51:07 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 213)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:51:34 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 226)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:51:53 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:51:57 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:50:57', 41741, 101, '', '56554_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', '', 47.6625898, 29.5474438, '2023-07-17 15:47:11') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:52:00 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:52:00 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:52:37 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:51:37', 41903, 101, '', '57780_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41903\57780_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41903\57780_Clickedfile.png', '', 48.2466618, 28.567462, '2023-07-17 15:51:29') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:52:57 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 213)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:52:59 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:53:01 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:53:08 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 213)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:53:24 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:52:24', 41741, 101, '', '56554_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', '', 47.6625898, 29.5474438, '2023-07-17 15:47:11') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:53:33 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 213)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:53:41 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:53:47 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:54:00 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:54:37 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:54:56 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:54:58 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 213)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:55:00 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:55:08 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:55:18 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:54:18', 41741, 101, '', '56554_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', '', 47.6625898, 29.5474438, '2023-07-17 15:47:11') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:55:33 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 213)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:55:40 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:54:40', 41903, 101, '', '57780_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41903\57780_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41903\57780_Clickedfile.png', '', 48.2466618, 28.567462, '2023-07-17 15:51:29') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:55:43 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 225)  or wo.Department_PK = (select department_id from mst_users where id = 225)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 225)  or ifnull(mst_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 = 225)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:55:47 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:56:19 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:56:37 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:56:46 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:55:46', 41741, 101, '', '56554_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41741\56554_Clickedfile.png', '', 47.6625898, 29.5474438, '2023-07-17 15:47:11') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:56:56 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 15:55:56', 41903, 101, '', '57780_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\41903\57780_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\41903\57780_Clickedfile.png', '', 48.2466618, 28.567462, '2023-07-17 15:51:29') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 03:56:57 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:56:58 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 240)  or wo.Department_PK = (select department_id from mst_users where id = 240)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 240)  or ifnull(mst_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 = 240)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:58:21 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:58:41 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 225)  or wo.Department_PK = (select department_id from mst_users where id = 225)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 225)  or ifnull(mst_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 = 225)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:58:44 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:58:55 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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  )  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: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 03:59:23 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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  )  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: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:00:21 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:00:33 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 233)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:00:45 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:01:49 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 233)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:02:06 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:02:22 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:02:33 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 233)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:02:57 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:03:49 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 233)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:04:03 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:04:06 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:04:22 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:04:23 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 239)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:04:57 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 16:03:56', 42183, 101, '', '21257_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\42183\21257_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\42183\21257_Clickedfile.png', '', 47.1436749, 29.4537527, '2023-07-17 16:03:47') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 04:04:58 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:05:46 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:06:03 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:06:07 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 233)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:06:19 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 16:05:19', 42183, 101, '', '21257_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\42183\21257_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\42183\21257_Clickedfile.png', '', 47.1436749, 29.4537527, '2023-07-17 16:03:47') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 04:06:23 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 239)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:07:47 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 231)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:08:07 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 233)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:08:17 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And  document_id = 41903  order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:08:33 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 203)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:09:48 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:10:19 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 16:09:19', 42189, 101, '', '73583_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\42189\73583_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\42189\73583_Clickedfile.png', '', 48.0956608, 29.7395474, '2023-07-17 16:09:15') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 04:10:33 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 203)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:11:49 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 199)   order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:12:22 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 16:11:22', 42189, 101, '', '73583_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\42189\73583_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\42189\73583_Clickedfile.png', '', 48.0956608, 29.7395474, '2023-07-17 16:09:15') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 04:16:00 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And  document_id = 41741  order by id desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:16:20 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 225)  or wo.Department_PK = (select department_id from mst_users where id = 225)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 225)  or ifnull(mst_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 = 225)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:16:39 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 195)  or wo.Department_PK = (select department_id from mst_users where id = 195)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 195)  or ifnull(mst_departments.strict_wo_list,0) = 0  )  and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 195)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:16:51 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 195)  or wo.Department_PK = (select department_id from mst_users where id = 195)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 195)  or ifnull(mst_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 = 195)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:17:27 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentAttachment
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 INSERT INTO et_document_attachment (updated_at, document_id, document_type, description, file_name, url, dir_path, type,longitude,latitude, click_time)  VALUES('2023-07-17 16:16:27', 42183, 101, '', '21257_Clickedfile.png', 'https://kwt.cmrisoftware.com//Attachments\\EtWorkOrder\42183\21257_Clickedfile.png', 'D:\KWTCMRI2\CMRIApp\Attachments\\EtWorkOrder\42183\21257_Clickedfile.png', '', 47.1436749, 29.4537527, '2023-07-17 16:03:47') 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
 Platform: Web
17-07-2023 04:17:45 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 226)  Order by s.id desc
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:18:35 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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 = 225)  or wo.Department_PK = (select department_id from mst_users where id = 225)  or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 225)  or ifnull(mst_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 = 225)   order by wo.ID desc 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:19:44 ## 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 document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And document_id In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 226)   order by id desc 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
17-07-2023 04:19:44 ## 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 s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 101 And s.vid In ( select wo.id from  et_work_order wo  left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  where wo.vtype = 101 And ifnull(wo.wo_status_pk,0) not in (8, 11) And et_document_users.User_id = 235)  Order by s.id desc
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
17-07-2023 04:19:48 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:19:48 ## Error ##  ## DataAccess.GetData ##  ## Display_DocumentUser
Unable to connect to data base
17-07-2023 04:19:48 ## Error ##  ## DataAccess.GetData ##  ## Display_DocumentTank
Unable to connect to data base
17-07-2023 04:19:48 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:25:04 ## 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 A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.name as site_code, w.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, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date,  (Case IFNULL(w.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(w.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2023-07-17 23:59:59')  as A  order by vno 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:27:02 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:02 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:27:10 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:10 ## Error ##  ## DataAccess.SetData ##  ## Error
17-07-2023 04:27:25 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:25 ## Error ##  ## DataAccess.GetData ##  ## GetPendingNotification
Unable to connect to data base
17-07-2023 04:27:33 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:33 ## Error ##  ## DataAccess.SetData ##  ## Error
17-07-2023 04:27:33 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:33 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:27:44 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:44 ## Error ##  ## DataAccess.GetData ##  ## ShortList_Master
Unable to connect to data base
17-07-2023 04:27:48 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:48 ## Error ##  ## DataAccess.GetData ##  ## Display_DocumentDGPM
Unable to connect to data base
17-07-2023 04:27:50 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:27:50 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:28:25 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:28:25 ## Error ##  ## DataAccess.SetData ##  ## Error
17-07-2023 04:28:31 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:28:31 ## Error ##  ## DataAccess.GetData ##  ## List_DocumentAttachment
Unable to connect to data base
17-07-2023 04:28:42 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:28:42 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:28:46 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:28:46 ## Error ##  ## DataAccess.GetData ##  ## List_DocumentAttachment
Unable to connect to data base
17-07-2023 04:28:52 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:28:52 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:29:04 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:29:04 ## Error ##  ## DataAccess.GetData ##  ## List_DocumentAttachment
Unable to connect to data base
17-07-2023 04:29:10 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:29:10 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
17-07-2023 04:29:14 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:29:14 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
17-07-2023 04:30:07 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:30:07 ## Error ##  ## DataAccess.GetData ##  ## GetPendingNotification
Unable to connect to data base
17-07-2023 04:30:21 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:30:21 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
17-07-2023 04:30:25 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:30:25 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
17-07-2023 04:30:29 ## Error ##  ## DataAccess.GetData ##  ## List_DocumentAttachment
Unable to connect to data base
17-07-2023 04:30:29 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:30:38 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:30:38 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:30:50 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:30:50 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:31:00 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:31:00 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:31:09 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
17-07-2023 04:31:09 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
17-07-2023 04:34:42 ## 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,  (Case IFNULL(wo.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(wo.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function,  (Case IFNULL(wo.wo_maintanance, 0)  when 0 then 'DGPM'  when 1 then 'Site_Visit'  end) as wo_maintanance  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  )  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
17-07-2023 04:36:27 ## 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 A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.name as site_code, w.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, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date,  (Case IFNULL(w.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(w.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2023-07-17 23:59:59')  as A  order by vno 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data
17-07-2023 04:38:40 ## 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 A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.name as site_code, w.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, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date,  (Case IFNULL(w.wo_site_type, 0)  when 0 then 'Hybrid'  when 1 then 'Normal'  end) as wo_site_type, (Case IFNULL(w.dg_function, 0)  when 0 then 'Auto'  when 1 then 'Manual'  end) as dg_function  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2023-07-17 23:59:59')  as A  order by vno 
 Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 Source: MySql.Data