My new blog present here.

Featured Post

Insights into Sitecore Search: A Definitive Introduction

A key component of digital experience management is effective information retrieval. A simplified approach is required for websites, applications, and platforms containing a lot of material so that consumers can easily get the data they require. This need is met by Sitecore, a well-known name in the field of digital experience platforms (DXPs), which provides powerful and comprehensive search functionality. We will travel into the realm of Sitecore Search in this article, learning about its capabilities, architecture , and the enormous value it offers both developers and end users. Introduction to Sitecore Search    A headless content discovery platform powered by AI , Sitecore Search enables you to build predictive and custom search experiences across various content sources. To extract and ...
Post a Comment

Sitecore Error Troubleshooting: Sitecore Solr Connectivity Issue:: Part-1

Sitecore Error Troubleshooting: Sitecore Solr Connectivity Issue:: Part-1
How to verify Sitecore 9.1 (IaaS and Azure PaaS) + Solr (IaaS) Connectivity
In this article, I will explain how to check the connectivity between the Sitecore instance and Solr (IaaS) instance.

Problem Statement:
I was spinning up Sitecore 9.1 (Initial Release) Azure PaaS XP topology with Developer configuration and search provider was Solr (IaaS) and Solr instance already created in Azure box and url is https://12.832.11.201:8983/solr and its using Self-Signed certificates.

The Solr url https://12.832.11.201:8983/solr accessible via browser.



After completion of web app creation, I tried accessing the instance with url: https://ak-sitecore-91-123456-single.azurewebsites.net/ and logged into Sitecore Launch Pad >  Control Panel > Indexing > Indexing Manager:


Was not loading the Solr indexes.

Note: Same way we can verify above settings in Sitecore IaaS instance.

Steps to verify Sitecore and Solr connectivity:

Step-1: This steps can be used for both Sitecore Azure PaaS and IaaS Instance
When we are creating the Sitecore instance by providing the Solr url then sometimes, Sitecore related cores not be created. To verify that go to your Solr url and verify total 11 Sitecore cores present or not: 


 The 11 Sitecore Solr cores/collections are:

