Exception Telemetry Details - #256 - Enterprise Exception Hub

Back to Dashboard Telemetry

Exception Audit Record #256

Delete Record

Application Metadata (AppInfoModel)

Application Name & Version DSTAPI v4.1.9.0
App Description A lightweight, high-performance DST api client handler
App Type ASP .NET 8 CORE API
Environment Mode Server
Token D5EE2R6ER6D3FF54E359

Device & Client Profile (PhysicalDeviceInformation)

Form Factor Desktop Workspace
Manufacturer & Model ATUL-SINGH Microsoft Windows 10.0.26200
Platform / OS .NET 8.0.21
Client IP Address 106.192.106.216
Exception Status & Mode Flags
Status: Unhandled Mode: Development

Code Reference & Location

Timestamp 2026-09-01 15:46:49 +05:30

Line Number Line 66

Namespace dst.admin.web.services.repo.Sales.Sales.List.Repository

Page / Component Name SalesListRepository

Method Name GetRouteWiseCustomerListByYearAsync

Site Map dst.admin.web.services.repo.Sales.Sales.List.Repository - SalesListRepository/GetRouteWiseCustomerListByYearAsync

File Path Source D:\Core Application\DST Admin Web Services\Sales\Sales\List\Repository\GetRouteWiseCustomerListByYearAsync.cs

Exception Message Payload

Primary Message

The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

Full Stack Trace Diagnostics

   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.Expand(Expression query)
   at Microsoft.EntityFrameworkCore.Query.QueryTranslationPreprocessor.Process(Expression query)
   at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
   at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass12_0`1.<ExecuteAsync>b__0()
   at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsync[TResult](Expression query, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
   at System.Runtime.CompilerServices.ConfiguredCancelableAsyncEnumerable`1.GetAsyncEnumerator()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at dst.admin.web.services.repo.Sales.Sales.List.Repository.SalesListRepository.GetRouteWiseCustomerListByYearAsync(String financialYear, CancellationToken cancellationToken) in D:\Core Application\DST Admin Web Services\Sales\Sales\List\Repository\GetRouteWiseCustomerListByYearAsync.cs:line 26