03-12-2022 12:22:48 ## Info ##  ## EmailSMSUtility.sendSMSUsingTwilio ##  ## SMS Using Twilio Exception The 'To' number 55497708 is not a valid phone number.
03-12-2022 01:02:53 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ##  ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Select u.id, u.Userid, u.company, u.department_id, u.department_name, u.subdepartment_id, u.subdepartment_name, u.designation_id, u.designation_name, u.name, u.hayat_email, u.origin, u.passport_no, u.main_proficiency_id, u.alt_proficiency_id,  u.cc_mobile_no_1, u.mobile_no_1, u.cc_mobile_no_2, u.mobile_no_2, u.visa__no, u.id_no, u.car_license_plate_import, u.car_license_plate, u.country_fk, u.location, u.assistance_required,  (select group_concat(et_work_order.vno) from et_work_order left outer join et_document_users on (et_document_users.vid = et_work_order.id and et_document_users.vtype = 101) where et_document_users.user_id = u.id and et_work_order.wo_status_pk not in (8,11)) as work_order_current,  (select group_concat(et_survey.id) from et_survey left outer join et_document_users on (et_document_users.vid = et_survey.id and et_document_users.vtype = 107) where et_document_users.user_id = u.id and et_survey.status not in (7,9)) as survey_current,  (select group_concat(et_request.id) from et_request left outer join et_document_users on (et_document_users.vid = et_request.id and et_document_users.vtype = 103) where et_document_users.user_id = u.id and et_request.status_pk not in (7,9)) as request_current,  (select group_concat(et_snag.id) from et_snag left outer join et_document_users on (et_document_users.vid = et_snag.id and et_document_users.vtype = 108) where et_document_users.user_id = u.id and et_snag.status not in (7,9)) as snag_current,  u.apk_version, u.gcm_registration_id, u.notification_settings,  u.use_tracking, u.tracking_timeout, u.uuid, u.project_pk, (case when ifnull(u.inactive,0) = 0 then 'Yes' else 'No' end) as Active, last_user_status.Latitude, last_user_status.Longitude, last_user_status.Status,  fn_calc_distance(destination_site.L_longitude, destination_site.L_latitude, last_user_status.Longitude, last_user_status.Latitude) as distance, GetUserDocument(u.id) as user_documents,  u.function, u.team, (case when ifnull(u.active_on_shift, 0) = 1 then 'Yes' else 'No' end) as active_on_shift,  concat((case ifnull(last_doc_status.vtype, 0) when 101 then 'Workorder' when 103 then 'Request' when 107 then 'Survey' when 108 then 'Snag' else '' end), ' ', last_doc_status.vno, ' ', last_doc_status.status_date, ' ', mst_site_logical.name) as current_docment, mst_user_shift.name as shift_name  from mst_users u  left outer join et_users_status last_user_status on last_user_status.id = (select id from et_users_status where PK_User = u.id and ifnull(vid,0) = 0 order by Status_date limit 1)  left outer join et_users_status last_doc_status on last_doc_status.id = (select id from et_users_status where PK_User = u.id and ifnull(vid,0) <> 0 order by Status_date limit 1)  left outer join mst_site_logical on mst_site_logical.id = last_doc_status.site_l_id  left outer join mst_site_logical destination_site on destination_site.id = 250  left outer join mst_user_shift on mst_user_shift.id = u.shift_id  where 1=1  order by u.name 
 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