1 sitecore_core_index
2 sitecore_fxm_master_index
3 sitecore_fxm_web_index
4 sitecore_marketing_asset_index_master
5 sitecore_marketing_asset_index_web
6 sitecore_marketingdefinitions_master
7 sitecore_marketingdefinitions_web
8 sitecore_master_index
9 sitecore_suggested_test_index
10 sitecore_testing_index
11 sitecore_web_index

 If anyone of the Sitecore Solr core not present at Solr instance then create it: for example sitecore_master_index not present

  • Open the command prompt in Administrator mode.
  • Go to bin folder of Solr “c:\solr-6.6.2\bin”
  • Run the command “solr create -c sitecore_master_index”
  • After execution of command, go to c:\solr-6.6.2\server\solr\sitecore_master_index\conf folder and place the "managed-schema" file from your existing Solr core instance of sitecore_master_index (<Working Solr instance>\server\solr\sitecore_master_index\conf ). If you are not having running Solr instance then you can take managed-schema of Sitecore 9.0.2 instance from:
    <?xml version="1.0" encoding="UTF-8"?>
    <!-- Solr managed schema - automatically generated - DO NOT EDIT -->
    <schema name="example-basic" version="1.6">
    <uniqueKey>_uniqueid</uniqueKey>
    <fieldType name="ancestor_path" class="solr.TextField">
    <analyzer type="index">
    <tokenizer class="solr.KeywordTokenizerFactory"/>
    </analyzer>
    <analyzer type="query">
    <tokenizer class="solr.PathHierarchyTokenizerFactory" delimiter="/"/>
    </analyzer>
    </fieldType>
    <fieldType name="binary" class="solr.BinaryField"/>
    <fieldType name="boolean" class="solr.BoolField" sortMissingLast="true"/>
    <fieldType name="booleans" class="solr.BoolField" sortMissingLast="true" multiValued="true"/>
    <fieldType name="currency" class="solr.CurrencyField" currencyConfig="currency.xml" defaultCurrency="USD" precisionStep="8"/>
    <fieldType name="date" class="solr.TrieDateField" positionIncrementGap="0" docValues="true" precisionStep="0"/>
    <fieldType name="dates" class="solr.TrieDateField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="0"/>
    <fieldType name="descendent_path" class="solr.TextField">
    <analyzer type="index">
    <tokenizer class="solr.PathHierarchyTokenizerFactory" delimiter="/"/>
    </analyzer>
    <analyzer type="query">
    <tokenizer class="solr.KeywordTokenizerFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="double" class="solr.TrieDoubleField" positionIncrementGap="0" docValues="true" precisionStep="0"/>
    <fieldType name="doubles" class="solr.TrieDoubleField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="0"/>
    <fieldType name="float" class="solr.TrieFloatField" positionIncrementGap="0" docValues="true" precisionStep="0"/>
    <fieldType name="floats" class="solr.TrieFloatField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="0"/>
    <fieldType name="ignored" class="solr.StrField" indexed="false" stored="false" docValues="false" multiValued="true"/>
    <fieldType name="int" class="solr.TrieIntField" positionIncrementGap="0" docValues="true" precisionStep="0"/>
    <fieldType name="ints" class="solr.TrieIntField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="0"/>
    <fieldType name="location" class="solr.LatLonPointSpatialField" docValues="true"/>
    <fieldType name="location_rpt" class="solr.SpatialRecursivePrefixTreeFieldType" geo="true" maxDistErr="0.001" distErrPct="0.025" distanceUnits="kilometers"/>
    <fieldType name="long" class="solr.TrieLongField" positionIncrementGap="0" docValues="true" precisionStep="0"/>
    <fieldType name="longs" class="solr.TrieLongField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="0"/>
    <fieldType name="lowercase" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.KeywordTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="pdate" class="solr.DatePointField" docValues="true"/>
    <fieldType name="pdates" class="solr.DatePointField" docValues="true" multiValued="true"/>
    <fieldType name="pdouble" class="solr.DoublePointField" docValues="true"/>
    <fieldType name="pdoubles" class="solr.DoublePointField" docValues="true" multiValued="true"/>
    <fieldType name="pfloat" class="solr.FloatPointField" docValues="true"/>
    <fieldType name="pfloats" class="solr.FloatPointField" docValues="true" multiValued="true"/>
    <fieldType name="phonetic_en" class="solr.TextField" indexed="true" stored="false">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.DoubleMetaphoneFilterFactory" inject="false"/>
    </analyzer>
    </fieldType>
    <fieldType name="pint" class="solr.IntPointField" docValues="true"/>
    <fieldType name="pints" class="solr.IntPointField" docValues="true" multiValued="true"/>
    <fieldType name="plong" class="solr.LongPointField" docValues="true"/>
    <fieldType name="plongs" class="solr.LongPointField" docValues="true" multiValued="true"/>
    <fieldType name="point" class="solr.PointType" subFieldSuffix="_d" dimension="2"/>
    <fieldType name="random" class="solr.RandomSortField" indexed="true"/>
    <fieldType name="string" class="solr.StrField" sortMissingLast="true" docValues="true"/>
    <fieldType name="strings" class="solr.StrField" sortMissingLast="true" docValues="true" multiValued="true"/>
    <fieldType name="tdate" class="solr.TrieDateField" positionIncrementGap="0" docValues="true" precisionStep="6"/>
    <fieldType name="tdates" class="solr.TrieDateField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="6"/>
    <fieldType name="tdouble" class="solr.TrieDoubleField" positionIncrementGap="0" docValues="true" precisionStep="8"/>
    <fieldType name="tdoubles" class="solr.TrieDoubleField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="8"/>
    <fieldType name="text_ar" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_ar.txt" ignoreCase="true"/>
    <filter class="solr.ArabicNormalizationFilterFactory"/>
    <filter class="solr.ArabicStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_bg" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_bg.txt" ignoreCase="true"/>
    <filter class="solr.BulgarianStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_ca" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.ElisionFilterFactory" articles="lang/contractions_ca.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_ca.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Catalan"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_cjk" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.CJKWidthFilterFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.CJKBigramFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_cz" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_cz.txt" ignoreCase="true"/>
    <filter class="solr.CzechStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_da" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_da.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Danish"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_de" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_de.txt" ignoreCase="true"/>
    <filter class="solr.GermanNormalizationFilterFactory"/>
    <filter class="solr.GermanLightStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_el" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.GreekLowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_el.txt" ignoreCase="false"/>
    <filter class="solr.GreekStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_en" class="solr.TextField" positionIncrementGap="100">
    <analyzer type="index">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_en.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.EnglishPossessiveFilterFactory"/>
    <filter class="solr.KeywordMarkerFilterFactory" protected="protwords.txt"/>
    <filter class="solr.PorterStemFilterFactory"/>
    </analyzer>
    <analyzer type="query">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.SynonymGraphFilterFactory" expand="true" ignoreCase="true" synonyms="synonyms.txt"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_en.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.EnglishPossessiveFilterFactory"/>
    <filter class="solr.KeywordMarkerFilterFactory" protected="protwords.txt"/>
    <filter class="solr.PorterStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_en_splitting" class="solr.TextField" autoGeneratePhraseQueries="true" positionIncrementGap="100">
    <analyzer type="index">
    <tokenizer class="solr.WhitespaceTokenizerFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_en.txt" ignoreCase="true"/>
    <filter class="solr.WordDelimiterGraphFilterFactory" catenateNumbers="1" generateNumberParts="1" splitOnCaseChange="1" generateWordParts="1" catenateAll="0" catenateWords="1"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.KeywordMarkerFilterFactory" protected="protwords.txt"/>
    <filter class="solr.PorterStemFilterFactory"/>
    <filter class="solr.FlattenGraphFilterFactory"/>
    </analyzer>
    <analyzer type="query">
    <tokenizer class="solr.WhitespaceTokenizerFactory"/>
    <filter class="solr.SynonymGraphFilterFactory" expand="true" ignoreCase="true" synonyms="synonyms.txt"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_en.txt" ignoreCase="true"/>
    <filter class="solr.WordDelimiterGraphFilterFactory" catenateNumbers="0" generateNumberParts="1" splitOnCaseChange="1" generateWordParts="1" catenateAll="0" catenateWords="0"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.KeywordMarkerFilterFactory" protected="protwords.txt"/>
    <filter class="solr.PorterStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_en_splitting_tight" class="solr.TextField" autoGeneratePhraseQueries="true" positionIncrementGap="100">
    <analyzer type="index">
    <tokenizer class="solr.WhitespaceTokenizerFactory"/>
    <filter class="solr.SynonymGraphFilterFactory" expand="false" ignoreCase="true" synonyms="synonyms.txt"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_en.txt" ignoreCase="true"/>
    <filter class="solr.WordDelimiterGraphFilterFactory" catenateNumbers="1" generateNumberParts="0" generateWordParts="0" catenateAll="0" catenateWords="1"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.KeywordMarkerFilterFactory" protected="protwords.txt"/>
    <filter class="solr.EnglishMinimalStemFilterFactory"/>
    <filter class="solr.RemoveDuplicatesTokenFilterFactory"/>
    <filter class="solr.FlattenGraphFilterFactory"/>
    </analyzer>
    <analyzer type="query">
    <tokenizer class="solr.WhitespaceTokenizerFactory"/>
    <filter class="solr.SynonymGraphFilterFactory" expand="false" ignoreCase="true" synonyms="synonyms.txt"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_en.txt" ignoreCase="true"/>
    <filter class="solr.WordDelimiterGraphFilterFactory" catenateNumbers="1" generateNumberParts="0" generateWordParts="0" catenateAll="0" catenateWords="1"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.KeywordMarkerFilterFactory" protected="protwords.txt"/>
    <filter class="solr.EnglishMinimalStemFilterFactory"/>
    <filter class="solr.RemoveDuplicatesTokenFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_es" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_es.txt" ignoreCase="true"/>
    <filter class="solr.SpanishLightStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_eu" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_eu.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Basque"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_fa" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <charFilter class="solr.PersianCharFilterFactory"/>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.ArabicNormalizationFilterFactory"/>
    <filter class="solr.PersianNormalizationFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_fa.txt" ignoreCase="true"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_fi" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_fi.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Finnish"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_fr" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.ElisionFilterFactory" articles="lang/contractions_fr.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_fr.txt" ignoreCase="true"/>
    <filter class="solr.FrenchLightStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_ga" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.ElisionFilterFactory" articles="lang/contractions_ga.txt" ignoreCase="true"/>
    <filter class="solr.StopFilterFactory" words="lang/hyphenations_ga.txt" ignoreCase="true"/>
    <filter class="solr.IrishLowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_ga.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Irish"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_general" class="solr.TextField" positionIncrementGap="100" multiValued="false">
    <analyzer type="index">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StopFilterFactory" words="stopwords.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    </analyzer>
    <analyzer type="query">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StopFilterFactory" words="stopwords.txt" ignoreCase="true"/>
    <filter class="solr.SynonymFilterFactory" expand="true" ignoreCase="true" synonyms="synonyms.txt"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_general_rev" class="solr.TextField" positionIncrementGap="100">
    <analyzer type="index">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.StopFilterFactory" words="stopwords.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.ReversedWildcardFilterFactory" maxPosQuestion="2" maxFractionAsterisk="0.33" maxPosAsterisk="3" withOriginal="true"/>
    </analyzer>
    <analyzer type="query">
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.SynonymGraphFilterFactory" expand="true" ignoreCase="true" synonyms="synonyms.txt"/>
    <filter class="solr.StopFilterFactory" words="stopwords.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_gl" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_gl.txt" ignoreCase="true"/>
    <filter class="solr.GalicianStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_hi" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.IndicNormalizationFilterFactory"/>
    <filter class="solr.HindiNormalizationFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_hi.txt" ignoreCase="true"/>
    <filter class="solr.HindiStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_hu" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_hu.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Hungarian"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_hy" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_hy.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Armenian"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_id" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_id.txt" ignoreCase="true"/>
    <filter class="solr.IndonesianStemFilterFactory" stemDerivational="true"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_it" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.ElisionFilterFactory" articles="lang/contractions_it.txt" ignoreCase="true"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_it.txt" ignoreCase="true"/>
    <filter class="solr.ItalianLightStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_ja" class="solr.TextField" autoGeneratePhraseQueries="false" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.JapaneseTokenizerFactory" mode="search"/>
    <filter class="solr.JapaneseBaseFormFilterFactory"/>
    <filter class="solr.JapanesePartOfSpeechStopFilterFactory" tags="lang/stoptags_ja.txt"/>
    <filter class="solr.CJKWidthFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_ja.txt" ignoreCase="true"/>
    <filter class="solr.JapaneseKatakanaStemFilterFactory" minimumLength="4"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_lv" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_lv.txt" ignoreCase="true"/>
    <filter class="solr.LatvianStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_nl" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_nl.txt" ignoreCase="true"/>
    <filter class="solr.StemmerOverrideFilterFactory" dictionary="lang/stemdict_nl.txt" ignoreCase="false"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Dutch"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_no" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_no.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Norwegian"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_pt" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_pt.txt" ignoreCase="true"/>
    <filter class="solr.PortugueseLightStemFilterFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_ro" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_ro.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Romanian"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_ru" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_ru.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Russian"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_sv" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" format="snowball" words="lang/stopwords_sv.txt" ignoreCase="true"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Swedish"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_th" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.ThaiTokenizerFactory"/>
    <filter class="solr.LowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_th.txt" ignoreCase="true"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_tr" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.StandardTokenizerFactory"/>
    <filter class="solr.TurkishLowerCaseFilterFactory"/>
    <filter class="solr.StopFilterFactory" words="lang/stopwords_tr.txt" ignoreCase="false"/>
    <filter class="solr.SnowballPorterFilterFactory" language="Turkish"/>
    </analyzer>
    </fieldType>
    <fieldType name="text_ws" class="solr.TextField" positionIncrementGap="100">
    <analyzer>
    <tokenizer class="solr.WhitespaceTokenizerFactory"/>
    </analyzer>
    </fieldType>
    <fieldType name="tfloat" class="solr.TrieFloatField" positionIncrementGap="0" docValues="true" precisionStep="8"/>
    <fieldType name="tfloats" class="solr.TrieFloatField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="8"/>
    <fieldType name="tint" class="solr.TrieIntField" positionIncrementGap="0" docValues="true" precisionStep="8"/>
    <fieldType name="tints" class="solr.TrieIntField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="8"/>
    <fieldType name="tlong" class="solr.TrieLongField" positionIncrementGap="0" docValues="true" precisionStep="8"/>
    <fieldType name="tlongs" class="solr.TrieLongField" positionIncrementGap="0" docValues="true" multiValued="true" precisionStep="8"/>
    <field name="__bucketable" type="boolean" indexed="true" stored="false"/>
    <field name="__hidden" type="boolean" indexed="true" stored="false"/>
    <field name="__is_bucket" type="boolean" indexed="true" stored="false"/>
    <field name="__semantics" type="string" multiValued="true" indexed="true" stored="true"/>
    <field name="__workflow_state" type="string" indexed="true" stored="false"/>
    <field name="_content" type="text_general" indexed="true" stored="false"/>
    <field name="_created" type="tdate" indexed="true" stored="true"/>
    <field name="_creator" type="lowercase" indexed="true" stored="true"/>
    <field name="_database" type="string" indexed="true" stored="true"/>
    <field name="_datasource" type="string" indexed="true" required="true" stored="true"/>
    <field name="_displayname" type="text_general" indexed="true" stored="true"/>
    <field name="_editor" type="lowercase" indexed="true" stored="true"/>
    <field name="_fullpath" type="lowercase" indexed="true" stored="true"/>
    <field name="_group" type="string" indexed="true" stored="true"/>
    <field name="_hash" type="string" indexed="true" stored="true"/>
    <field name="_hidden" type="boolean" indexed="true" stored="false"/>
    <field name="_icon" type="string" indexed="true" stored="true"/>
    <field name="_indexname" type="string" indexed="true" stored="true"/>
    <field name="_indextimestamp" type="tdate" default="NOW" indexed="true" stored="true"/>
    <field name="_isclone" type="boolean" indexed="true" stored="true"/>
    <field name="_language" type="string" indexed="true" stored="true"/>
    <field name="_latestversion" type="boolean" indexed="true" stored="true"/>
    <field name="_links" type="string" multiValued="true" indexed="true" stored="true"/>
    <field name="_name" type="text_general" indexed="true" stored="true"/>
    <field name="_parent" type="string" indexed="true" stored="true"/>
    <field name="_path" type="string" multiValued="true" indexed="true" stored="false"/>
    <field name="_tags" type="string" multiValued="true" indexed="true" stored="true"/>
    <field name="_template" type="lowercase" indexed="true" stored="true"/>
    <field name="_templatename" type="string" indexed="true" stored="true"/>
    <field name="_templates" type="string" multiValued="true" indexed="true" stored="true"/>
    <field name="_uniqueid" type="string" indexed="true" required="true" stored="true"/>
    <field name="_updated" type="tdate" indexed="true" stored="true"/>
    <field name="_version" type="string" indexed="true" stored="true"/>
    <field name="_version_" type="long" indexed="true" stored="true"/>
    <field name="is_displayed_in_search_results" type="boolean" indexed="true" stored="false"/>
    <field name="lock" type="boolean" indexed="true" stored="false"/>
    <field name="text" type="text_general" multiValued="true" indexed="true" stored="false"/>
    <field name="text_rev" type="text_general_rev" multiValued="true" indexed="true" stored="false"/>
    <dynamicField name="*_ignored" type="ignored" indexed="true" stored="true"/>
    <dynamicField name="*_random" type="random" indexed="true" stored="true"/>
    <dynamicField name="*_t_en" type="text_general" indexed="true" stored="true"/>
    <dynamicField name="*_t_ar" type="text_ar" indexed="true" stored="true"/>
    <dynamicField name="*_t_bg" type="text_bg" indexed="true" stored="true"/>
    <dynamicField name="*_t_ca" type="text_ca" indexed="true" stored="true"/>
    <dynamicField name="*_t_cz" type="text_cz" indexed="true" stored="true"/>
    <dynamicField name="*_t_da" type="text_da" indexed="true" stored="true"/>
    <dynamicField name="*_t_de" type="text_de" indexed="true" stored="true"/>
    <dynamicField name="*_t_el" type="text_el" indexed="true" stored="true"/>
    <dynamicField name="*_t_es" type="text_es" indexed="true" stored="true"/>
    <dynamicField name="*_t_eu" type="text_eu" indexed="true" stored="true"/>
    <dynamicField name="*_t_fa" type="text_fa" indexed="true" stored="true"/>
    <dynamicField name="*_t_fi" type="text_fi" indexed="true" stored="true"/>
    <dynamicField name="*_t_fr" type="text_fr" indexed="true" stored="true"/>
    <dynamicField name="*_t_ga" type="text_ga" indexed="true" stored="true"/>
    <dynamicField name="*_t_gl" type="text_gl" indexed="true" stored="true"/>
    <dynamicField name="*_t_hi" type="text_hi" indexed="true" stored="true"/>
    <dynamicField name="*_t_hu" type="text_hu" indexed="true" stored="true"/>
    <dynamicField name="*_t_hy" type="text_hy" indexed="true" stored="true"/>
    <dynamicField name="*_t_id" type="text_id" indexed="true" stored="true"/>
    <dynamicField name="*_t_it" type="text_it" indexed="true" stored="true"/>
    <dynamicField name="*_t_ja" type="text_ja" indexed="true" stored="true"/>
    <dynamicField name="*_t_lv" type="text_lv" indexed="true" stored="true"/>
    <dynamicField name="*_t_nl" type="text_nl" indexed="true" stored="true"/>
    <dynamicField name="*_t_no" type="text_no" indexed="true" stored="true"/>
    <dynamicField name="*_t_pt" type="text_pt" indexed="true" stored="true"/>
    <dynamicField name="*_t_ro" type="text_ro" indexed="true" stored="true"/>
    <dynamicField name="*_t_ru" type="text_ru" indexed="true" stored="true"/>
    <dynamicField name="*_t_sv" type="text_sv" indexed="true" stored="true"/>
    <dynamicField name="*_t_th" type="text_th" indexed="true" stored="true"/>
    <dynamicField name="*_t_tr" type="text_tr" indexed="true" stored="true"/>
    <dynamicField name="*_tdtm" type="tdate" multiValued="true" indexed="true" stored="true"/>
    <dynamicField name="*_txm" type="text_general" multiValued="true" indexed="true" stored="true"/>
    <dynamicField name="*_tdt" type="tdate" indexed="true" stored="true"/>
    <dynamicField name="*_rpt" type="location_rpt" indexed="true" stored="true"/>
    <dynamicField name="*_sm" type="string" multiValued="true" indexed="true" stored="true"/>
    <dynamicField name="*_im" type="int" multiValued="true" indexed="true" stored="true"/>
    <dynamicField name="*_dt" type="date" indexed="true" stored="true"/>
    <dynamicField name="*_ti" type="tint" indexed="true" stored="true"/>
    <dynamicField name="*_tl" type="tlong" indexed="true" stored="true"/>
    <dynamicField name="*_tf" type="tfloat" indexed="true" stored="true"/>
    <dynamicField name="*_td" type="tdouble" indexed="true" stored="true"/>
    <dynamicField name="*_pi" type="tint" indexed="true" stored="true"/>
    <dynamicField name="*_t" type="text_general" indexed="true" stored="true"/>
    <dynamicField name="*_i" type="int" indexed="true" stored="true"/>
    <dynamicField name="*_s" type="string" indexed="true" stored="true"/>
    <dynamicField name="*_b" type="boolean" indexed="true" stored="true"/>
    <dynamicField name="*_p" type="location" indexed="true" stored="true"/>
    <dynamicField name="*_c" type="currency" indexed="true" stored="true"/>
    </schema>
    view raw managed-schema hosted with ❤ by GitHub
  • Repeat above steps for all missing Sitecore Solr cores.
  • Restart the Solr service
  • Restart the Sitecore instance or Sitecore Azure App Service
  • Login into Sitecore instance and access the itecore Launch Pad >  Control Panel > Indexing > Indexing Manager and verify that Solr indexes are loading or not.
  • If Solr indexes are loading then re-build all the indexes and check count of documents (numDocs) in each Sitecore Solr core at Solr instance.
  • If Solr indexes are not loading then proceed to next step.
