14-02-2023 07:10:26 ## Info ##  ## EmailSMSUtility.sendSMSUsingTwilio ##  ## SMS Using Twilio Exception The 'To' number 66572326 is not a valid phone number.
14-02-2023 01:00:30 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:00:47 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:01:10 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:01:14 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:01:21 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:01:28 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:01:41 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:02:14 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:02:48 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.8108147, 29.3266247, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27802
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:02:54 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.8108147, 29.3266247, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27802
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:02:58 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:01 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.8108147, 29.3266247, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27802
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:05 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:10 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:10 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:14 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:16 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:22 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:23 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:26 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:27 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:34 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.7127639, 28.8003982, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27878
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:37 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:44 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(0, 0, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 28667
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:54 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:03:56 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
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: NULL 
 Source: MySql.Data
14-02-2023 01:03:57 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:01 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
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: NULL 
 Source: MySql.Data
14-02-2023 01:04:13 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Mlayaq' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:13 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:18 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:27 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:39 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:43 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:46 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:04:54 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:05:08 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:05:31 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:23 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:25 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:30 ## Exception ## Table 'kwtcmri2.mst_completion_code' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_completion_code' doesn't exist
select id, name from mst_completion_code where ifnull(inactive, 0) = 0  order by name
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:30 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:38 ## Exception ## Table 'kwtcmri2.et_document_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_document_users' doesn't exist
 select u.vid, u.user_id, mst_users.name as user_name, u.workunits, mst_users.department_id, mst_departments.name as department_name,  mst_users.subdepartment_id, mst_sub_departments.name as sub_department_name, mst_users.designation_id, mst_designations.name as designation_name,  mst_users.function, mst_users.mobile_no_1, mst_users.mobile_no_2, mst_users.team, (select Status from et_users_status where PK_User = u.User_id and year(Status_date) = year(now()) and month(Status_date) = month(now()) and day(Status_date) = day(now()) order by Status_date desc limit 1) as status  from et_document_users u  left outer join mst_users on mst_users.id = u.user_id  left outer join mst_departments on mst_departments.id = mst_users.department_id  left outer join mst_sub_departments on mst_sub_departments.id = mst_users.subdepartment_id  left outer join mst_designations on mst_designations.id = mst_users.designation_id  where u.vtype = 101  And u.vid = 27781  order by u.id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:38 ## Exception ## Table 'kwtcmri2.mst_site_logical' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_site_logical' doesn't exist
select id, Site_P_PK from mst_site_logical where id in (14) 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:41 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
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: NULL 
 Source: MySql.Data
14-02-2023 01:06:51 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:51 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:51 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:55 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:06:55 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:02 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:02 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:19 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.9950395, 29.2890127, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27892
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:23 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:23 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:27 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.9950395, 29.2890127, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27892
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:29 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:29 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:33 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:33 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:36 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.9950395, 29.2890127, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27892
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:37 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:37 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:39 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 221  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:41 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:41 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:45 ## Exception ## Table 'kwtcmri2.mst_site_owners' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_site_owners' doesn't exist
select id, name from mst_site_owners where ifnull(inactive, 0) = 0  order by name
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:46 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 221  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:07:55 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 221  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:08:35 ## Exception ## Table 'kwtcmri2.et_document_attachment' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_document_attachment' doesn't exist
 Select document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And  document_id = 27937  order by id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:09:05 ## Exception ## Table 'kwtcmri2.et_document_attachment' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_document_attachment' doesn't exist
 Select document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And  document_id = 27937  order by id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:09:07 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
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: NULL 
 Source: MySql.Data
14-02-2023 01:09:10 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
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: NULL 
 Source: MySql.Data
14-02-2023 01:09:12 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
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: NULL 
 Source: MySql.Data
14-02-2023 01:10:08 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 192  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:10:45 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.vno, wo.Site_L_PK, wo.wo_status_pk, wo.Date_Started, (select count(*) from et_document_tasks where vtype = 101 and vid = wo.id and ifnull(completed, 0) = 0) as not_completed,  fn_calc_distance(47.9950395, 29.2890127, mst_site_logical.L_longitude, mst_site_logical.L_latitude) as distance  from et_work_order wo  left outer join mst_site_logical on mst_site_logical.id = wo.Site_L_PK  where wo.id = 27892
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:10:51 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 221  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:10:57 ## Exception ## Table 'kwtcmri2.mst_site_owners' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_site_owners' doesn't exist
select id, name from mst_site_owners where ifnull(inactive, 0) = 0  order by name
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:10:59 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 221  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:11:52 ## Exception ## Table 'kwtcmri2.mst_site_owners' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_site_owners' doesn't exist
select id, name from mst_site_owners where ifnull(inactive, 0) = 0  order by name
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:11:53 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 221  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:12:07 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:13:28 ## Exception ## Table 'kwtcmri2.et_document_attachment' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_document_attachment' doesn't exist
 Select document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And  document_id = 28650  order by id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:13:31 ## Exception ## Table 'kwtcmri2.et_document_attachment' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_document_attachment' doesn't exist
 Select document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And  document_id = 28650  order by id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:13:35 ## Exception ## Table 'kwtcmri2.et_document_tank' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_document_tank' doesn't exist
Select t.*, mst_users.name as approved_by_name  from et_document_tank t  left outer join mst_users on mst_users.id = t.approved_by_id  where t.vtype = 101  And t.vid = 28650  order by t.id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:13:38 ## Exception ## Table 'kwtcmri2.et_document_attachment' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_document_attachment' doesn't exist
 Select document_id, id, description, file_name, url, updated_at, type, longitude, latitude, click_time  from et_document_attachment  where document_type = 101  And  document_id = 28650  order by id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:13:58 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:14:09 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 226  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:14:18 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 226  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:08 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 select count(*) as cnt  from mst_users u  where ifnull(assistance_required, 0) = 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:08 ## Exception ## Table 'kwtcmri2.et_notification' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_notification' doesn't exist
 select id, updated_at, notification_type, message  from et_notification  where to_user_id = 187 and ifnull(mark_read, 0) = 0  order by notification_type, id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:09 ## Exception ## Table 'kwtcmri2.et_request' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_request' doesn't exist
 select subcat.name as sub_category_name, count(*) as cnt  from et_request r  left outer join mst_req_description_type subcat on subcat.id = r.request_description_type_id  where r.date_logged >= '2015-04-01 00:00:01' and r.date_logged <= '2023-02-14 23:59:59'   group by subcat.name 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:09 ## Exception ## Table 'kwtcmri2.et_request' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_request' doesn't exist
 select subcat.name as sub_category_name,  sum(case when ifnull(r.status_pk, 0) Not in (7, 9) then 1 else 0 end) as cntOpen,  sum(case when ifnull(r.status_pk, 0) in (7, 9) then 1 else 0 end) as cntClosed  from et_request r  left outer join mst_req_description_type subcat on subcat.id = r.request_description_type_id  where r.date_logged >= '2015-04-01 00:00:01' and r.date_logged <= '2023-02-14 23:59:59'   group by subcat.name 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:09 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
 select mst_sub_departments.name as subdepartment_name, count(*) as cnt  from et_work_order wo  left outer join mst_sub_departments on mst_sub_departments.id = wo.Sub_Department_PK  where ifnull(wo.wo_status_pk, 0) in (8)   and wo.Date_Created >= '2015-04-01 00:00:01' and wo.Date_Created <= '2023-02-14 23:59:59'  group by mst_sub_departments.name 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:09 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
 select mst_wo_category.name as category_name, count(*) as cnt  from et_work_order wo  left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk  where ifnull(wo.wo_status_pk, 0) not in (8, 11)   group by mst_wo_category.name 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:09 ## Exception ## Table 'kwtcmri2.et_request' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_request' doesn't exist
select mst_site_logical.name as site_name, count(*) as cnt  from et_request req  left outer join mst_site_logical on mst_site_logical.id = req.site_l_pk  where req.date_logged >= '2015-04-01 00:00:01' and req.date_logged <= '2023-02-14 23:59:59'  group by mst_site_logical.name  order by cnt desc  limit 10
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:09 ## Exception ## Table 'kwtcmri2.et_survey' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_survey' doesn't exist
select mst_site_logical.name as site_name, count(*) as cnt  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  where s.date_created >= '2015-04-01 00:00:01' and s.date_created <= '2023-02-14 23:59:59'  group by mst_site_logical.name  order by cnt desc  limit 10
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:18 ## Exception ## Table 'kwtcmri2.action_log' doesn't exist ## DataAccess.SetData ##  ## Exception in query: Save_ActionLog
Table 'kwtcmri2.action_log' doesn't exist
 INSERT INTO action_log(updated_at, user_PK, document_id, document_type, action_time, action_type, action_name, error_code, description, ip_address, client_type)  VALUES('2023-02-14 13:16:18', 187, 0, 0, '2023-02-14 13:16:18', 9, 'Logout', '', 'reshmi Logout', '172.16.2.42', 'Web') 
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
14-02-2023 01:16:20 ## Exception ## Table 'kwtcmri2.et_request' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_request' doesn't exist
 select r.*, mst_site_physical.name as site_p_name, mst_site_logical.name as site_l_name, mst_req_types.name as request_type_name, mst_req_category.name as category_name, mst_req_organization.name as organization_name,  mst_req_priority.name as priority_name, mst_req_severity.name as severity_name, mst_site_owners.name as owner_name, (Case IFNULL(r.status_pk,0)  when 1 then 'Logged'  when 2 then 'Acknowledged'  when 3 then 'Canceled'  when 4 then 'Pending'  when 5 then 'In_Progress'  when 6 then 'Resolved'  when 7 then 'Closed'  when 8 then 'Assigned'  when 9 then 'Rejected'  when 10 then 'Arrived'  when 11 then 'Requested'  when 12 then 'InTransit'  when 13 then 'Approved'  end) as status_name, mst_projects.name as project_name, mst_req_description_type.name as request_description_type_name,  mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name  from et_request r  left outer join mst_site_physical on mst_site_physical.id = r.site_p_pk  left outer join mst_site_logical on mst_site_logical.id = r.site_l_pk  left outer join mst_req_types on mst_req_types.id = r.request_type_pk  left outer join mst_req_category on mst_req_category.id = r.category_pk  left outer join mst_req_organization on mst_req_organization.id = r.organization_pk  left outer join mst_req_priority on mst_req_priority.id = r.priority_pk  left outer join mst_req_severity on mst_req_severity.id = r.severity_pk  left outer join mst_site_owners on mst_site_owners.id = r.owner_pk  left outer join mst_projects on mst_projects.id = r.project_pk  left outer join mst_req_description_type on mst_req_description_type.id = r.request_description_type_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = r.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = r.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = r.rejection_reason_id  where r.id in (select vid from et_document_users where vtype = 103 and user_id = 226)  And ifnull(r.status_pk,0) not in (7, 9) order by r.id desc 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:24 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 226  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:33 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 226  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:36 ## Exception ## Table 'kwtcmri2.et_survey' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_survey' doesn't exist
select s.*, mst_site_logical.name as site_l_name, mst_users.name as user_name, mst_survey.description as survey_template_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name,  (select count(*) from et_document_notes where vtype = 107 and vid = s.id) as notes_count,  (select count(*) from et_document_attachment where document_type = 107 and document_id = s.id) as attachment_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 1) as consumable_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 2) as part_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 3) as tools_count,  (select count(*) from et_document_stc where vtype = 107 and vid = s.id and IMM_Type_FK = 4) as item_count,  (select count(*) from et_document_asset where vtype = 107 and vid = s.id) as asset_count,  (select count(*) from et_document_tasks where vtype = 107 and vid = s.id) as task_count,  (select count(*) from et_survey_values where document_id =s.vid and document_type=s.vtype and survey_template_id=s.survey_template_id) as ValueCount,  1 as survey_count,  (select count(*) from et_document_users where vtype = 107 and vid = s.id) as user_count,  mst_approved_users.name as approved_by_name, (case when IFNULL(s.status,0) in (5, 11, 10) then 'Yes' else 'No' End) as Active  from et_survey s  left outer join mst_site_logical on mst_site_logical.id = s.site_l_pk  left outer join mst_users on mst_users.id = s.user_id  left outer join mst_survey on mst_survey.id = s.survey_template_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = s.cancellation_reason_id  left outer join mst_completion_code on mst_completion_code.id = s.completion_code_id  left outer join mst_rejection_reason on mst_rejection_reason.id = s.rejection_reason_id  left outer join mst_users mst_approved_users on mst_approved_users.id = s.approved_by_id  where 1=1  And s.vtype = 107 and s.user_id = 226 And ifnull(s.status, 0) <> 7 Order by s.id desc
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:37 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 226  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:16:38 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
select wo.*, et_request.description as Request_Name, mst_company.name as Company_Name, mst_departments.name as Department_Name, mst_sub_departments.name as Sub_Department_Name,  mst_site_physical.name as Site_Name, mst_site_logical.name as Site_L_Name, mst_projects.name as Project_Name, mst_project_deliverables.name as PD_Name, mst_business_categories.name as Business_Category_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 workorder_status_name,  mst_wo_category.name as wo_category_name, mst_cancellation_reason.name as cancellation_reason_name, mst_rejection_reason.name as rejection_reason_name, mst_completion_code.name as completion_code_name  from et_work_order wo  left outer join et_request on et_request.id = wo.Request_PK  left outer join mst_company on mst_company.id = wo.Company_PK  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_site_logical on mst_site_logical.id = wo.Site_L_PK  left outer join mst_projects on mst_projects.id = wo.Project_PK  left outer join mst_project_deliverables on mst_project_deliverables.id = wo.PD_PK  left outer join mst_business_categories on mst_business_categories.id = wo.Business_Category_PK   left outer join mst_wo_category on mst_wo_category.id = wo.wo_category_pk   left outer join et_document_users on (et_document_users.vtype = 101 and et_document_users.vid = wo.id)  left outer join mst_users on mst_users.id = et_document_users.User_id  left outer join mst_cancellation_reason on mst_cancellation_reason.id = wo.cancellation_reason_id  left outer join mst_rejection_reason on mst_rejection_reason.id = wo.rejection_reason_id  left outer join mst_completion_code on mst_completion_code.id = wo.completion_code_id  where wo.vtype = 101 and ifnull(wo.wo_status_pk,0) not in (8, 11)   And mst_users.id = 226  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:18:40 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:18:47 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:18:51 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:18:53 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:18:58 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:19:02 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
Select * from con_general
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:20:16 ## Exception ## Table 'kwtcmri2.et_work_order' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.et_work_order' doesn't exist
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: NULL 
 Source: MySql.Data
