[15.03.2025 01:01:48.374 +00:00 INF] 0HNAVDOPB25VO:00000001 / called [15.03.2025 01:01:51.869 +00:00 INF] 0HNAVDOPB25VO:00000002 /favicon.ico called [15.03.2025 05:28:49.310 +00:00 INF] 0HNAVDOPB25VP:00000001 / called [15.03.2025 05:28:49.704 +00:00 INF] 0HNAVDOPB25VP:00000002 /Images/ called [15.03.2025 05:28:50.351 +00:00 INF] 0HNAVDOPB25VP:00000003 /invoices/ called [15.03.2025 05:28:50.775 +00:00 INF] 0HNAVDOPB25VP:00000004 /Logs/ called [15.03.2025 05:28:51.358 +00:00 INF] 0HNAVDOPB25VP:00000005 /Resources/ called [15.03.2025 11:40:11.715 +00:00 INF] 0HNAVDOPB25VQ:00000001 /api/SiteSetting/GetByNameAsync called [15.03.2025 11:40:11.805 +00:00 INF] 0HNAVDOPB25VR:00000001 /api/ProductCategory/GetHierarchy called [15.03.2025 11:40:12.078 +00:00 INF] 0HNAVDOPB25VR:00000002 /api/Order/GetAllByStatus called [15.03.2025 13:15:52.915 +00:00 INF] 0HNAVDOPB25VS:00000001 /api/ProductCategory/GetHierarchy called [15.03.2025 13:15:52.935 +00:00 INF] 0HNAVDOPB25VT:00000001 /api/SiteSetting/GetByNameAsync called [15.03.2025 13:15:53.198 +00:00 INF] 0HNAVDOPB25VT:00000002 /api/Order/GetAllByStatus called [15.03.2025 13:16:46.673 +00:00 INF] 0HNAVDOPB25VT:00000003 /api/SiteSetting/GetByNameAsync called [15.03.2025 13:16:46.694 +00:00 INF] 0HNAVDOPB25VS:00000002 /api/ProductCategory/GetHierarchy called [15.03.2025 13:16:46.949 +00:00 INF] 0HNAVDOPB25VS:00000003 /api/Order/GetAllByStatus called [15.03.2025 13:32:27.433 +00:00 INF] 0HNAVDOPB25VU:00000003 /styles/modern.deepsea.css called [15.03.2025 13:32:27.440 +00:00 INF] 0HNAVDOPB2600:00000001 /styles/modern.common.css called [15.03.2025 13:32:46.721 +00:00 INF] 0HNAVDOPB2600:00000003 /api/ProductCategory/GetHierarchy called [15.03.2025 13:32:46.737 +00:00 INF] 0HNAVDOPB25VU:00000004 /api/SiteSetting/GetByNameAsync called [15.03.2025 13:32:47.152 +00:00 INF] 0HNAVDOPB25VU:00000005 /api/Order/GetAllByStatus called [15.03.2025 13:32:47.369 +00:00 INF] 0HNAVDOPB25VU:00000006 /api/FavouriteOrder/GetAllByUserId called [15.03.2025 13:32:48.260 +00:00 INF] 0HNAVDOPB25VU:00000008 /api/Account/GetUserData called [15.03.2025 13:32:49.343 +00:00 INF] 0HNAVDOPB25VU:0000000C /api/Notification/GetAllByToUserId/0/8 called [15.03.2025 13:32:49.351 +00:00 INF] 0HNAVDOPB25VV:00000002 /api/SiteSetting/GetEnumValues called [15.03.2025 13:32:49.364 +00:00 INF] 0HNAVDOPB2601:00000001 /api/UserCoupon/getForCurrentUser called [15.03.2025 13:32:51.576 +00:00 INF] 0HNAVDOPB2601:00000002 /api/Account/GetUserData called [15.03.2025 13:32:51.577 +00:00 INF] 0HNAVDOPB25VU:0000000D /api/Notification/GetAllByToUserId/0/8 called [15.03.2025 13:32:51.583 +00:00 INF] 0HNAVDOPB25VV:00000003 /api/UserCoupon/getForCurrentUser called [15.03.2025 13:32:51.723 +00:00 INF] 0HNAVDOPB2602:00000001 /api/Offer/GetCountByStatusForUser called [15.03.2025 13:32:51.919 +00:00 INF] 0HNAVDOPB2602:00000002 /api/Order/GetOrdersByUserIdPagination called [15.03.2025 13:32:51.924 +00:00 INF] 0HNAVDOPB25VU:0000000E /api/Order/GetCountByStatusForUser called [15.03.2025 13:32:53.264 +00:00 INF] 0HNAVDOPB2602:00000003 /api/ProductCategory/GetHierarchy called [15.03.2025 13:32:53.497 +00:00 INF] 0HNAVDOPB2602:00000004 /api/Order/GetAllByStatus called [15.03.2025 13:32:53.712 +00:00 INF] 0HNAVDOPB2602:00000005 /api/FavouriteOrder/GetAllByUserId called [15.03.2025 13:32:54.371 +00:00 INF] 0HNAVDOPB2602:00000007 /api/Notification/GetAllByToUserId/0/8 called [15.03.2025 13:33:45.167 +00:00 INF] 0HNAVDOPB2602:00000008 /api/Order/GetAllByStatus called [15.03.2025 13:33:45.373 +00:00 ERR] 0HNAVDOPB2602:00000008 Api Error: 0HNAVDOPB2602:00000008 System.Data.SqlClient.SqlException (0x80131904): The number of rows provided for a FETCH clause must be greater then zero. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at Dapper.SqlMapper.GridReader.ReadDeferred[T](Int32 index, Func`2 deserializer, Type effectiveType)+MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Dapper.SqlMapper.GridReader.ReadImpl[T](Type type, Boolean buffered) in /_/Dapper/SqlMapper.GridReader.cs:line 205 at Dapper.SqlMapper.GridReader.Read[T](Boolean buffered) in /_/Dapper/SqlMapper.GridReader.cs:line 96 at Repository.Cqrs.Queries.OrderQuery.GetAllByStatusAsync(Nullable`1 status, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Cqrs/Queries/OrderQuery.cs:line 170 at Repository.Repositories.OrderRepository.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Repository/Repositories/OrderRepository.cs:line 88 at Service.Services.OrderService.GetAllByStatus(Nullable`1 orderStatus, Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, String lan) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Service/Services/OrderService.cs:line 273 at Api.Controllers.OrderController.GetAllByStatus(Nullable`1 categoryId, String productName, Int32 offset, Int32 limit, Nullable`1 status) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Controllers/OrderController.cs:line 201 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.OutputCaching.OutputCacheMiddleware.InvokeAwaited(HttpContext httpContext, IReadOnlyList`1 policies) at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.RateLimiting.RateLimitingMiddleware.InvokeInternal(HttpContext context, EnableRateLimitingAttribute enableRateLimitingAttribute) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Api.Infrastructure.Middlewares.ExceptionHandlerMiddleware.Invoke(HttpContext context, IAppLogger`1 logger) in /home/runner/work/FindIn.Api/FindIn.Api/Api/Api/Infrastructure/Middlewares/ExceptionHandlerMiddleware.cs:line 23 ClientConnectionId:e4e3887f-ff8c-4241-9fe1-e79a534a3b48 Error Number:10744,State:1,Class:15 ClientConnectionId before routing:1a03b258-8807-4db5-96f9-3bbfc5fb162d Routing Destination:fc36216f9290.tr806.uaenorth1-a.worker.database.windows.net,11048 [15.03.2025 13:33:56.554 +00:00 INF] 0HNAVDOPB2602:00000009 /api/Order/GetAllByStatus called [15.03.2025 13:35:23.436 +00:00 INF] 0HNAVDOPB2603:00000001 /api/SiteSetting/GetByNameAsync called [15.03.2025 13:35:23.454 +00:00 INF] 0HNAVDOPB2604:00000001 /api/ProductCategory/GetHierarchy called [15.03.2025 13:35:23.721 +00:00 INF] 0HNAVDOPB2604:00000002 /api/Order/GetAllByStatus called [15.03.2025 13:35:23.937 +00:00 INF] 0HNAVDOPB2604:00000003 /api/FavouriteOrder/GetAllByUserId called [15.03.2025 13:35:25.245 +00:00 INF] 0HNAVDOPB2604:00000005 /api/Account/GetUserData called [15.03.2025 13:35:26.322 +00:00 INF] 0HNAVDOPB2604:00000009 /api/UserCoupon/getForCurrentUser called [15.03.2025 13:35:26.322 +00:00 INF] 0HNAVDOPB2603:00000002 /api/Notification/GetAllByToUserId/0/8 called [15.03.2025 13:35:26.327 +00:00 INF] 0HNAVDOPB2606:00000001 /api/SiteSetting/GetEnumValues called [15.03.2025 13:35:58.261 +00:00 INF] 0HNAVDOPB2606:00000005 /api/Order/GetAllByStatus called [15.03.2025 13:51:36.988 +00:00 INF] 0HNAVDOPB2607:00000001 / called [15.03.2025 13:51:37.371 +00:00 INF] 0HNAVDOPB2607:00000002 /Images/ called [15.03.2025 13:51:37.936 +00:00 INF] 0HNAVDOPB2607:00000003 /invoices/ called [15.03.2025 13:51:38.318 +00:00 INF] 0HNAVDOPB2607:00000004 /Logs/ called [15.03.2025 13:51:38.891 +00:00 INF] 0HNAVDOPB2607:00000005 /Resources/ called [15.03.2025 15:39:19.805 +00:00 INF] Starting Detection version 8.14.0.0 [15.03.2025 15:39:21.244 +00:00 INF] Migrations [15.03.2025 15:39:21.282 +00:00 INF] 2024102202: _20241022230765_AlterProductsAndOrderItems [15.03.2025 15:39:21.284 +00:00 INF] 20240229001: Migration_GetAllByStatus [15.03.2025 15:39:21.285 +00:00 INF] 20240229002: Migration_GetAll [15.03.2025 15:39:21.286 +00:00 INF] 20240229003: Migration_GetOrdersByUserId [15.03.2025 15:39:21.287 +00:00 INF] 20240105195988: Migration_20240105195988 [15.03.2025 15:39:21.288 +00:00 INF] 20240106150801: Migration_20240106150801 [15.03.2025 15:39:21.289 +00:00 INF] 20240222282856: Migration_20240222282856 [15.03.2025 15:39:21.290 +00:00 INF] 20240225185332: Migration_20240225185332 [15.03.2025 15:39:21.291 +00:00 INF] 20240226001548: Migration_20240226001548 [15.03.2025 15:39:21.292 +00:00 INF] 20240229112234: Migration_20240229112234 [15.03.2025 15:39:21.293 +00:00 INF] 20240404234500: Migration_20240404234500 [15.03.2025 15:39:21.294 +00:00 INF] 20240411223124: Migration_20240411223124 [15.03.2025 15:39:21.294 +00:00 INF] 20240411233788: Migration_20240411233788 [15.03.2025 15:39:21.295 +00:00 INF] 20240416180711: Migration_20240416180711 [15.03.2025 15:39:21.297 +00:00 INF] 20240418235744: Migration_20240418235744 [15.03.2025 15:39:21.298 +00:00 INF] 20240422204700: Migration_20240422204700 [15.03.2025 15:39:21.299 +00:00 INF] 20240424002834: Migration_20240424002834 [15.03.2025 15:39:21.300 +00:00 INF] 20240522120865: Migration_20240522120865 [15.03.2025 15:39:21.301 +00:00 INF] 20240605165234: Migration_20240605165234 [15.03.2025 15:39:21.302 +00:00 INF] 20240607133587: Migration_20240607133587 [15.03.2025 15:39:21.303 +00:00 INF] 20240621144023: Migration_20240621144023 [15.03.2025 15:39:21.304 +00:00 INF] 20240622160323: Migration_20240622160323 [15.03.2025 15:39:21.305 +00:00 INF] 20240624180224: Migration_20240624180224 [15.03.2025 15:39:21.306 +00:00 INF] 20240703175787: Migration_20240703175787 [15.03.2025 15:39:21.307 +00:00 INF] 20240709130523: Migration_20240709130523 [15.03.2025 15:39:21.308 +00:00 INF] 20240725213744: Migration_20240725213744 [15.03.2025 15:39:21.309 +00:00 INF] 20240726111626: Migration_20240726111626 [15.03.2025 15:39:21.310 +00:00 INF] 20240728152901: Migration_20240728152901 [15.03.2025 15:39:21.311 +00:00 INF] 20240804210998: Migration_20240804210998 [15.03.2025 15:39:21.312 +00:00 INF] 20240816175945: Migration_20240816175945 [15.03.2025 15:39:21.313 +00:00 INF] 20240817174587: Migration_20240817174587 [15.03.2025 15:39:21.314 +00:00 INF] 20240822233401: Migration_20240822233401 [15.03.2025 15:39:21.315 +00:00 INF] 20240903132456: Migration_20240903132456 [15.03.2025 15:39:21.317 +00:00 INF] 20240903164034: Migration_20240903164034 [15.03.2025 15:39:21.318 +00:00 INF] 20240908142505: Migration_20240908142505 [15.03.2025 15:39:21.319 +00:00 INF] 20240924104345: Migration_20240924104345 [15.03.2025 15:39:21.320 +00:00 INF] 20240926102006: Migration_20240926102006 [15.03.2025 15:39:21.321 +00:00 INF] 20240929152890: Migration_20240929152890 [15.03.2025 15:39:21.322 +00:00 INF] 20240929154431: Migration_20240929154431 [15.03.2025 15:39:21.323 +00:00 INF] 20240929172067: Migration_20240929172067 [15.03.2025 15:39:21.324 +00:00 INF] 20240930165689: Migration_20240930165689 [15.03.2025 15:39:21.325 +00:00 INF] 20241003130612: Migration_20241003130612 [15.03.2025 15:39:21.326 +00:00 INF] 20241003184355: Migration_20241003184355 [15.03.2025 15:39:21.327 +00:00 INF] 20241022141756: _20241022141756_AddFullTextIndexToProductName [15.03.2025 15:39:21.328 +00:00 INF] 20241029150001: _20241029150001_AddForeignKeyForCourierIdInOfferTable [15.03.2025 15:39:21.329 +00:00 INF] 20241115134698: _20241115134698_AddCourierDeliveryCodeToOffers [15.03.2025 15:39:21.330 +00:00 INF] 20241116171145: _20241116171145_AddGeneralNameColumnToOrdersTable [15.03.2025 15:39:21.331 +00:00 INF] 20241118180303: _20241118180303_AddOfferIdAndOrderIdToRatings [15.03.2025 15:39:21.332 +00:00 INF] 20241204234532: _20241204234532_AlterStoredProcedure_Order_GetAllByStatus [15.03.2025 15:39:21.334 +00:00 INF] 20241220210487: _20241220210487_AddOrderGeneralNamesTable [15.03.2025 15:39:21.336 +00:00 INF] 20242403195365: Migration_20242403195365 [15.03.2025 15:39:21.337 +00:00 INF] 20242403210101: Migration_20242403210101 [15.03.2025 15:39:21.338 +00:00 INF] 20250104201087: _20250104201087_Alter_SP_CatImageUrl_Order_GetAllByStatus [15.03.2025 15:39:21.339 +00:00 INF] 20250108234897: _20250108234897_CreateTipsTable [15.03.2025 15:39:21.340 +00:00 INF] 20250112182409: _20250112182409_Alter_SP_ADD_STATUS_FILTER_GetAllByStatus [15.03.2025 15:39:21.341 +00:00 INF] 20250112183454: _20250112183454_CreateCallToActionTable [15.03.2025 15:39:21.343 +00:00 INF] 20250113111365: _20250113111365_Create_SP_GetAll_Completed [15.03.2025 15:39:21.344 +00:00 INF] 202403091170645: Migration_202403091170645 [15.03.2025 15:39:21.345 +00:00 INF] 202404032111114: Migration_20240403211111 [15.03.2025 15:39:21.346 +00:00 INF] 2024032122165643: Migration_2024032122165643 [15.03.2025 15:39:21.347 +00:00 INF] 2024040820368776: Migration_2024040820368776 [15.03.2025 15:39:21.348 +00:00 INF] 2024042112358764: Migration_2024042112358764 [15.03.2025 15:39:21.349 +00:00 WRN] 2024110406487223: Migration_2024110406487223 (current) [15.03.2025 15:39:22.891 +00:00 INF] 0HNB3QU7HAGM3:00000001 /robots933456.txt called [15.03.2025 15:39:23.631 +00:00 INF] 0HNB3QU7HAGM4:00000001 /robots933456.txt called [15.03.2025 15:39:24.592 +00:00 INF] 0HNB3QU7HAGM5:00000001 /robots933456.txt called [15.03.2025 15:39:25.607 +00:00 INF] 0HNB3QU7HAGM6:00000001 /robots933456.txt called [15.03.2025 15:39:26.600 +00:00 INF] 0HNB3QU7HAGM7:00000001 /robots933456.txt called [15.03.2025 19:57:09.878 +00:00 INF] 0HNB3QU7HAGM8:00000001 /api/ProductCategory/GetHierarchy called [15.03.2025 19:57:09.972 +00:00 INF] 0HNB3QU7HAGM9:00000001 /api/SiteSetting/GetByNameAsync called [15.03.2025 19:57:11.112 +00:00 INF] 0HNB3QU7HAGM8:00000002 /api/Order/GetAllByStatus called