This error usually occurred when you are trying to setup Sitecore XP Scaled topology.

Step-2: This step needs to be verified if Solr deployed into different box

In this step we will verify the Inbound and Outbound rule in Solr box: How to open ports to a virtual machine with the Azure portal.

Please check reference articles for this:
Step-3: This step needs to be verified if we are using Sitecore Azure PaaS Instance

In this step, we will verify that Sitecore Azure PaaS instance being able to contact Solr box or not.

  • Login into https://portal.azure.com > Go to Resource groups > Select Resource Group in which Sitecore Azure PaaS instance created.
  • Search the App Service ak-sitecore-91-123456-single.
  • Click on Advance Tools> Go > Debug Console > CMD:


                How to directly check the KUDO tool directly with App service url 
                 https://ak-sitecore-91- 123456-single.azurewebsites.net/:

                   >Add the -scm before the .azurewebsites.net like: 
                   https://ak-sitecore-91-123456-single- scm.azurewebsites.net/
  • Enter the tcpping and see it’s recognizing the command or not:

     Now access the Solr ip address with IP Address 12.832.11.201:8983 and see request coming or 
     not: like below
    D:\home>tcpping 12.832.11.201:8983 
Connected to 12.832.11.201:8983, time taken: 244ms 
Connected to 12.832.11.201:8983, time taken: 15ms 
Connected to 12.832.11.201:8983, time taken: 29ms 
Connected to 12.832.11.201:8983, time taken: 32ms 
Complete: 4/4 successful attempts (100%). Average success time: 80ms 

