-----------Exception Details on 03/07/2024 2:48:55 pm----------------- ------------------------------------------------------------------------------------- {"StatusCode":500,"Message":"Internal Server Error.","Error":"MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect number of arguments for PROCEDURE ezhubspot_main.Get_TimeOff_PendingRequestToManagement; expected 13, got 12\r\n ---\u003E MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect number of arguments for PROCEDURE ezhubspot_main.Get_TimeOff_PendingRequestToManagement; expected 13, got 12\r\n at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in C:\\projects\\mysqlconnector\\src\\MySqlConnector\\Core\\ResultSet.cs:line 49\r\n at MySql.Data.MySqlClient.MySqlDataReader.ActivateResultSet() in C:\\projects\\mysqlconnector\\src\\MySqlConnector\\MySql.Data.MySqlClient\\MySqlDataReader.cs:line 130\r\n at MySql.Data.MySqlClient.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary\u00602 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\\projects\\mysqlconnector\\src\\MySqlConnector\\MySql.Data.MySqlClient\\MySqlDataReader.cs:line 391\r\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList\u00601 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in C:\\projects\\mysqlconnector\\src\\MySqlConnector\\Core\\CommandExecutor.cs:line 62\r\n at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\mysqlconnector\\src\\MySqlConnector\\MySql.Data.MySqlClient\\MySqlCommand.cs:line 217\r\n at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)\r\n at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1051\r\n at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)\u002BMoveNext() in /_/Dapper/SqlMapper.cs:line 1079\r\n at System.Collections.Generic.List\u00601..ctor(IEnumerable\u00601 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable\u00601 source)\r\n at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable\u00601 commandTimeout, Nullable\u00601 commandType) in /_/Dapper/SqlMapper.cs:line 721\r\n at WebApi.DataAccess.Data.Repository.SP_Call.ReturnList[T](String procedureName, DynamicParameters param) in D:\\Sohail\\SignUp\\EzHubSpot-v1-issue\\WebApi.DataAccess\\Data\\Repository\\SP_Call.cs:line 45\r\n at WebApi.DataAccess.Data.Repository.TimeOffTRepository.ShowPendingRequestToUpperLevelManagement(Int32 pageNo, Int32 pageSize, String searchQuery, String type, Nullable\u00601 _date_from, Nullable\u00601 _date_to, Int32 activeUser, String _location, String _departments, String _users, String _user_status, String status, String policy_compliance) in D:\\Sohail\\SignUp\\EzHubSpot-v1-issue\\WebApi.DataAccess\\Data\\Repository\\TimeOffTRepository.cs:line 179\r\n at WebApi.Areas.TimeManagement.Controllers.TimeOffController.ShowPendingRequestToUpperLevelManagement(Int32 userId, String status, Int32 pageNo, Int32 pageSize, String type, String searchQuery, Nullable\u00601 _date_from, Nullable\u00601 _date_to, String _location, String _departments, String _users, String _user_status, String policy_compliance) in D:\\Sohail\\SignUp\\EzHubSpot-v1-issue\\WebApi\\Areas\\TimeManagement\\Controllers\\TimeOffController.cs:line 75\r\n at lambda_method(Closure , Object , Object[] )\r\n at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State\u0026 next, Scope\u0026 scope, Object\u0026 state, Boolean\u0026 isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State\u0026 next, Scope\u0026 scope, Object\u0026 state, Boolean\u0026 isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.\u003CInvokeFilterPipelineAsync\u003Eg__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.\u003CInvokeAsync\u003Eg__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)\r\n at Microsoft.AspNetCore.Routing.EndpointMiddleware.\u003CInvoke\u003Eg__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)\r\n at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)\r\n at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)\r\n at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.\u003CInvoke\u003Eg__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)"} --------------------------------*End*------------------------------------------