26-02-2023 11:14:31 ## Exception ## The process cannot access the file 'E:\KWTCMRI2\CMRIApp\Attachments\EtWorkOrder\29473\85038_Clickedfile.png' because it is being used by another process. ## FCMRIDataService.SaveUpdate_DocumentAttachment ## ## The process cannot access the file 'E:\KWTCMRI2\CMRIApp\Attachments\EtWorkOrder\29473\85038_Clickedfile.png' because it is being used by another process. 26-02-2023 03:29:49 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:29:54 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:31:53 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 = 209 order by wo.ID desc limit 50 Inner Exception: NULL Source: MySql.Data Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:31:57 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 = 209 order by wo.ID desc limit 50 Inner Exception: NULL Source: MySql.Data Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:32:24 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 = 209 order by wo.ID desc limit 50 Inner Exception: NULL Source: MySql.Data Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:32:32 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 = 209 order by wo.ID desc limit 50 Inner Exception: NULL Source: MySql.Data Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:34:28 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:46:16 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 = 210 order by wo.ID desc limit 50 Inner Exception: NULL Source: MySql.Data Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters) 26-02-2023 03:46:21 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. 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 = 210 order by wo.ID desc limit 50 Inner Exception: NULL Source: MySql.Data Stack Trace: at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet) at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute) at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket) at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p) at MySql.Data.MySqlClient.Statement.ExecuteNext() at MySql.Data.MySqlClient.PreparableStatement.Execute() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType) at CMRI.DataAccess.GetData(APIExtendedData apiData, GetQuerySubType getQuerySubType, String& error, QueryParamML[] objParameters)