Step-4:
In the Step-3, we verified that connectivity happening from Sitecore box to Solr box. Now we will cross check that connection string for Solr clearly mentioned or not in the Sitecore instance.

Now go to site>wwwroot>App_Config>ConnectionStrings.config and look for solr.search, and check that its pointing to correct Solr instance:
  <add name="solr.search" connectionString="https://12.832.11.201:8983/solr" />

Note: Same way we can verify above settings in Sitecore IaaS instance. Change the url of Solr, if not correct.

Step-5: This steps can be used for both Sitecore Azure PaaS and IaaS Instance
By performing above mentioned steps, if still Solr indexes are not loading into Sitecore. Then we have to create the new core in the Solr with documents/records and try to access this Solr core using the Solr.NET via ASP.NET MVC application and will deploy into Azure Web App. It will help us to understand that Solr connectivity:

  • Available to different Resource Group and resources
  • Inbound and Outbound rules are working
  • Solr instance available
Now we will create the Solr core (or collection) and configure the solr schema :
  • Open the command prompt in Administrator mode.
  • Go to bin folder of Solr “c:\solr-6.6.2\bin”
  • Run the command “solr create -c samplecollection”
     

Now add sample document to newly created core:

  • In the command prompt (Administrator mode), go to folder "<Drive>:\<Solr Instance folder>\example\exampledocs. This folder will contains the sample documents which can be used in our newly created Solr core or collection. .
  • Run the below command:
          java -Djavax.net.ssl.keyStorePassword=secret -Djavax.net.ssl.keyStore=../../server/etc/solr-ssl.keystore.jks -Djavax.net.ssl.trustStore=../../server/etc/solr-ssl.keystore.jks -Djavax.net.ssl.trustStorePassword=secret -Durl=https://localhost:8983/solr/samplecollection/update -jar post.jar *.xml

