Steps to Enable Sitecore Analytics and Verify Data flow to Shard Databases

Hello everyone, This blog will help us to understand what settings are required to enable Sitecore Analytics in newly installed Sitecore instance. We will also see one common errors which get logged in our logs after setting up of our local instance. We will see the steps required to solve the same.

Without wasting time, let's start with the steps.

Steps to enable Analytics and verify data is flowing to Shard DB or not

1. Changed the below settings to true in the indexersettings.xml file in xconnect webroot

 Path:C:\inetpub\wwwroot\xconnectinstance\App_Data\jobs\continuous\IndexWorker\App_Data\config\sitecore\SearchIndexer

    o IndexPIISensitiveData

    o IndexAnonymousContactData

2. Rebuilt the xconnect indexes using the following command. Refer Rebuild XConnectIndex for same.

Path: C:\inetpub\wwwroot\xconnectinstance\App_Data\jobs\continuous\IndexWorker

    o Sitecore.XConnectSearchIndexer -rr

3. Rebuilt the Sitecore indexes as well

4. Rebuilt all three link database from control panel

5. Rebuilt reporting database by adding a new secondary database. Refer Link

    Path : /sitecore/admin/RebuildReportingDB.aspx

6. Checked Marketing definitions are deployed from Control Panel

7. Added below in the layout file

    o @using Sitecore.Mvc.Analytics.Extensions

    o @Html.Sitecore().VisitorIdentification()

8. Disabled the below bot settings false Marketing.Tracking --> Sitecore Analytics.Tracking

    o <setting name="Analytics.AutoDetectBots" set:value="false" />

    o <setting name="Analytics.Robots.IgnoreRobots" set:value="false" />

9. Below tracking settings are set to true

    o Xdb.Enabled

    o Xdb.Tracking.Enabled

10. Ensured no IPs have been added in the <excludedIPAddresses> tag

11. All three windows services (Marketing Automation, Processing, Index Worker) are on and working

Additional Notes :

1. If you are getting access-to-the-registry-key-global-is-denied issue in your logs then follow below steps: Run the following command in your command prompt. instance name is your local instance name. You can refer below Link for the same.

CMD> net localgroup "Performance Monitor Users" "IIS APPPOOL\instance name" /add

CMD> net localgroup "Performance Log Users" "IIS APPPOOL\instance name" /add

CMD> net localgroup "Performance Monitor Users" "IIS APPPOOL\xconnect instance name" /add

CMD> net localgroup "Performance Log Users" "IIS APPPOOL\xconnect instance name" /add

2. Data is still not flowing to Shard then you might be missing the post installation steps which need to be executed in SSMS. Database prefix will be your local database prefix name. Try to run this query in SQL Command mode.

       
:SETVAR DatabasePrefix Sitecore10XP1
:SETVAR UserName collectionuser
:SETVAR Password Test12345
:SETVAR ShardMapManagerDatabaseNameSuffix _Xdb.Collection.ShardMapManager
:SETVAR Shard0DatabaseNameSuffix _Xdb.Collection.Shard0 
:SETVAR Shard1DatabaseNameSuffix _Xdb.Collection.Shard1

GO

IF(SUSER_ID('$(UserName)') IS NULL) 
BEGIN  
       CREATE LOGIN [$(UserName)] WITH PASSWORD = '$(Password)'; END; 
GO 
 
USE [$(DatabasePrefix)$(ShardMapManagerDatabaseNameSuffix)]  
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'$(UserName)') BEGIN 
    CREATE USER [$(UserName)] FOR LOGIN [$(UserName)]   
       GRANT SELECT ON SCHEMA :: __ShardManagement TO [$(UserName)]        GRANT EXECUTE ON SCHEMA :: __ShardManagement TO [$(UserName)] END; 
GO 
 
USE [$(DatabasePrefix)$(Shard0DatabaseNameSuffix)]  
 
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'$(UserName)') BEGIN 
    CREATE USER [$(UserName)] FOR LOGIN [$(UserName)]   
       EXEC [xdb_collection].[GrantLeastPrivilege] @UserName = '$(UserName)' END; 
GO 
 
USE [$(DatabasePrefix)$(Shard1DatabaseNameSuffix)]  
 
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'$(UserName)') BEGIN 
    CREATE USER [$(UserName)] FOR LOGIN [$(UserName)]  atabs
       EXEC [xdb_collection].[GrantLeastPrivilege] @UserName = '$(UserName)' END; 
 
GO

Once all steps are completed, you should be able to see analytics is working fine and data is flowing to respective Shard Databases.

Thanks for reading and happy learning

You can checkout my other blogs too. Link

Comments

Post a Comment

Popular posts from this blog

Sitecore XM Cloud Form Integration with Azure Function as Webhook

Image
Hello everyone, In this blog, we will see, how Azure Function can be used with Sitecore Forms. Before starting, I would request everyone to read my previous blog on XM Cloud Form as I am not going to go deep with how to create forms in XM Cloud. Creating Azure Function : Will serve as our Webhook Creating and Integrating Form : XM Cloud Form Creating An Azure Function I will not explain how you can create Azure Function with Http Trigger. You can check this youtube link here . Also in reference section, I will provide the link how you can connect and deploy your changes to azure function using Visual Studio. Azure Function Code : Its just a starter code which Azure function by default. Creating XM Cloud Form and Integrating with Azure Function Step 1 : Create a form from Form Editor and once form us published, you can see the below view in preview state. Here you can edit your form too. But it always recommended to use a version of that form as whatever changes is done will ...
Read more

Automate RSS Feed to Sitecore XM Cloud: Logic App, Next.js API & Authoring API Integration

Image
Hello everyone, In this blog, we will see a pratical use case of reading RSS feed and creating the respective items in Sitecore XM Cloud. To accomplish the task, we will use Logic App, an API created in Next JS and lastly calling the Authoring API to execute mutation query for Item Creation in Sitecore. Let's divide the process into 2 parts: Logic App : This will mostly focus on fetching the feed from RSS, performing transformation, storing the result in array of json object and pushing the data to next js api endpoint. Next JS API Development : This will take care of calling the authoring api of XM Cloud instance and performing the create item mutation query on the recieved data from Logic App. Logic App Azure Logic App is a cloud-based service provided by Microsoft Azure that allows you to automate workflows and integrate applications, data, services, and systems without writing complex code. It enables you to create automated workflows visually through...
Read more

Create and Fetch Content From Sitecore Content Hub One using GraphQL and React

Image
Hello everyone, In this blog, we will see overview of Sitecore Content Hub One product its benefits, features etc. This blog will walkthrough below listed points. Overview Features Content Hub One Dashboard Creating Taxonomy Creating Content Type Uploading New Media Creating Content Items From Content Type Getting GraphQL Token Creating Sample React Application To Read the Content from Content Hub One Overview Sitecore Content Hub One is a powerful platform. It is designed to centralize and streamline content creation, management, and distribution across various channels.Focuses on delivering content via APIs, enabling seamless integration with various front-end frameworks.Hosted in the cloud, offering scalability, automatic updates, and reduced infrastructure management.Provides flexible APIs and SDKs for developers to integrate and build custom solutions efficiently. Features Headless Content Management : Allows content to be delivered via APIs to any front-end or platfor...
Read more