Create and configure xdb indexes for Solr in Sitecore

-

When working on Sitecore personalization, sometimes we have seen the challenges related to profile interaction and personalization reports data is not correct.

Here's the common issue: your xdb indexes either are not up to date or they are not configured properly. In this article I am going explain you how to create and configure xdb indexes for SOLR search. 

1. Create SOLR Cores

  • Make 2 copies of Solr _default configurations from the <SolrDirectory>\server\solr\configset\_default folder. Put the copies in the <SolrDirectory>\server\solr folder.
  • Rename the cores <custom_name> and <custom_name>_rebuild, for example: xdb and xdb_rebuild.
  • Change your cores settings based on your required index names for SOLR xdb cors. Remove additional data inside cors data folder.
    Note: keep all folders inside the data folder and only remove the data.
  • Restart your SOLR service (open services.msc >> search SOLR service >> right click and restart it)
  • Update SOLR schema in xconnect-search-instance using the schema file located on <xconnect-search-instance>\App_data\solrcommands\schema.json. Schema update should apply for new xdb cors.

You can use the below PowerShell script that uses the Solr Schema API to apply the changes:
Note: If your Sitecore is hosted in Azure you can go to <xconnect-search-instance> kudo powershell console to run the powershell command.

  1. Create a powershell file (eg: “solrschemaupdate.ps1”) with below script.
  2. Open powershell in admin mode within your SOLR instance
  3. Go to your powershell file location
  4. Run your powershell command (eg: “.\solrschemaupdate.ps1”)

$pathToXdbSchemaFile="<xconnect-search-instance>\App_Data\solrcommands\schema.json"
$apiUrl="<solr-url>/ATCC_xdb/schema"
$requestBody = Get-Content $pathToXdbSchemaFile -Raw
Write-Host "Executing Solr commands:" $requestBody
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Invoke-WebRequest -Uri $apiUrl -ContentType "application/json" -Method Post -Body $requestBody | Write-Host 

2. Enable SOLR configurations in xconnect instance

  • Make sure “***.AzureSearch.xml” files are disabled and “SOLR.xml” files are enabled in <xconnect-instance> instance.




  • Specify the solrCore connection string with the name of core attached to Solr in below configuration files.
    <xconnect-instance>\App_Config\ConnectionStrings.config
    <xconnect-instance>\App_data\jobs\continuous\IndexWorker\App_config\ ConnectionStrings.config

The node you update looks like this:

<add name="solrCore" connectionString="https://<host>:<port>/solr/<custom_name>"/>

Note: Replace <custom_name> with your SOLR xdb core name.

3. Restart xconnect instance and rebuild xdb indexes in Sitecore CM.


Let me know your feedbacks.

Hope you enjoyed it !! 😊

Comments

Post a Comment

Popular posts from this blog

Sitecore 9 - Dynamic Placeholders

-
Image
Dynamic placeholders are useful when you want to repeat the same placeholder with different renderings/data sources.  Let's first understand the concept. Let's assume you want to use a placeholder with 2 different component on same page. I am going to create the Items based on below details. I am following the basic details, which is needed to create dynamic placeholders. - Create a Placeholder in your view.cshtml file @Sitecore().Placeholder("content-row-2-col") and publish it. - Create Rendering for your Component (component name: 2 Column Component) and publish it. - Create placeholder settings Item (settings name: 2 Column Component PS Settings) for your placeholder (placeholder key: "content-row-2-col") - Add 2 Column Component in your Placeholder Settings Allowed Controls. and publish it. - Open your page in Experience Editor - Click inside main-content placeholder >> Add Here >> Select 2 Column Component - Add data sources for Image tile...
Read more

Sitecore 10 - Containers and Docker

-
Image
Here I'll explain you some basic concepts related to containers and docker. If you look at the above diagram. you will get the basic understanding about the infrastructure requirements for Virtual machine setups. Don't get it ? Let me explain you. Virtual Machines: As per the above diagram it shows where each virtual machine has its own guest operating system which runs on top of the hosting infrastructure operating system. Hypervisor is the software used for creating virtual machines. Extra operating system per VM setup is obviously requires more space and load on Infrastructure. VM provides the hardware level process isolation where each applications run independently on virtual machines. Container:  Containers provide a lightweight and isolated runtime environment that encapsulates all the necessary components and dependencies required to run the applications. They uses host Operating system and does not need a separate OS. Containers provide OS level process isolation to r...
Read more