14-11-2022 01:02:33 ## Exception ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ## DataAccess.GetData ## ## Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. select 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 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 14-11-2022 01:09:54 ## 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 wo.Project_PK not in (select master_id from mst_user_rights where right_type = 1 and user_id = 225) order by wo.ID desc Inner Exception: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. Source: MySql.Data 14-11-2022 09:11: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 ## ## 14-11-2022 09:11:43 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 14-11-2022 09:15:38 ## 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 ## ## 14-11-2022 09:15:38 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 14-11-2022 09:15:38 ## 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 ## ## 14-11-2022 09:15:38 ## 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 ## ## 14-11-2022 09:15:38 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 14-11-2022 09:15:38 ## Error ## ## DataAccess.GetData ## ## GetPendingNotification Unable to connect to data base 14-11-2022 09:15:39 ## 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 ## ## 14-11-2022 09:15:39 ## Error ## ## DataAccess.GetData ## ## Get_WorkOrderForUser Unable to connect to data base 14-11-2022 09:16:02 ## 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 ## ## 14-11-2022 09:16:02 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 14-11-2022 09:16: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 id, updated_at, notification_type, message from et_notification where to_user_id = 221 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 14-11-2022 09:17:20 ## 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 ## ## 14-11-2022 09:17:20 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 14-11-2022 09:18: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 ## ## 14-11-2022 09:18:11 ## Error ## ## DataAccess.GetData ## ## GetEncryptionKey Unable to connect to data base 14-11-2022 09:18:35 ## 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 ## ## 14-11-2022 09:18:35 ## Error ## ## DataAccess.GetData ## ## LoginUser Unable to connect to data base 14-11-2022 09:19: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 ## ## 14-11-2022 09:19:14 ## Error ## ## DataAccess.GetData ## ## GetEncryptionKey Unable to connect to data base 14-11-2022 09:19: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 ## ## 14-11-2022 09:19:19 ## Error ## ## DataAccess.GetData ## ## List_WorkOrder Unable to connect to data base 14-11-2022 09:19:27 ## 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 ## ## 14-11-2022 09:19:27 ## Error ## ## DataAccess.GetData ## ## LoginUser Unable to connect to data base 14-11-2022 09:20:03 ## 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 ## ## 14-11-2022 09:20:03 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 14-11-2022 09:20:09 ## 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 ## ## 14-11-2022 09:20:09 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 14-11-2022 09:20:15 ## 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 ## ## 14-11-2022 09:20:15 ## Error ## ## DataAccess.GetData ## ## GetNotification_UserDepartmentAssistanceRequired Unable to connect to data base 14-11-2022 09:20: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 ## ## 14-11-2022 09:20:16 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:20: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 ## ## 14-11-2022 09:20:16 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:20: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 ## ## 14-11-2022 09:20:16 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:20: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 ## ## 14-11-2022 09:20:34 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:20:38 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:20:38 ## 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 ## ## 14-11-2022 09:20:42 ## 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 ## ## 14-11-2022 09:20:43 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:20: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 ## ## 14-11-2022 09:20:42 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:20: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 ## ## 14-11-2022 09:20:45 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:22:33 ## Exception ## Timeout performing DEL 221|APIExtendedData, inst: 1, mgr: ExecuteSelect, err: never, queue: 2, qu: 2, qs: 0, qc: 0, wr: 0, wq: 0, in: 0, ar: 0, clientName: CMRIV2KW, serverEndpoint: Unspecified/localhost:6379, keyHashSlot: 5749, IOCP: (Busy=2,Free=998,Min=1,Max=1000), WORKER: (Busy=0,Free=32767,Min=1,Max=32767) (Please take a look at this article for some common client-side issues that can cause timeouts: http://stackexchange.github.io/StackExchange.Redis/Timeouts) ## APIExtendedData.GetExtendedData ## ## Timeout performing DEL 221|APIExtendedData, inst: 1, mgr: ExecuteSelect, err: never, queue: 2, qu: 2, qs: 0, qc: 0, wr: 0, wq: 0, in: 0, ar: 0, clientName: CMRIV2KW, serverEndpoint: Unspecified/localhost:6379, keyHashSlot: 5749, IOCP: (Busy=2,Free=998,Min=1,Max=1000), WORKER: (Busy=0,Free=32767,Min=1,Max=32767) (Please take a look at this article for some common client-side issues that can cause timeouts: http://stackexchange.github.io/StackExchange.Redis/Timeouts) 14-11-2022 09:22:48 ## Exception ## Timeout performing DEL 221|APIExtendedData, inst: 1, mgr: NoSocketsPause, err: never, queue: 0, qu: 0, qs: 0, qc: 0, wr: 0, wq: 0, in: 0, ar: 0, clientName: CMRIV2KW, serverEndpoint: Unspecified/localhost:6379, keyHashSlot: 5749, IOCP: (Busy=1,Free=999,Min=1,Max=1000), WORKER: (Busy=0,Free=32767,Min=1,Max=32767) (Please take a look at this article for some common client-side issues that can cause timeouts: http://stackexchange.github.io/StackExchange.Redis/Timeouts) ## APIExtendedData.GetExtendedData ## ## Timeout performing DEL 221|APIExtendedData, inst: 1, mgr: NoSocketsPause, err: never, queue: 0, qu: 0, qs: 0, qc: 0, wr: 0, wq: 0, in: 0, ar: 0, clientName: CMRIV2KW, serverEndpoint: Unspecified/localhost:6379, keyHashSlot: 5749, IOCP: (Busy=1,Free=999,Min=1,Max=1000), WORKER: (Busy=0,Free=32767,Min=1,Max=32767) (Please take a look at this article for some common client-side issues that can cause timeouts: http://stackexchange.github.io/StackExchange.Redis/Timeouts) 14-11-2022 09:22:59 ## Exception ## Timeout performing DEL 218|APIExtendedData, inst: 1, mgr: ExecuteSelect, err: never, queue: 1, qu: 0, qs: 1, qc: 0, wr: 0, wq: 0, in: 0, ar: 0, clientName: CMRIV2KW, serverEndpoint: Unspecified/localhost:6379, keyHashSlot: 501, IOCP: (Busy=1,Free=999,Min=1,Max=1000), WORKER: (Busy=1,Free=32766,Min=1,Max=32767) (Please take a look at this article for some common client-side issues that can cause timeouts: http://stackexchange.github.io/StackExchange.Redis/Timeouts) ## APIExtendedData.GetExtendedData ## ## Timeout performing DEL 218|APIExtendedData, inst: 1, mgr: ExecuteSelect, err: never, queue: 1, qu: 0, qs: 1, qc: 0, wr: 0, wq: 0, in: 0, ar: 0, clientName: CMRIV2KW, serverEndpoint: Unspecified/localhost:6379, keyHashSlot: 501, IOCP: (Busy=1,Free=999,Min=1,Max=1000), WORKER: (Busy=1,Free=32766,Min=1,Max=32767) (Please take a look at this article for some common client-side issues that can cause timeouts: http://stackexchange.github.io/StackExchange.Redis/Timeouts) 14-11-2022 09:27:25 ## 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 ## ## 14-11-2022 09:27:25 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 14-11-2022 09:27:25 ## 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 ## ## 14-11-2022 09:27:25 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 14-11-2022 09:27:46 ## 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 ## ## 14-11-2022 09:27:46 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 14-11-2022 09:27:56 ## Error ## ## DataAccess.GetData ## ## GetPendingNotification Unable to connect to data base 14-11-2022 09:27: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 ## ## 14-11-2022 09:28: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 ## ## 14-11-2022 09:28:01 ## Error ## ## DataAccess.GetData ## ## Get_WorkOrderForUser Unable to connect to data base 14-11-2022 09:28: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 ## ## 14-11-2022 09:28:13 ## Error ## ## DataAccess.GetData ## ## GetEncryptionKey Unable to connect to data base 14-11-2022 09:28: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 id, updated_at, notification_type, message from et_notification where to_user_id = 226 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: Timeout in IO operation Source: MySql.Data 14-11-2022 09:30: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 ## ## 14-11-2022 09:30: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 ## ## 14-11-2022 09:30:53 ## Error ## ## DataAccess.GetData ## ## Display_GeneralConfiguration Unable to connect to data base 14-11-2022 09:30:53 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:30: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 ## ## 14-11-2022 09:30:53 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:30: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 ## ## 14-11-2022 09:30:55 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:30:55 ## 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 ## ## 14-11-2022 09:30:53 ## Error ## ## DataAccess.GetData ## ## LoginUserInfo Unable to connect to data base 14-11-2022 09:52:13 ## Info ## ## EmailSMSUtility.sendSMSUsingTwilio ## ## SMS Using Twilio Exception The 'To' number 66572326 is not a valid phone number. 14-11-2022 05:31:40 ## Exception ## Timeout can be only be set to 'System.Threading.Timeout.Infinite' or a value > 0. Parameter name: value ## DataAccess.GetData ## ## Timeout can be only be set to 'System.Threading.Timeout.Infinite' or a value > 0. Parameter name: value select id, updated_at, notification_type, message from et_notification where to_user_id = 226 and ifnull(mark_read, 0) = 0 order by notification_type, id desc Inner Exception: NULL Source: System