14-02-2023 01:22:08 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:08 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'hrajan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:09 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'hrajan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:09 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:11 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:11 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'hrajan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:46 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'kkhan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:46 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:48 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'kkhan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:22:48 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:23:03 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'kkhan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:23:03 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:23:05 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'kkhan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:23:05 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:24:28 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'hrajan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:24:28 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:34:35 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
14-02-2023 01:34:35 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:35 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
14-02-2023 01:34:35 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:35 ## Error ##  ## DataAccess.GetData ##  ## LoginUserInfo
Unable to connect to data base
14-02-2023 01:34:35 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:35 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
14-02-2023 01:34:35 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:36 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
14-02-2023 01:34:36 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:36 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:36 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
14-02-2023 01:34:36 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:36 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
14-02-2023 01:34:37 ## Error ##  ## DataAccess.GetData ##  ## LoginUserInfo
Unable to connect to data base
14-02-2023 01:34:37 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:42 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:42 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
14-02-2023 01:34:43 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:43 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
14-02-2023 01:34:44 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:44 ## Error ##  ## DataAccess.GetData ##  ## LoginUserInfo
Unable to connect to data base
14-02-2023 01:34:50 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:50 ## Error ##  ## DataAccess.GetData ##  ## LoginUserInfo
Unable to connect to data base
14-02-2023 01:34:56 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:56 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
14-02-2023 01:34:57 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:34:57 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
14-02-2023 01:35:03 ## Error ##  ## DataAccess.GetData ##  ## GetEncryptionKey
Unable to connect to data base
14-02-2023 01:35:03 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:35:04 ## Exception ## Unable to connect to any of the specified MySQL hosts. ## DataAccess.GetConnection ##  ## 
14-02-2023 01:35:04 ## Error ##  ## DataAccess.GetData ##  ## LoginUser
Unable to connect to data base
14-02-2023 01:35:28 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:35:28 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:36:24 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 216 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:36:46 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 216 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:36:57 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 216 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:37:30 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 225 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:37:32 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 225 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:37:39 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'kkhan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:37:39 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:37:42 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'kkhan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:37:42 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:42 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:42 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:46 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:46 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:47 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:47 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:48 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:48 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:52 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:40:52 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:41:41 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 192 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:41:43 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 192 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:41:47 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 192 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:41:59 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Gmathai' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:41:59 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:41:59 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 225 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:03 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:03 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Gmathai' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:15 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 203 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:18 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 203 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:23 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 203 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:50 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'kkhan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:50 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:59 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'hrajan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:42:59 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:44:20 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:44:20 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Azahid' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:24 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:24 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:29 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:29 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:32 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:32 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:39 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:39 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:40 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:40 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:41 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:41 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:42 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:42 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:43 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:46:43 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:47:53 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 203 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:12 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 216 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:33 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Ssamuel' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:33 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:38 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Ssamuel' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:38 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:45 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Ssamuel' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:45 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:47 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:51:47 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Ssamuel' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 01:59:17 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 225 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:05:55 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:05:55 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'hrajan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:08:51 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 226 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:08:57 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'gsahota' and websecurityusers.Password = 'hWJoVSC1lI4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:08:57 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:09:01 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:09:01 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'gsahota' and websecurityusers.Password = 'hWJoVSC1lI4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:09:02 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
Select company, department_id, subdepartment_id, designation_id, name, concat(ifnull(cc_mobile_no_1,''), ifnull(mobile_no_1,'')) as mobile_no_1, hayat_email, user_group_id  from mst_users  where id = 203 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:09:03 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:09:03 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'gsahota' and websecurityusers.Password = 'hWJoVSC1lI4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:13:20 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Gmathai' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:13:20 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:16:50 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'bsivan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:16:50 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:18:38 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Vsreedharan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:18:38 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:18:43 ## Exception ## Table 'kwtcmri2.con_general' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.con_general' doesn't exist
 select config_value as EncryptionKey  from con_general  where config_type = 4 limit 1 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:18:43 ## Exception ## Table 'kwtcmri2.mst_users' doesn't exist ## DataAccess.GetData ##  ## Table 'kwtcmri2.mst_users' doesn't exist
 Select mst_users.id  from mst_users  left outer join websecurityusers on websecurityusers.userid = mst_users.Userid  where ifnull(mst_users.inactive, 0) = 0  and mst_users.Userid = 'Vsreedharan' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
