02-11-2022 01:15:17 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 01:15:17 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:17 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:17 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 01:15:17 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:17 ## Error ## ## DataAccess.GetData ## ## ShortList_WorkOrderTemplate Unable to connect to data base 02-11-2022 01:15:17 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:17 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 01:15:17 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:17 ## Error ## ## DataAccess.GetData ## ## Display_UDF_Configuration Unable to connect to data base 02-11-2022 01:15:17 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:17 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 02-11-2022 01:15:17 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:17 ## Error ## ## DataAccess.GetData ## ## ShortList_Master Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## ShortList_Master Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## ShortList_Master Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## ShortList_Master Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## Display_WorkOrder Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## ShortList_Master Unable to connect to data base 02-11-2022 01:15:19 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:15:19 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 01:16:14 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:16:14 ## Error ## ## DataAccess.GetData ## ## List_WorkOrder Unable to connect to data base 02-11-2022 01:16:28 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:16:28 ## Error ## ## DataAccess.GetData ## ## GetNotification_UserDepartmentAssistanceRequired Unable to connect to data base 02-11-2022 01:16:34 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:16:34 ## Error ## ## DataAccess.GetData ## ## GetPendingNotification Unable to connect to data base 02-11-2022 01:16:50 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:16:50 ## Error ## ## DataAccess.GetData ## ## List_WorkOrder Unable to connect to data base 02-11-2022 01:16:52 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:16:52 ## Error ## ## DataAccess.GetData ## ## Display_UDF_Configuration Unable to connect to data base 02-11-2022 01:17:43 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:17:43 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Request_L2WiseOpenClosedCount Unable to connect to data base 02-11-2022 01:17:43 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:17:43 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:17:43 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Workorder_OpenCategoryCount Unable to connect to data base 02-11-2022 01:17:43 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:17:43 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Workorder_ClosedSubDepartmentCount Unable to connect to data base 02-11-2022 01:17:43 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Request_Top10Sites Unable to connect to data base 02-11-2022 01:17:43 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:17:43 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Request_L2WiseCount Unable to connect to data base 02-11-2022 01:17:43 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:17:43 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Survey_Top10Sites Unable to connect to data base 02-11-2022 01:17:44 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 01:17:44 ## Error ## ## DataAccess.SetData ## ## Error 02-11-2022 08:28:52 ## 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(19480, 218, 5923, '2022-11-02 08:28:52', 101) Inner Exception: NULL Source: MySql.Data Platform: Web 02-11-2022 10:25:18 ## 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 = 558 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 02-11-2022 10:25: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 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 = 558 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 02-11-2022 10:38:21 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:38:21 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 02-11-2022 10:38:23 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:38:23 ## Error ## ## DataAccess.GetData ## ## List_DocumentAttachment Unable to connect to data base 02-11-2022 10:39: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 id, updated_at, notification_type, message from et_notification where to_user_id = 209 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 02-11-2022 10:39: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 id, updated_at, notification_type, message from et_notification where to_user_id = 209 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 02-11-2022 10:39:59 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:39:59 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 10:40:00 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:40:00 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 10:40:06 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:40:06 ## Error ## ## DataAccess.SetData ## ## Error 02-11-2022 10:40:29 ## Error ## ## DataAccess.GetData ## ## Display_UDF_Configuration Unable to connect to data base 02-11-2022 10:40:29 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:40:34 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:40:34 ## Error ## ## DataAccess.GetData ## ## List_WorkOrder Unable to connect to data base 02-11-2022 10:40:51 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:40:51 ## Error ## ## DataAccess.GetData ## ## GetEncryptionKey Unable to connect to data base 02-11-2022 10:41:06 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:41:06 ## Error ## ## DataAccess.GetData ## ## LoginUser Unable to connect to data base 02-11-2022 10:41: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 id, updated_at, notification_type, message from et_notification where to_user_id = 209 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 02-11-2022 10:41:30 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:41:30 ## Error ## ## DataAccess.SetData ## ## Error 02-11-2022 10:41: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 = 227) or wo.Department_PK = (select department_id from mst_users where id = 227) or wo.Sub_Department_PK = (select subdepartment_id from mst_users where id = 227) 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 = 227) 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 02-11-2022 10:42:45 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:42:45 ## Error ## ## DataAccess.GetData ## ## List_DocumentAttachment Unable to connect to data base 02-11-2022 10:43:52 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:43:52 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:43:52 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 10:43:52 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 02-11-2022 10:44:01 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:44:01 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 10:44:29 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:44:29 ## Error ## ## DataAccess.GetData ## ## GetEncryptionKey Unable to connect to data base 02-11-2022 10:44:54 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:44:54 ## Error ## ## DataAccess.GetData ## ## GetPendingNotification Unable to connect to data base 02-11-2022 10:44:54 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:44:54 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 02-11-2022 10:44:59 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:44:59 ## Error ## ## DataAccess.GetData ## ## Get_WorkOrderForUser Unable to connect to data base 02-11-2022 10:44:59 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:01 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:44:59 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 10:45:01 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 10:45:08 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:08 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 02-11-2022 10:45:14 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:14 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 10:45:50 ## Error ## ## DataAccess.GetData ## ## GetPendingNotification Unable to connect to data base 02-11-2022 10:45:50 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:50 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:50 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Request_L2WiseCount Unable to connect to data base 02-11-2022 10:45:54 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:54 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Request_L2WiseOpenClosedCount Unable to connect to data base 02-11-2022 10:45:54 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:54 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Workorder_OpenCategoryCount Unable to connect to data base 02-11-2022 10:45:54 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:54 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:54 ## Error ## ## DataAccess.GetData ## ## Get_WorkOrderForUser Unable to connect to data base 02-11-2022 10:45:54 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Survey_Top10Sites Unable to connect to data base 02-11-2022 10:45:56 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:45:56 ## Error ## ## DataAccess.GetData ## ## Rpt_DashboardWidget_Workorder_ClosedSubDepartmentCount Unable to connect to data base 02-11-2022 10:46: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 id, updated_at, notification_type, message from et_notification where to_user_id = 216 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 02-11-2022 10:46: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 id, updated_at, notification_type, message from et_notification where to_user_id = 227 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 02-11-2022 10:46:41 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:46:41 ## Error ## ## DataAccess.GetData ## ## Display_UDF_Configuration Unable to connect to data base 02-11-2022 10:46:43 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:46:43 ## Error ## ## DataAccess.GetData ## ## List_WorkOrder Unable to connect to data base 02-11-2022 10:46:53 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:46:53 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 02-11-2022 10:48:40 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:48:40 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 02-11-2022 10:49:04 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:49:04 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 02-11-2022 10:49:07 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select id, updated_at, notification_type, message from et_notification where to_user_id = 216 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 02-11-2022 10:49:11 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:49:11 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 02-11-2022 10:49:11 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:49:11 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 02-11-2022 10:49:41 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:49:41 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 02-11-2022 10:50:00 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:50:00 ## Error ## ## DataAccess.GetData ## ## GetEncryptionKey Unable to connect to data base 02-11-2022 10:50: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 id, updated_at, notification_type, message from et_notification where to_user_id = 216 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 02-11-2022 10:50:13 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:50:13 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 02-11-2022 10:50:16 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:50:16 ## Error ## ## DataAccess.GetData ## ## LoginUser Unable to connect to data base 02-11-2022 10:50:34 ## Error ## ## DataAccess.GetData ## ## GetEncryptionKey Unable to connect to data base 02-11-2022 10:50:34 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:50:44 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:50:44 ## Error ## ## DataAccess.GetData ## ## Get_WorkOrderForUser Unable to connect to data base 02-11-2022 10:51:12 ## Exception ## Authentication to host '192.168.250.161' for user 'cmriUser' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ## DataAccess.GetConnection ## ## 02-11-2022 10:51:12 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 02-11-2022 04:55:46 ## Info ## ## EmailSMSUtility.sendSMSUsingTwilio ## ## SMS Using Twilio Exception The 'To' number 55627822 is not a valid phone number. 02-11-2022 04:55:53 ## Info ## ## EmailSMSUtility.sendSMSUsingTwilio ## ## SMS Using Twilio Exception The 'To' number 55627822 is not a valid phone number. 02-11-2022 08:23:08 ## Info ## ## EmailSMSUtility.sendSMSUsingTwilio ## ## SMS Using Twilio Exception The 'To' number 60418624 is not a valid phone number.