03-12-2022 01:03: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 u.id, u.Userid, u.company, u.department_id, u.department_name, u.subdepartment_id, u.subdepartment_name, u.designation_id, u.designation_name, u.name, u.hayat_email, u.origin, u.passport_no, u.main_proficiency_id, u.alt_proficiency_id,  u.cc_mobile_no_1, u.mobile_no_1, u.cc_mobile_no_2, u.mobile_no_2, u.visa__no, u.id_no, u.car_license_plate_import, u.car_license_plate, u.country_fk, u.location, u.assistance_required,  (select group_concat(et_work_order.vno) from et_work_order left outer join et_document_users on (et_document_users.vid = et_work_order.id and et_document_users.vtype = 101) where et_document_users.user_id = u.id and et_work_order.wo_status_pk not in (8,11)) as work_order_current,  (select group_concat(et_survey.id) from et_survey left outer join et_document_users on (et_document_users.vid = et_survey.id and et_document_users.vtype = 107) where et_document_users.user_id = u.id and et_survey.status not in (7,9)) as survey_current,  (select group_concat(et_request.id) from et_request left outer join et_document_users on (et_document_users.vid = et_request.id and et_document_users.vtype = 103) where et_document_users.user_id = u.id and et_request.status_pk not in (7,9)) as request_current,  (select group_concat(et_snag.id) from et_snag left outer join et_document_users on (et_document_users.vid = et_snag.id and et_document_users.vtype = 108) where et_document_users.user_id = u.id and et_snag.status not in (7,9)) as snag_current,  u.apk_version, u.gcm_registration_id, u.notification_settings,  u.use_tracking, u.tracking_timeout, u.uuid, u.project_pk, (case when ifnull(u.inactive,0) = 0 then 'Yes' else 'No' end) as Active, last_user_status.Latitude, last_user_status.Longitude, last_user_status.Status,  fn_calc_distance(destination_site.L_longitude, destination_site.L_latitude, last_user_status.Longitude, last_user_status.Latitude) as distance, GetUserDocument(u.id) as user_documents,  u.function, u.team, (case when ifnull(u.active_on_shift, 0) = 1 then 'Yes' else 'No' end) as active_on_shift,  concat((case ifnull(last_doc_status.vtype, 0) when 101 then 'Workorder' when 103 then 'Request' when 107 then 'Survey' when 108 then 'Snag' else '' end), ' ', last_doc_status.vno, ' ', last_doc_status.status_date, ' ', mst_site_logical.name) as current_docment, mst_user_shift.name as shift_name  from mst_users u  left outer join et_users_status last_user_status on last_user_status.id = (select id from et_users_status where PK_User = u.id and ifnull(vid,0) = 0 order by Status_date limit 1)  left outer join et_users_status last_doc_status on last_doc_status.id = (select id from et_users_status where PK_User = u.id and ifnull(vid,0) <> 0 order by Status_date limit 1)  left outer join mst_site_logical on mst_site_logical.id = last_doc_status.site_l_id  left outer join mst_site_logical destination_site on destination_site.id = 250  left outer join mst_user_shift on mst_user_shift.id = u.shift_id  where 1=1  order by u.name 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
03-12-2022 01:08:01 ## 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(22180, 204, 21243, '2022-12-03 01:08:01', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
03-12-2022 01:08:16 ## 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(22180, 204, 21243, '2022-12-03 01:08:16', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
03-12-2022 01:08:40 ## 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(22180, 204, 21243, '2022-12-03 01:08:40', 101)
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
03-12-2022 01:11:47 ## Exception ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ##  ## Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Select u.id, u.Userid, u.company, u.department_id, u.department_name, u.subdepartment_id, u.subdepartment_name, u.designation_id, u.designation_name, u.name, u.hayat_email, u.origin, u.passport_no, u.main_proficiency_id, u.alt_proficiency_id,  u.cc_mobile_no_1, u.mobile_no_1, u.cc_mobile_no_2, u.mobile_no_2, u.visa__no, u.id_no, u.car_license_plate_import, u.car_license_plate, u.country_fk, u.location, u.assistance_required,  (select group_concat(et_work_order.vno) from et_work_order left outer join et_document_users on (et_document_users.vid = et_work_order.id and et_document_users.vtype = 101) where et_document_users.user_id = u.id and et_work_order.wo_status_pk not in (8,11)) as work_order_current,  (select group_concat(et_survey.id) from et_survey left outer join et_document_users on (et_document_users.vid = et_survey.id and et_document_users.vtype = 107) where et_document_users.user_id = u.id and et_survey.status not in (7,9)) as survey_current,  (select group_concat(et_request.id) from et_request left outer join et_document_users on (et_document_users.vid = et_request.id and et_document_users.vtype = 103) where et_document_users.user_id = u.id and et_request.status_pk not in (7,9)) as request_current,  (select group_concat(et_snag.id) from et_snag left outer join et_document_users on (et_document_users.vid = et_snag.id and et_document_users.vtype = 108) where et_document_users.user_id = u.id and et_snag.status not in (7,9)) as snag_current,  u.apk_version, u.gcm_registration_id, u.notification_settings,  u.use_tracking, u.tracking_timeout, u.uuid, u.project_pk, (case when ifnull(u.inactive,0) = 0 then 'Yes' else 'No' end) as Active, last_user_status.Latitude, last_user_status.Longitude, last_user_status.Status,  fn_calc_distance(destination_site.L_longitude, destination_site.L_latitude, last_user_status.Longitude, last_user_status.Latitude) as distance, GetUserDocument(u.id) as user_documents,  u.function, u.team, (case when ifnull(u.active_on_shift, 0) = 1 then 'Yes' else 'No' end) as active_on_shift,  concat((case ifnull(last_doc_status.vtype, 0) when 101 then 'Workorder' when 103 then 'Request' when 107 then 'Survey' when 108 then 'Snag' else '' end), ' ', last_doc_status.vno, ' ', last_doc_status.status_date, ' ', mst_site_logical.name) as current_docment, mst_user_shift.name as shift_name  from mst_users u  left outer join et_users_status last_user_status on last_user_status.id = (select id from et_users_status where PK_User = u.id and ifnull(vid,0) = 0 order by Status_date limit 1)  left outer join et_users_status last_doc_status on last_doc_status.id = (select id from et_users_status where PK_User = u.id and ifnull(vid,0) <> 0 order by Status_date limit 1)  left outer join mst_site_logical on mst_site_logical.id = last_doc_status.site_l_id  left outer join mst_site_logical destination_site on destination_site.id = 250  left outer join mst_user_shift on mst_user_shift.id = u.shift_id  where 1=1  order by u.name 
 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