06-06-2022 06:42:32 ## Exception ## Out of range value for column 'workunits' at row 1 ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentUser
Out of range value for column 'workunits' at row 1
INSERT INTO et_document_users(vid, User_id, workunits, updated_at, vtype) VALUES(4811, 214, 4257, '2022-06-06 06:42:32', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
06-06-2022 06:42:34 ## Exception ## Out of range value for column 'workunits' at row 1 ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentUser
Out of range value for column 'workunits' at row 1
INSERT INTO et_document_users(vid, User_id, workunits, updated_at, vtype) VALUES(4811, 214, 4257, '2022-06-06 06:42:34', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
06-06-2022 06:42:34 ## Exception ## Out of range value for column 'workunits' at row 1 ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentUser
Out of range value for column 'workunits' at row 1
INSERT INTO et_document_users(vid, User_id, workunits, updated_at, vtype) VALUES(4811, 214, 4257, '2022-06-06 06:42:34', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
06-06-2022 08:28: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 A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.id as site_code, w.status, mst_wo_category.name as wo_category, mst_departments.name as department_name, mst_sub_departments.name as sub_department_name,  mst_projects.name as project_name, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2022-06-06 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
06-06-2022 12:11:49 ## Exception ## Out of range value for column 'workunits' at row 1 ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentUser
Out of range value for column 'workunits' at row 1
INSERT INTO et_document_users(vid, User_id, workunits, updated_at, vtype) VALUES(3740, 199, 2678, '2022-06-06 12:11:49', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
06-06-2022 01:06:53 ## Info ##  ## EmailSMSUtility.sendSMSUsingTwilio ##  ## SMS Using Twilio Exception The 'To' number 67734504 is not a valid phone number.
06-06-2022 02:13:35 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ##  ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
select A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.id as site_code, w.status, mst_wo_category.name as wo_category, mst_departments.name as department_name, mst_sub_departments.name as sub_department_name,  mst_projects.name as project_name, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2022-06-06 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
06-06-2022 02:14: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 A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.id as site_code, w.status, mst_wo_category.name as wo_category, mst_departments.name as department_name, mst_sub_departments.name as sub_department_name,  mst_projects.name as project_name, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2022-06-06 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
06-06-2022 02:18: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 A.*, TimeDiff(A.closed_status_date, A.arrived_status_date) as duration_time  from (select w.vno, w.tag, mst_site_owners.name as owner_name, mst_site_logical.id as site_code, w.status, mst_wo_category.name as wo_category, mst_departments.name as department_name, mst_sub_departments.name as sub_department_name,  mst_projects.name as project_name, w.description, w.Date_Created, w.Date_Scheduled, w.Date_Due, w.Date_Started, w.Date_Closed, mst_created_by.name as created_by_user,  (select count(*) from et_document_users where vtype = 101 and vid = w.id) as no_of_user,  (select group_concat(mst_users.name) from et_document_users left outer join mst_users on mst_users.id = et_document_users.user_id where et_document_users.vtype = 101 and et_document_users.vid = w.id) as assigned_users,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id) as total_task,  (select count(*) from et_document_tasks where vtype = 101 and vid = w.id and ifnull(completed,0) = 0) as open_task,  (select count(*) from et_document_attachment where document_id = w.id and document_type = 101) as attachments,  (select group_concat(url separator ';<br/>') from et_document_attachment where document_id = w.id and document_type = 101) as attachment_string,  (select count(*) from et_document_notes where vtype = 101 and vid = w.id) as notes,  (select count(*) from et_document_stc where vtype = 101 and vid = w.id) as inventory_nos,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 12 limit 1) as arrived_status_date,  (select Status_date from et_users_status where vtype = 101 and vid = w.id and status_id = 8 limit 1) as closed_status_date  from et_work_order w  left outer join mst_site_physical on mst_site_physical.id = w.Site_PK  left outer join mst_site_owners on mst_site_owners.id = mst_site_physical.Owner_PK  left outer join mst_site_logical on mst_site_logical.id = w.Site_L_PK  left outer join mst_wo_category on mst_wo_category.id = w.wo_category_pk  left outer join mst_departments on mst_departments.id = w.Department_PK  left outer join mst_sub_departments on mst_sub_departments.id = w.Sub_Department_PK  left outer join mst_projects on mst_projects.id = w.Project_PK  left outer join mst_users mst_created_by on mst_created_by.id = w.created_by_user_pk  where w.vtype = 101   and w.Date_Created is not null and w.Date_Created >= '2015-04-01 00:00:01' and w.Date_Created <= '2022-06-06 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
06-06-2022 08:02:56 ## Exception ## Out of range value for column 'workunits' at row 1 ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentUser
Out of range value for column 'workunits' at row 1
INSERT INTO et_document_users(vid, User_id, workunits, updated_at, vtype) VALUES(4845, 222, 4520, '2022-06-06 20:02:56', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
06-06-2022 08:02:58 ## Exception ## Out of range value for column 'workunits' at row 1 ## DataAccess.SetData ##  ## Exception in query: SaveUpdate_DocumentUser
Out of range value for column 'workunits' at row 1
INSERT INTO et_document_users(vid, User_id, workunits, updated_at, vtype) VALUES(4845, 222, 4520, '2022-06-06 20:02:58', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web