08-05-2022 12:34: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 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 = 196) or wo.Department_PK = (select department_id from mst_users where id = 196) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 196) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 196) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:50:11 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 196) or wo.Department_PK = (select department_id from mst_users where id = 196) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 196) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 196) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 02:17: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 03:18: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 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 03:23: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 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 05:07:09 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 06:03:26 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 06:15: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 06:18:10 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 08:53: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 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 10:16: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 10:23:25 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 10:26:31 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 10:37: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 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 = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 11:02:52 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 195) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 11:03:52 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 191) 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 08-05-2022 11:05:05 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 11:07: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 191) 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 08-05-2022 11:07:13 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 11:09:24 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 11:09: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 191) 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 08-05-2022 11:11: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 11:15: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 191) 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 08-05-2022 11:20: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 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 = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 191) 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 08-05-2022 11:41:31 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 11:42:50 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 11:46: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:03: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 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:05: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 190) or wo.Department_PK = (select department_id from mst_users where id = 190) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 190) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 190) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:05: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 195) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:05: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 12:06:30 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:07: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:08: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 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 or ifnull(mst_sub_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 08-05-2022 12:09: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 196) or wo.Department_PK = (select department_id from mst_users where id = 196) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 196) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 196) 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 08-05-2022 12:10:29 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:14:24 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 196) or wo.Department_PK = (select department_id from mst_users where id = 196) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 196) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 196) 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 08-05-2022 12:22: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 12:33: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:36: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 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 or ifnull(mst_sub_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 08-05-2022 12:40: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:42: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 12:45:15 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:45: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 190) or wo.Department_PK = (select department_id from mst_users where id = 190) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 190) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 190) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 12:53:26 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_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 08-05-2022 01:21: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 195) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 01: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 01:56: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 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 02:30:05 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 02:31: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 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 = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) = 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 03:06: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 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 = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) = 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 03:08:24 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) = 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 03: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) = 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 03:12: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 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 = 191) or wo.Department_PK = (select department_id from mst_users where id = 191) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 191) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) = 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 191) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 03:29: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 05:10:24 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 05:56:15 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 06:07: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 07:06:36 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 07:26:50 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 07:48: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 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 07:58: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 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 08:21:31 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 08:25: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 08:29:25 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 08:39:36 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 08: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 wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 09:02:36 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 196) or wo.Department_PK = (select department_id from mst_users where id = 196) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 196) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 196) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 09:04: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 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 = 196) or wo.Department_PK = (select department_id from mst_users where id = 196) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 196) or ifnull(mst_departments.strict_wo_list,0) = 0 or ifnull(mst_sub_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 = 196) 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 08-05-2022 09:18:30 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 10:26:31 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data 08-05-2022 11:22:25 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select wo.id, wo.vno, wo.tag, mst_site_owners.name as owner_name, mst_site_physical.name as Site_Name, (Case IFNULL(wo.wo_status_pk,0) when 1 then 'Created' when 2 then 'Scheduled' when 3 then 'Assigned' when 4 then 'Confirmed' when 5 then 'Pending' when 6 then 'InProgress' when 7 then 'Completed' when 8 then 'Closed' when 9 then 'Cancelled' when 10 then 'None' when 11 then 'Rejected' when 12 then 'Arrived' when 13 then 'Approved' when 14 then 'InTransit' end) as status, mst_wo_category.name as WO_Category, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name, mst_projects.name as Project_Name, wo.description, wo.Date_Created, wo.Date_Scheduled, wo.Date_Due, wo.Date_Started, (select count(*) from et_document_users where vtype = 101 and vid = wo.id) as assigned, (select group_concat(mst_users.name) from et_document_users wouser left outer join mst_users on mst_users.id = wouser.user_id where wouser.vtype = 101 and wouser.vid = wo.id) as assigned_users, mst_users.name as created_by_user, (select group_concat(mst_inv_item.name) from et_document_stc woinv left outer join mst_inv_item on mst_inv_item.id = woinv.IMM_PK where woinv.vtype = 101 and woinv.vid = wo.id) as inventory_description, (select count(*) from et_document_tasks where vid = wo.id and vtype = 101) as tasks, (select count(*) from et_document_attachment where document_id = wo.id and document_type = 101) as attachments, (select count(*) from et_document_notes where vtype = 101 and vid = wo.id) as notes, (select count(*) from et_document_stc where vtype = 101 and vid = wo.id) as inventory, et_udf.udf_value_1, et_udf.udf_value_2, et_udf.udf_value_3, et_udf.udf_value_4, et_udf.udf_value_5, et_udf.udf_value_6, et_udf.udf_value_7, et_udf.udf_value_8, et_udf.udf_value_9, et_udf.udf_value_10, (case when IFNULL(wo.wo_status_pk,0) in (6, 14, 12) then 'Yes' else 'No' End) as Active from et_work_order wo left outer join mst_departments on mst_departments.id = wo.Department_PK left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK left outer join mst_site_physical on mst_site_physical.id = wo.Site_PK left outer join mst_projects on mst_projects.id = wo.Project_PK left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK left outer join mst_users on mst_users.id = wo.created_by_user_pk left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk left outer join et_udf on (et_udf.master_type = 101 and et_udf.master_id = wo.id) Where 1=1 and wo.vtype = 101 and ( wo.id in (select vid from et_document_users where vtype = 101 and user_id = 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 or ifnull(mst_sub_departments.strict_wo_list,0) = 0 ) And ifnull(wo.wo_status_pk,0) <> 8 and wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 195) order by wo.ID desc Inner Exception: Timeout in IO operation Source: MySql.Data