Posts

Showing posts from May, 2024

Episerver MatchNodeOrCatalog: Crashes due to (0xC00000FD - Stack Overflow, 0x800703E9 - Recursion too deep; the stack overflowed.)

Image
Looking at the crash dump, the stack trace pointing to  MatchNodeOrCatalog : FaultingExceptionFrame HelperMethodFrame_PROTECTOBJ EPiServer.Core.Internal.ContentCacheKeyCreator.CreateMasterLanguageCacheKey(EPiServer.Core.ContentReference) EPiServer.Core.Internal.ContentInstanceCache.TryGet(EPiServer.Core.ContentReference, System.String, EPiServer.Core.IContent ByRef) EPiServer.Core.ContentProvider.LoadContentFromCacheOrRepository(EPiServer.Core.ContentReference, EPiServer.Core.ILanguageSelector) EPiServer.Core.Internal.ProviderPipelineImplementation.GetItem(EPiServer.Core.ContentProvider, EPiServer.Core.ContentReference, EPiServer.Core.LoaderOptions) EPiServer.Core.Internal.DefaultContentLoader.TryGet[[System.__Canon, mscorlib]](EPiServer.Core.ContentReference, EPiServer.Core.LoaderOptions, System.__Canon ByRef) StubHelperFrame Avensia.EpiFoundation.ContentProcessing.DependencyTracking.DependencyTrackingContentLoader.TryGet[[System.__Canon, mscorlib]](EPiServer.Core.ContentR...

Access permission to Commerce Customize left side tabs

Image
  Check the the access permission of the left menu Add a custom PermissionTypes to the code base: [PermissionTypes] public static class ProductPermissions { static ProductPermissions() { ProductView = new PermissionType(Permissions.GroupName, "product:mng:view"); } public static PermissionType ProductView { get; private set; } }     Add permission in all link ids in leftmnu.xml:

Episerver Commerce Report: Sales by day

Image
  We have an option TimeRangesInDays that generate reports, for example 30, 90, or 180 days. https://docs.developers.optimizely.com/customized-commerce/docs/option-configuration-classes   So when you run the job "Collect Order Data for Reports" it will update order data based on TimeRangesInDays to the table OrderReportData, then that data will be used in procedure [ecf_OrderReportData_AggregateByDay] when you generate the report     In case you want to change the sort order, you can modify the procedure with  OrderCreated DESC ALTER PROCEDURE [dbo].[ecf_OrderReportData_AggregateByDay]  @TimeZoneOffset DECIMAL(38, 9) = 0  AS  BEGIN  SELECT  CONVERT(DATE, DATEADD(minute, @TimeZoneOffset, OrderCreated)) AS OrderCreated,  MarketId,  Currency,  Site,  COUNT(OrderGroupId) AS NumOfOrders,  SUM(TotalQuantity) AS NumOfItems,  SUM(TaxTotal) AS TaxTotal,  SUM(ShippingTotal) as ShippingTotal,  SUM(Han...