14-02-2023 02:21:43 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:21:52 ## Info ##  ## EmailSMSUtility.sendSMSUsingTwilio ##  ## SMS Using Twilio Exception The 'To' number 98766082 is not a valid phone number.
14-02-2023 02:21:57 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:00 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:47 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:50 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:50 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:51 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:51 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:51 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:22:52 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:24:50 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:24:50 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:24:54 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:24:55 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:25:20 ## Exception ## Object reference not set to an instance of an object. ## APIExtendedData.GetExtendedData ##  ## Object reference not set to an instance of an object.
14-02-2023 02:36:31 ## 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-02-2023 02:36:31 ## Error ##  ## DataAccess.GetData ##  ## GetPendingNotification
Unable to connect to data base
14-02-2023 02:36:31 ## 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-02-2023 02:36:31 ## Error ##  ## DataAccess.GetData ##  ## Get_WorkOrderForUser
Unable to connect to data base
14-02-2023 02:37:24 ## Error ##  ## DataAccess.GetData ##  ## Rpt_DashboardWidget_Request_L2WiseCount
Unable to connect to data base
14-02-2023 02:37:24 ## 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-02-2023 02:37: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 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
14-02-2023 02:37: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 date_format(Date_Created, '%m-%Y') as month, count(*) as TotalCreated,  (select count(*) from et_work_order wo_close where wo_close.vtype = 101 and wo_close.date_closed is not null and month(wo_close.date_closed) = month(et_work_order.Date_Created) and year(wo_close.date_closed) = year(et_work_order.Date_Created)) as TotalClosed  from et_work_order  where vtype = 101 and et_work_order.id in (Select vid From et_document_users where vtype = 101 and User_id = 216)  And Date_Created >= date_add(Now(), interval - 6 month)  Group By date_format(Date_Created, '%m-%Y') 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
14-02-2023 02:37: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 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
14-02-2023 02:39: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 id, updated_at, notification_type, message  from et_notification  where to_user_id = 215 and ifnull(mark_read, 0) = 0  order by notification_type, 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-02-2023 05:23:46 ## 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.name 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(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (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 <= '2023-02-14 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
14-02-2023 05:26:19 ## 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.name 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(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (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 <= '2023-02-14 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
14-02-2023 05:34:16 ## 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.name 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(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (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 <= '2023-02-14 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
14-02-2023 08:21: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 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.name 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(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (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 <= '2023-02-14 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
14-02-2023 08:41:08 ## 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.name 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(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (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 <= '2023-02-14 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
14-02-2023 08:44: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 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.name 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(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (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 <= '2023-02-14 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
14-02-2023 08:46: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 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.name 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(size_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_size,  (select group_concat(buffer_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_buffer,  (select group_concat(after_filled_volume separator ';<br/>') from et_document_tank where vid = w.id) as tank_after_filled,  (select group_concat(filled_qty separator ';<br/>') from et_document_tank where vid = w.id) as tank_filled,  (select group_concat(name separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_name,  (select group_concat(dg_capacity separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_capacity,  (select group_concat(canopy separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_canopy,  (select group_concat(tag separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_tag,  (select group_concat(running_hours separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_running_hours,  (select group_concat(remark separator ';<br/>') from et_document_dgpm where vid = w.id) as dgpm_remark,  (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 >= '2022-03-01 00:00:01' and w.Date_Created <= '2023-02-14 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data