In the above command, change :
  • Solr certificate password from secret to your solr certificate password. By default certificate password is secret.
  • Solr url with port number.
  • Solr core or collection name.


Now access the url https://localhost:8983/solr/samplecollection/select?indent=on&q=*:*&wt=json in browser and your will see the search results:




Now, we will try to create the sample ASP.NET MVC project using Solr.NET to access the newly created Solr Core:


  • Create new ASP.NET MVC project and add the SolrNet package via “Manage NuGet Packages”
  • Create the Product model:
    using SolrNet.Attributes;
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    namespace CT.SC.Foundation.SolrIndexValidation.Models
    {
    public class Product
    {
    [SolrUniqueKey("id")]
    public string ID { get; set; }
    [SolrField("name")]
    public string Name { get; set; }
    }
    }
    view raw Product.cs hosted with ❤ by GitHub
  • Add logic to access the Solr Core via Solr.NET:
    public ActionResult Index()
    {
    List<Product> prodList = GetQuryData();
    return View(prodList);
    }
    public List<Product> GetQuryData()
    {
    Uri uri = new Uri("https://localhost:8983/solr/samplecollection/select?indent=on&q=*:*&wt=json");
    //--Used to bypass the Client Certificate to access the Solr instance
    System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate (object sender, X509Certificate certificate,
    X509Chain chain, SslPolicyErrors sslPolicyErrors) { return true; };
    WebRequest request = HttpWebRequest.Create(uri);
    request.Method = WebRequestMethods.Http.Get;
    WebResponse response = request.GetResponse();
    StreamReader reader = new StreamReader(response.GetResponseStream());
    string jsonResponse = reader.ReadToEnd();
    response.Close();
    JavaScriptSerializer serializer = new JavaScriptSerializer();
    dynamic jsonObject = serializer.Deserialize<dynamic>(jsonResponse);
    dynamic dd = jsonObject["response"]["docs"];
    List<Product> prodList = new List<Product>();
    Product prod;
    foreach (dynamic res in dd)
    {
    prod = new Product();
    try
    {
    if (res["id"] != null)
    {
    prod.ID = Convert.ToString(res["id"]);
    }
    if (res["name"] != null && res["name"][0] != null)
    {
    prod.Name = Convert.ToString(res["name"][0]);
    }
    }
    catch
    {
    }
    prodList.Add(prod);
    prod = null;
    }
    return prodList;
    }
    view raw HomeController.cs hosted with ❤ by GitHub
  • Now access the model in view to display required results from Solr instance:
    @{
    ViewBag.Title = "Home Page";
    }
    @using CT.SC.Foundation.SolrIndexValidation.Models
    @model List<Product>
    <div class="jumbotron">
    <h1>ASP.NET</h1>
    <p class="lead">ASP.NET is a free web framework for building great Web sites and Web applications using HTML, CSS and JavaScript.</p>
    <p><a href="https://asp.net" class="btn btn-primary btn-lg">Learn more &raquo;</a></p>
    </div>
    <div class="row">
    <div class="col-md-4">
    <h2>Response from </h2>https://localhost:8983/solr/samplecollection/select?indent=on&q=*:*&wt=json
    <p>
    <ul class="list-group list-group-flush">
    @foreach (Product prod in Model)
    {
    <li class="list-group-item">
    <h4>Id:</h4> @prod.ID <h4>Name:</h4> @prod.Name
    </li>
    }
    </ul>
    </p>
    </div>
    </div>
    view raw Index.cshtml hosted with ❤ by GitHub
