15-02-2023 05:20: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
15-02-2023 05:20: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 = 'rkhaa' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 05:20:56 ## 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
15-02-2023 05:20:56 ## 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 = 'rkhaa' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 05:21: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 = 'rkhaa' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 05:21: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
15-02-2023 05:21:06 ## 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
15-02-2023 05:21:07 ## 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 = 'rkhaa' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 05:21: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 = 'rkhaa' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 05:21: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
15-02-2023 05:22:27 ## 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
15-02-2023 05:22:34 ## 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
15-02-2023 05:22:38 ## 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
15-02-2023 05:22:45 ## 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
15-02-2023 05:22:54 ## 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
15-02-2023 05:23: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
15-02-2023 05:26:57 ## 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
15-02-2023 05:28:03 ## 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
15-02-2023 06:16:49 ## 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
15-02-2023 06:41: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 = 'mmukadam' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 06:41: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
15-02-2023 06:41:25 ## 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 = 'mmukadam' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 06:41:25 ## 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
15-02-2023 06:41: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 = 'mmukadam' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 06:41: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
15-02-2023 06:47:36 ## 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 = 'Noc' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 06:47:36 ## 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
15-02-2023 06:55:06 ## 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
15-02-2023 06:55:06 ## 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 = 'Noc' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:16: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 = 'Noc' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:16: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
15-02-2023 07:16:10 ## 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
15-02-2023 07:16:10 ## 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 = 'Noc' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:19:54 ## 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
15-02-2023 07:19:54 ## 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 = 'Noc' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:20:31 ## 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
15-02-2023 07:20:31 ## 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
15-02-2023 07:20: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 = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:20: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
15-02-2023 07:20: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
15-02-2023 07:20: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 = 'bsharma' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:20:44 ## 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
15-02-2023 07:20:44 ## 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
15-02-2023 07:20: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
15-02-2023 07:20: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
15-02-2023 07:20:58 ## 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
15-02-2023 07:20:58 ## 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
15-02-2023 07:21:04 ## 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
15-02-2023 07:21:04 ## 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
15-02-2023 07:41: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
15-02-2023 07:41: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
15-02-2023 07:44:01 ## 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
15-02-2023 07:44:06 ## 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
15-02-2023 07:44:12 ## 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
15-02-2023 07:45:10 ## 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 = 'Noc' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:45:10 ## 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
15-02-2023 07:50: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.9133719, 29.3007957, 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 = 27936
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:50:50 ## 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 = 203  order by wo.ID desc  limit 50 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 07:53:30 ## 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
15-02-2023 07:53:30 ## 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
15-02-2023 08:01:11 ## 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
15-02-2023 08:06:44 ## 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
15-02-2023 08:06:44 ## 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 = 'Noc' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:07: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 = 'gsahota' and websecurityusers.Password = 'hWJoVSC1lI4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:07: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
15-02-2023 08:07: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 = 'gsahota' and websecurityusers.Password = 'hWJoVSC1lI4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:07: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
15-02-2023 08:07:21 ## 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
15-02-2023 08:07:21 ## 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
15-02-2023 08:07:22 ## 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
15-02-2023 08:07:22 ## 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
15-02-2023 08:07:58 ## 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
15-02-2023 08:07:58 ## 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
15-02-2023 08:08: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
15-02-2023 08:08: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
15-02-2023 08:08: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 = 'gsahota' and websecurityusers.Password = 'hWJoVSC1lI4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:08: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
15-02-2023 08:08: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
15-02-2023 08:08: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 = 'gsahota' and websecurityusers.Password = 'hWJoVSC1lI4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:17:07 ## 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 = 'reshmi' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:17:07 ## 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
15-02-2023 08:19:49 ## 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 = 'reshmi' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:19:49 ## 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
15-02-2023 08:19: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 = 'reshmi' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:19: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
15-02-2023 08:21:12 ## 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 = 'reshmi' and websecurityusers.Password = 'TTB8ooqiXL4=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:21:12 ## 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
15-02-2023 08:22:42 ## 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-15 08:22:42', 102, 0, 0, '2023-02-15 08:22:42', 9, 'Logout', '', 'avarkey Logout', '180.151.28.59', 'Web') 
 Inner Exception: NULL 
 Source: MySql.Data
 Platform: Web
15-02-2023 08: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 = 'avarkey' and websecurityusers.Password = 'UnKn3BR/29A=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08: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
15-02-2023 08:24:12 ## 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 = 'avarkey' and websecurityusers.Password = 'UnKn3BR/29A=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:24:12 ## 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
15-02-2023 08:24:15 ## 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 = 'avarkey' and websecurityusers.Password = 'UnKn3BR/29A=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:24:15 ## 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
15-02-2023 08:24:19 ## 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 = 'avarkey' and websecurityusers.Password = 'UnKn3BR/29A=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:24:19 ## 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
15-02-2023 08:24:49 ## 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 = 'avarkey' and websecurityusers.Password = 'UnKn3BR/29A=' 
 Inner Exception: NULL 
 Source: MySql.Data
15-02-2023 08:24:49 ## 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
15-02-2023 08:48:06 ## 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-15 23:59:59')  as A  order by vno 
 Inner Exception: Timeout in IO operation
 Source: MySql.Data
15-02-2023 09:54:11 ## Info ##  ## EmailSMSUtility.sendSMSUsingTwilio ##  ## SMS Using Twilio Exception The 'To' number 69601074 is not a valid phone number.