Sitecore for Developers
Sitecore Commerce 8.2.1 Analytics Issue
This blog post quickly talks about a issue and resolution which I faced in populating the data in commerce related reports in experience analytics and experience profile.
My System Setup
The solution I was running was on Sitecore Commerce 8.2.1 and it was running the Habitat Retail Demo Site Link to the GitHub Repo .The symptoms of this issue are related to analytics data not being recorded and displayed in the Experience Analytics Dashboard. The following reports were showing no data
- Commerce- -> Orders report
- Commerce--> Products report
Order Report in Experience Analytics Dashboard Experience Profile reports : An Error Occurred Errors in Log FilesIn order to reproduce the issues, I placed an order on the website and quickly looked at the logs, the order it self processed successfully but the analytics events were not being processed.Issue DescriptionThe resolution to this issue was cumbersome because nothing really stood out to me , I have listed my troubleshooting path below
- Ensured that the commerce related page events are deployed correctly
- Mongo DB was collecting the interactions correctly
- SQL Server reporting databases has the page definitions
Upon further analysis , I have found out that throughout the code, sitecore commerce triggers a lot of events programatically, some of them have been listed belowUpon decompiling the DLL, I had discovered that when the order is created , The following event(s) are triggered programaticallyMethod Name : Sitecore.Commerce.AnalyticsData.OrderGoalAnalyticsDataResolutionThe real cause of the issue was that the goals were being triggered twice. The goal "Visitor Order Created" was checked on the "Order Confirmation Page" and this was causing the goal to be triggered twice (Once programatically and other through the UI). I had to un-check the goal as shown below and rebuild my reporting DB to get it all up and running againAfter un-checking the goal as shown above, Here are the reports.Experience Analytics Order Report Experience Profile : Commerce Tab Order ReportsPlease feel free to comment / reach me out at twitter @sjain_hi