The complete ASP.NET MVC code to verify the Solr connectivity present at https://github.com/AmitKumar-AK/CT.SC/tree/master/src/Foundation/Utilities/SolrIndexValidation

After executing the code, you will find the results from Solr core:


Now, we identified that, Solr instance accessible outside of Solr box from local system.

Next step is to deploy above created ASP.NET MVC application into Azure Web App and verify that it’s accessible or not. We can follow the link https://www.c-sharpcorner.com/article/deploy-asp-net-mvc-application-to-windows-azure/ to deploy ASP.NET MVC application into Azure. If Solr instance accessible from Azure Web App then it's mean there is no issue with the Solr.

Step-6: Validate name of the Sitecore cores in the Solr site if manually created
In the Step-1, we created the Sitecore Solr cores manually in Solr site and these name should be matched with Sitecore indexes name (which you can find via Showconfig.asxp in Sitecore).

By performing above steps, we found that there is no issue with Solr.

In the upcoming articles, we will verify the Solr Core's Schema and Sitecore instances (Content Delivery and Content Management) configuration files for Sitecore XP Single and XP Scaled topologies and will try to load the Solr indexes in the Sitecore Indexing Manager.

Note: In the above steps and code https://github.com/AmitKumar-AK/CT.SC/tree/master/src/Foundation/Utilities/SolrIndexValidation, please use your respective Sitecore , Solr installation folder and Solr Url.

  Sitecore Solr connectivity issue:
