24-02-2023 01:28:34 ## 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) 24-02-2023 01:28:35 ## 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 = 226 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) 24-02-2023 01:28:40 ## 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 = 226 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) 24-02-2023 01:28:41 ## 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) 24-02-2023 01:28:54 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. select r.*, mst_site_physical.name as site_p_name, mst_site_logical.name as site_l_name, mst_req_types.name as request_type_name, mst_req_category.name as category_name, mst_req_organization.name as organization_name, mst_req_priority.name as priority_name, mst_req_severity.name as severity_name, mst_site_owners.name as owner_name, (Case IFNULL(r.status_pk,0) when 1 then 'Logged' when 2 then 'Acknowledged' when 3 then 'Canceled' when 4 then 'Pending' when 5 then 'In_Progress' when 6 then 'Resolved' when 7 then 'Closed' when 8 then 'Assigned' when 9 then 'Rejected' when 10 then 'Arrived' when 11 then 'Requested' when 12 then 'InTransit' when 13 then 'Approved' end) as status_name, mst_projects.name as project_name, mst_req_description_type.name as request_description_type_name, mst_cancellation_reason.name as cancellation_reason_name, mst_completion_code.name as completion_code_name, mst_rejection_reason.name as rejection_reason_name from et_request r left outer join mst_site_physical on mst_site_physical.id = r.site_p_pk left outer join mst_site_logical on mst_site_logical.id = r.site_l_pk left outer join mst_req_types on mst_req_types.id = r.request_type_pk left outer join mst_req_category on mst_req_category.id = r.category_pk left outer join mst_req_organization on mst_req_organization.id = r.organization_pk left outer join mst_req_priority on mst_req_priority.id = r.priority_pk left outer join mst_req_severity on mst_req_severity.id = r.severity_pk left outer join mst_site_owners on mst_site_owners.id = r.owner_pk left outer join mst_projects on mst_projects.id = r.project_pk left outer join mst_req_description_type on mst_req_description_type.id = r.request_description_type_id left outer join mst_cancellation_reason on mst_cancellation_reason.id = r.cancellation_reason_id left outer join mst_completion_code on mst_completion_code.id = r.completion_code_id left outer join mst_rejection_reason on mst_rejection_reason.id = r.rejection_reason_id where r.id in (select vid from et_document_users where vtype = 103 and user_id = 226) And ifnull(r.status_pk,0) not in (7, 9) order by r.id desc Inner Exception: NULL Source: MySql.Data 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) 24-02-2023 01:29:04 ## 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 = 226 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) 24-02-2023 01:30:52 ## 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) 24-02-2023 01:30: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 = 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) 24-02-2023 01:33:48 ## 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) 24-02-2023 01:45:15 ## 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 = 193 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) 24-02-2023 01:45:20 ## 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 = 193 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) 24-02-2023 01:47: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 = 226 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) 24-02-2023 01:48:05 ## 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 = 226 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) 24-02-2023 01:52:46 ## 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 = 208 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) 24-02-2023 01:52:52 ## 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 = 208 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) 24-02-2023 01:52: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 = 208 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) 24-02-2023 01:53:01 ## 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 = 208 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) 24-02-2023 01:53:02 ## 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 = 208 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) 24-02-2023 01:53:23 ## 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 = 208 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) 24-02-2023 02:16:27 ## 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) 24-02-2023 02:16:48 ## 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) 24-02-2023 02:17:43 ## Exception ## Packets larger than max_allowed_packet are not allowed. ## DataAccess.GetData ## ## Packets larger than max_allowed_packet are not allowed. (select distinct 'mst_site_physical|Site_Type' as type, Site_Type as name from mst_site_physical where ifnull(Site_Type,'') <> '') union all (select distinct 'mst_site_physical|Site_Category' as type, Site_Category as name from mst_site_physical where ifnull(Site_Category, '') <> '') union all (select distinct 'mst_site_physical|Region' as type, Region as name from mst_site_physical where ifnull(Region, '') <> '') union all (select distinct 'mst_site_physical|Area' as type, Area as name from mst_site_physical where ifnull(Area, '') <> '') union all (select distinct 'mst_site_physical|Road_access' as type, Road_access as name from mst_site_physical where ifnull(Road_access, '') <> '') union all (select distinct 'mst_site_physical|Access_Procedure' as type, Access_Procedure as name from mst_site_physical where ifnull(Access_Procedure, '') <> '') union all (select distinct 'mst_site_physical|Notes' as type, Notes as name from mst_site_physical where ifnull(Notes, '') <> '') union all (select distinct 'mst_site_logical|Gen2' as type, Gen2 as name from mst_site_logical where ifnull(Gen2, '') <> '') union all (select distinct 'mst_site_logical|Gen3' as type, Gen3 as name from mst_site_logical where ifnull(Gen3, '') <> '') union all (select distinct 'mst_site_logical|LTE' as type, LTE as name from mst_site_logical where ifnull(LTE, '') <> '') union all (select distinct 'mst_site_logical|DPAS_Code' as type, DPAS_Code as name from mst_site_logical where ifnull(DPAS_Code, '') <> '') union all (select distinct 'mst_site_logical|Sub_Area' as type, Sub_Area as name from mst_site_logical where ifnull(Sub_Area, '') <> '') union all (select distinct 'mst_site_logical|Building_Name' as type, Building_Name as name from mst_site_logical where ifnull(Building_Name, '') <> '') union all (select distinct 'mst_site_logical|Floor_Number' as type, Floor_Number as name from mst_site_logical where ifnull(Floor_Number, '') <> '') union all (select distinct 'mst_site_logical|Room_Type' as type, Room_Type as name from mst_site_logical where ifnull(Room_Type, '') <> '') union all (select distinct 'mst_site_logical|Site_Boundary' as type, Site_Boundary as name from mst_site_logical where ifnull(Site_Boundary, '') <> '') union all (select distinct 'mst_site_logical|Shared' as type, Shared as name from mst_site_logical where ifnull(Shared, '') <> '') union all (select distinct 'mst_site_logical|L_Access_Procedure' as type, L_Access_Procedure as name from mst_site_logical where ifnull(L_Access_Procedure, '') <> '') union all (select distinct 'mst_site_logical|Site_Priority' as type, Site_Priority as name from mst_site_logical where ifnull(Site_Priority, '') <> '') union all (select distinct 'mst_site_logical|Entry_Key' as type, Entry_Key as name from mst_site_logical where ifnull(Entry_Key, '') <> '') union all (select distinct 'mst_site_logical|EKMS' as type, EKMS as name from mst_site_logical where ifnull(EKMS, '') <> '') union all (select distinct 'mst_site_logical|HONEYWELL' as type, HONEYWELL as name from mst_site_logical where ifnull(HONEYWELL, '') <> '') union all (select distinct 'mst_site_logical|MANUAL_KEY' as type, MANUAL_KEY as name from mst_site_logical where ifnull(MANUAL_KEY, '') <> '') union all (select distinct 'mst_site_logical|ACCESS_CARD' as type, ACCESS_CARD as name from mst_site_logical where ifnull(ACCESS_CARD, '') <> '') union all (select distinct 'mst_site_logical|PRIORITY' as type, PRIORITY as name from mst_site_logical where ifnull(PRIORITY, '') <> '') union all (select distinct 'mst_site_logical|Cabinet_Location' as type, Cabinet_Location as name from mst_site_logical where ifnull(Cabinet_Location, '') <> '') union all (select distinct 'mst_site_logical|Power_Source' as type, Power_Source as name from mst_site_logical where ifnull(Power_Source, '') <> '') union all (select distinct 'mst_site_logical|Meter_Number' as type, Meter_Number as name from mst_site_logical where ifnull(Meter_Number, '') <> '') union all (select distinct 'mst_site_logical|Counter' as type, Counter as name from mst_site_logical where ifnull(Counter, '') <> '') union all (select distinct 'mst_site_logical|Room_Maintenance_Scope' as type, Room_Maintenance_Scope as name from mst_site_logical where ifnull(Room_Maintenance_Scope, '') <> '') union all (select distinct 'mst_site_logical|GPON_Migration_Planned' as type, GPON_Migration_Planned as name from mst_site_logical where ifnull(GPON_Migration_Planned, '') <> '') union all (select distinct 'mst_site_logical|PERMIT' as type, PERMIT as name from mst_site_logical where ifnull(PERMIT, '') <> '') union all (select distinct 'mst_site_logical|SECURITY' as type, SECURITY as name from mst_site_logical where ifnull(SECURITY, '') <> '') union all (select distinct 'mst_site_logical|ROOM_DIMENSION' as type, ROOM_DIMENSION as name from mst_site_logical where ifnull(ROOM_DIMENSION, '') <> '') union all (select distinct 'mst_site_logical|RAISED_FLOOR' as type, RAISED_FLOOR as name from mst_site_logical where ifnull(RAISED_FLOOR, '') <> '') union all (select distinct 'mst_site_logical|STANDBY_OULET' as type, STANDBY_OULET as name from mst_site_logical where ifnull(STANDBY_OULET, '') <> '') union all (select distinct 'mst_site_logical|CONTACT_DETAILS' as type, CONTACT_DETAILS as name from mst_site_logical where ifnull(CONTACT_DETAILS, '') <> '') union all (select distinct 'mst_site_logical|PROJECT_TYPE' as type, PROJECT_TYPE as name from mst_site_logical where ifnull(PROJECT_TYPE, '') <> '') union all (select distinct 'mst_site_logical|REMARKS_CANCELLED_SITES' as type, REMARKS_CANCELLED_SITES as name from mst_site_logical where ifnull(REMARKS_CANCELLED_SITES, '') <> '') union all (select distinct 'mst_site_logical|Store_Manager' as type, Store_Manager as name from mst_site_logical where ifnull(Store_Manager, '') <> '') union all (select distinct 'mst_site_logical|Store_Timing' as type, Store_Timing as name from mst_site_logical where ifnull(Store_Timing, '') <> '') union all (select distinct 'mst_site_logical|FM_Company_Name' as type, FM_Company_Name as name from mst_site_logical where ifnull(FM_Company_Name, '') <> '') union all (select distinct 'mst_site_logical|FM_Company_Contact' as type, FM_Company_Contact as name from mst_site_logical where ifnull(FM_Company_Contact, '') <> '') union all (select distinct 'mst_site_logical|Remarks' as type, Remarks as name from mst_site_logical where ifnull(Remarks, '') <> '') union all (select distinct 'mst_site_logical|moc_id' as type, moc_id as name from mst_site_logical where ifnull(moc_id, '') <> '') union all (select distinct 'et_work_order|instructions' as type, instructions as name from et_work_order where ifnull(instructions, '') <> '') union all (select distinct 'et_work_order|description' as type, description as name from et_work_order where ifnull(description, '') <> '') union all (select distinct 'et_work_order|tag' as type, tag as name from et_work_order where ifnull(tag, '') <> '') union all (select distinct 'et_work_order|template_name' as type, template_name as name from et_work_order where ifnull(template_name, '') <> '') union all (select distinct 'mst_inv_warehouses|Inv_Warehouse_Address' as type, Inv_Warehouse_Address as name from mst_inv_warehouses where ifnull(Inv_Warehouse_Address, '') <> '') union all (select distinct 'mst_inv_warehouses|Inv_WH_Type' as type, Inv_WH_Type as name from mst_inv_warehouses where ifnull(Inv_WH_Type, '') <> '') union all (select distinct 'mst_inv_warehouses|Vendor_Name' as type, Vendor_Name as name from mst_inv_warehouses where ifnull(Vendor_Name, '') <> '') union all (select distinct 'mst_inv_warehouses|Booking_Type' as type, Booking_Type as name from mst_inv_warehouses where ifnull(Booking_Type, '') <> '') union all (select distinct 'mst_inv_warehouses|Fleet_no' as type, Fleet_no as name from mst_inv_warehouses where ifnull(Fleet_no, '') <> '') union all (select distinct 'mst_inv_warehouses|Customer' as type, Customer as name from mst_inv_warehouses where ifnull(Customer, '') <> '') union all (select distinct 'mst_inv_warehouses|Project' as type, Project as name from mst_inv_warehouses where ifnull(Project, '') <> '') union all (select distinct 'mst_inv_warehouses|Area' as type, Area as name from mst_inv_warehouses where ifnull(Area, '') <> '') union all (select distinct 'mst_inv_warehouses|Department' as type, Department as name from mst_inv_warehouses where ifnull(Department, '') <> '') union all (select distinct 'mst_inv_warehouses|Vehicle_Make' as type, Vehicle_Make as name from mst_inv_warehouses where ifnull(Vehicle_Make, '') <> '') union all (select distinct 'mst_inv_warehouses|Vehicle_Model' as type, Vehicle_Model as name from mst_inv_warehouses where ifnull(Vehicle_Model, '') <> '') union all (select distinct 'mst_inv_warehouses|Vehicle_Colour' as type, Vehicle_Colour as name from mst_inv_warehouses where ifnull(Vehicle_Colour, '') <> '') union all (select distinct 'mst_inv_warehouses|Vehicle_Description' as type, Vehicle_Description as name from mst_inv_warehouses where ifnull(Vehicle_Description, '') <> '') union all (select distinct 'mst_inv_warehouses|Vehicle_Type' as type, Vehicle_Type as name from mst_inv_warehouses where ifnull(Vehicle_Type, '') <> '') union all (select distinct 'et_request|description' as type, description as name from et_request where ifnull(description, '') <> '') order by type, name 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) 24-02-2023 02:45:28 ## 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 = 208 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) 24-02-2023 02:49:40 ## 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 = 226 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) 24-02-2023 02:50:27 ## 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 = 226 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) 24-02-2023 02:51:36 ## 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) 24-02-2023 03:41:40 ## 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 = 208 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) 24-02-2023 03:41:51 ## 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 = 208 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)