• Part-1 : Sitecore Solr connectivity issue details with ways to check the connectivity
• Part-2 : How to resolve Sitecore Solr connectivity in Sitecore XP Single Topology
• Part-3 : How to resolve Sitecore Solr connectivity in Sitecore XP Scaled/Distributed Topology

Comments

Post a Comment

Popular posts from this blog

Sitecore GraphQL Queries

Image
This article will provide the details about Sitecore GraphQL queries usage and how it will be useful in creating Sitecore projects especially Sitecore JSS projects. The topics covered under this Sitecore GraphQL article are: •    Overview of Sitecore GraphQL (GQL) •    Setup GraphQL (GQL) in Sitecore •    Usage of Sitecore GraphQL (GQL) in Sitecore JSS •    GraphQL (GQL) Queries Usage         o   Get an item by path and show field id and name       o   Return the name and value from all fields       o   Get the values of Treelist or Multilist field type       o   Get the template field details with values of current item       o   Get the field values using Aliases       o   Return a specific field with Alias ...
Read more

Sitecore Experience Edge GraphQL Queries

Image
The Headless development in Sitecore is powered by a layer of services, API endpoints, and rendering SDKs: Services and API endpoints Sitecore Headless Services Sitecore Experience Edge for XM Rendering SDKs Sitecore ASP.NET Rendering SDK Sitecore JavaScript Rendering SDKs (JSS) In this article, we will explore about Sitecore scalable API layer called Sitecore Experience Edge which provides you a Sitecore-hosted GraphQL (GQL) API. With these Edge GraphQL (GQL) endpoint you can build your solution in any language and pull the required content with the help of GraphQL (GQL) . The major GraphQL APIs of Sitecore Experience Edge are: Preview API Delivery API You can check more details about these APIs at Type of Sitecore Experience Edge API . GraphQL is a query language for these APIs t...
Read more

Configuring Sitecore Next.js Headless SXA Multisite App in a Sitecore Container

Image
Leading digital experience platform Sitecore offers strong capabilities for developing reliable websites and applications. The headless CMS and Jamstack architecture trends have been very popular in recent years. Sitecore provides Headless SXA (Sitecore Experience Accelerator) as a solution to decouple the front-end presentation layer from the content management capabilities since it recognizes the value of headless capabilities. In this article, we will guide you through the process of configuring a Sitecore Next.js multisite app and integrating it with Headless SXA in a Sitecore container. This setup allows you to leverage the benefits of Next.js, a popular React framework for server-side rendering, and the flexibility of Headless SXA for managing and delivering content. Table of Contents Step 1: Set Up the Sitecore Container Step 2: Add support for Sitecore SXA in Sitecore Headless Container setup St...
Read more