Questions tagged [indexing]
Questions about indexes in Sitecore (standard or custom) in general. For questions that apply to Lucene or Solr, use the appropriate tags.
293
questions
22
votes
5
answers
2k
views
What is the impact to a Sitecore instance while rebuilding the links database?
I am referring specifically the Links database, stored in the "Links" table, as defined here:
<!-- LINK DATABASE -->
<LinkDatabase type="Sitecore.Data.$(database).$(database)LinkDatabase,
...
- 2,996
14
votes
3
answers
3k
views
How to rebuild the analytics index without rebuilding the entire reporting database?
In Sitecore 8.1.3, is it possible to rebuild the analytics index without rebuilding the entire reporting database as specified in doc.sitecore.net?
I have an analytics index that is more or less ...
- 963
14
votes
4
answers
9k
views
Sitecore index update jobs getting stuck
I'm having trouble configuring a Sitecore 7.2 production environment and noticed some weird things on the CM environment..
After a few updates to the sitecore_master_index the jobs to update the ...
- 1,023
13
votes
4
answers
2k
views
What is the difference between an index and a search index
What is the difference between a regular index (e.g. sitecore_master_index) and a "search index"?
Why do I see certain indexes under the Indexing Manager in Control Panel, yet different ones under ...
- 4,154
13
votes
4
answers
5k
views
How to switch Lucene to Solr
We are planning on changing from Lucene to Solr due to number of items and because we have more than one CM server.
What are the steps needed to migrate default lucene indexes to Solr? Is it just a ...
- 1,782
13
votes
1
answer
2k
views
If I unpublish an item will Sitecore update the search index?
I have a Sitecore 8.1 / Solr 4.10 instance. I know that if I add a new content item or I delete a content item and then publish, that Sitecore is smart enough to do a partial rebuild of the Solr ...
- 3,359
12
votes
1
answer
3k
views
How does Sitecore decide the Index to use with GetIndex
A new index was added to a Sitecore instance I am working on. This ended up causing a different module in the implementation to have a problem. The part having an issue uses Sitecore.ContentSearch....
- 2,477
12
votes
2
answers
3k
views
Indexing jobs queued
On the CM server, all jobs are getting queued, after the following jobs appear in a running state:
UpdateIndex_filesystem Indexing Running False 08.11.2016 15:43:19 ...
- 121
11
votes
2
answers
1k
views
How can I reduce the size of the analytics index? [alt: Populating the Analytics Index]
I'm working with a customer right now that has seen their Solr implementation become unstable lately. Based on some initial analysis, signs are pointing towards the analytics index. They've been live ...
- 1,458
11
votes
2
answers
2k
views
Indexing PDF content with Solr error
I've been trying to get Solr configured right with Sitecore, but the one bit that's still causing background errors is indexing PDF content. I've been searching about and I'm not finding a clear-cut ...
- 5,082
10
votes
1
answer
2k
views
How do you programmatically exclude an item from being indexed?
We would like to exclude items from being indexed. Ideally, we want this control to be within Sitecore so that as new pages get created, content authors can determine whether to index them as they ...
- 4,821
10
votes
1
answer
954
views
Should indexes folder in data folder be removed every now and then?
We had some issue with Lucene not indexing properly. Usually with the removal of the indexes folder within data folder and rebuilding the indexes through Control Panel's Indexing Manager helps; ...
- 101
10
votes
2
answers
3k
views
Configuring master and web index for faster rebuild
During an upgrade from 6.x to 8.1 we decided to also move the indexes from Lucene to Solr. We ran into quite some troubles, but that is not the question as those are fixed. The "problem" I'm still ...
- 19.7k
9
votes
4
answers
6k
views
How does one verify that an item is properly indexed in Sitecore?
How do I figure out whether or not an item is indexed properly? Indexing depends on which tables in the Sitecore DBs?
When I search for an item in the search field, I am not able to fetch the item. ...
- 91
8
votes
3
answers
916
views
Lucene analytics index constantly loads HDD
We see performance issue on CM server. Content editor is very slow periodically and resource monitor shows that HDD is busy - reading and writing sitecore_analytics_index files nearly 50% of the time. ...
- 868
8
votes
2
answers
973
views
Lucene index corruption
I've had a serious problem with several clients while utilising a Lucene search index where anomalies like content missing that should be there or duplicate content (more than one document of the same ...
- 350
8
votes
1
answer
1k
views
Is it possible to get Azure Search to support EDM.GeographyPoint?
With regard to spatial searching capabilities of Azure Search in Sitecore. How do you go about customising your index configuration so that you can perform spatial searching using the OData geospatial ...
- 1,079
8
votes
1
answer
2k
views
Custom index configuration cannot work for Sitecore 9.0.1 in Azure
I got a trouble about custom index with Sitecore 9.0.1 in Azure. My custom index configuration can rebuild successfully and this index can create in Azure search with Sitecore 9.0.
After I changed to ...
- 361
8
votes
2
answers
1k
views
Issue with multiple crawlers on Solr custom search index
I have custom search Index(SOLR) which has two root locations defined, one points to /home node and another points to repository(videos), we also have indexing strategy(onPublishEndAsync) in place.
&...
7
votes
4
answers
3k
views
When and why to create a custom index
In my experience, the default sitecore_master_index and sitecore_web_index work pretty fast with Solr. We have around 1 million documents in the index and it returns a result in between 0 to 10ms. I ...
- 1,471
7
votes
3
answers
2k
views
Boost Solr query and prioritize exact match
I have few records in Solr index.
Bachelor of Nursing
Bachelor of Nursing (Honours)
My requirement is that when I want to search Bachelor of Nursing then Bachelor of Nursing should display first and ...
- 2,510
7
votes
2
answers
3k
views
How do I define a custom computed and tokenized field in my index?
I'm currently working in Sitecore 8.1. I would like to add a custom computed field to a specific index, and only that index. I have been able to add the field globally to Sitecore.ContentSearch.Lucene....
- 1,352
7
votes
4
answers
1k
views
Sitecore 7.2 Not rebuilding Lucene Index
We're using Sitecore 7.2 Update 4, and have 6 Lucene indexes across our sites in a single Sitecore instance.
In the production environment, but not locally or on staging, the web index is not rebuilt ...
- 961
7
votes
2
answers
1k
views
Azure Search indexes are not created
We are seeing a lot of Depenendy Failures in Application Insights because some non exisiting Azure Search indexes are queried.
The following indexes on Azure search return a 404:
sitecore-marketing-...
- 375
7
votes
1
answer
476
views
Performance Issue With Facets
We are having some performance issue when setting Datasources and Linking items in Sitecore 8.2. The test server just hangs when trying to expand a node in the dialog box. The CPU spikes to 100% and ...
- 71
6
votes
2
answers
2k
views
How to delete a Contact programmatically in xDB
Does anyone know how delete/remove a xDB Contact programmatically in Sitecore (8.1+), which also ensures a correct (re)-indexing?
Or, is there another strategy? Such as scrambling the identifier? - ...
- 83
6
votes
2
answers
359
views
How does Sitecore update a search index if there are no index update strategies configured?
The Sitecore docs list the available index update strategies, but there is no mention of what happens if no strategies are configured.
For example, would the index on the CD server for the following ...
- 2,996
6
votes
1
answer
2k
views
SOLR Custom Index Causing Error
I am converting a Lucene custom index to a SOLR custom index. I got the Cores working for the default indexes, but having trouble converting my custom indexes. I got through some of the issues, but ...
- 755
6
votes
1
answer
237
views
Using custom classes in LinqScratchPad.aspx
The problem
The default/sample code in the LinqScratchPad.aspx shows a TryYourOwnClass class. Sadly, this class is not used in any way in the sample.
The sample code looks like this:
namespace Test ...
- 275
6
votes
2
answers
12k
views
Value cannot be null. Parameter name: fieldNameTranslator - Opening Content Editor [closed]
I was trying to setup the Sitecore with Solr. I created the Default Instance and added Solr.
I use Castle Windsor as IOC, updated the Global.asax.
Since I was not able to download the Solr Support ...
- 627
6
votes
2
answers
502
views
Master index updated even though manual strategy is set
I have changed update strategy for Master database to be "manual" rather than "sync", which to my understanding should not update "master" when data changes in master database. I can see in crawling ...
- 353
6
votes
1
answer
1k
views
Large folder with images created on reindex: \App_Data\mediaIndexing
When reindexing on Sitecore 9.1, a folder with all the images is created ..\App_Data\mediaIndexing. My problem is that it gets very big in size, > 55GB of images in my case. Has anyone encountered ...
- 63
6
votes
1
answer
438
views
Field values are being fetched as null while reading the data with SolrContentSearchManager with Solr custom FlatDataCrawler
I'm busy creating a Crawler using FlatDataCrawler for custom non-sitecore data.
Inserting the data into Solr works, but when i'm reading the data with SolrContentSearchManager my entities are inserted ...
- 83
5
votes
3
answers
3k
views
Lucene indexing item url
I'm struggling to get the Sitecore item url from indexing, the SearchResultItem.url is always null.
I tried creating a ComputedField but I'm not getting the correct url.
With
Sitecore.Links....
- 201
5
votes
1
answer
2k
views
Fields Not Being Indexed in Lucene
I'm working with Sitecore 8.1. I have <indexAllFields>true</indexAllFields> in the <documentOptions> node of the DefaultIndexConfiguration.config file. When I open the index up in ...
- 1,352
5
votes
2
answers
1k
views
Combining multiple Items into one Document
Sitecore indexing works great for simple indexing scenario's, as the main working entity is a sitecore item. With computed fields you can add custom logic and fields for a record. But I have 2 more ...
- 543
5
votes
1
answer
2k
views
SwitchOnRebuild with SolrCloud not working
We are running Sitecore 9.0.0 (Initial Release) on Azure with SolrCloud (6.6.2) and getting close to go-live.
We are using Sitecore's SwitchOnRebuild functionality for indexing so that the indexes ...
- 2,632
5
votes
2
answers
498
views
Helix and Computed Index Fields with DI
In my solution, I have some Computed Index Fields that I need to add that combine the values of fields from templates that belong to multiple Project-layer modules. I am using DI for initializing my ...
- 8,899
5
votes
3
answers
2k
views
All search indexes missing
Recently created a Sitecore PaaS instance associating with Solr IaaS, The Index Manager Console looks to be empty. What is wrong here !
- 627
5
votes
2
answers
635
views
What is the correct root node for 'sitecore_marketingdefinitions_master' index?
I am working on a task to move a Sitecore installation search from Lucene to Solr on Sitecore version 8.2. I am using Solr version 5.1 as it is the recommended version for sitecore 8.2. All the other ...
- 1,024
5
votes
1
answer
613
views
Sitecore indexing commit policy Executor
There are several sitecore indexing commit policy executor like
Sitecore.ContentSearch.TimeIntervalCommitPolicy
and
Sitecore.ContentSearch.ModificationCountCommitPolicy
I want to know the ...
- 618
5
votes
2
answers
1k
views
Programmatically adding items to a custom Solr Index
I'm trying to add some items to a custom Sitecore Solr index Programmatically via the Sitecore Content Search APIs. The items I will add won't reside in Sitecore so the code below is just a test for ...
- 9,141
5
votes
1
answer
1k
views
How to configure Sitecore to index "everything but something" or "nothing but something"?
In one of the video from "Search Driven" module of Sitecore 9.0 Essential for Developers e-learning, the speaker says "You can configure Sitecore to index everything but something or nothing but ...
- 311
5
votes
1
answer
251
views
Sitecore Lucene indexing two versions of the same keyword
Here is the situation:
I have three items - Categories - Corporate, Financial and Product which I am using to categorize other items. They can be selected from a Droplink field (so Sitecore holds ID ...
- 2,681
5
votes
1
answer
4k
views
Solr multivalued fields
We are currently working on migrating from Lucene to Solr and we're having a couple of issues with our index data. There hasn't been any code changes so we're assuming it is stemming from the indexed ...
- 165
5
votes
2
answers
686
views
Issue with CD index not being updated after updating CM for Sitecore 8.1
I have the following setup
1 CM server
1 CD server
Sitecore 8.1
We have a custom Lucene index that is updating with no problem on our CM server but not on our CD server. I checked the logs and ...
- 59
5
votes
0
answers
1k
views
Sitecore Solr index FieldNameTranslator is null
I am currently playing around with Sitecore indexes - both Solr and Lucene.
I have made my own custom index and it works fine for Lucene, but I cannot get it to work with Solr.
My problem is that ...
- 101
5
votes
0
answers
687
views
Rebuild reporting database. Exception Message: String or binary data would be truncated
Sitecore 8.0 update 5
I've set up clean sitecore.analytics and sitecore.analytics_secondary databases.
Also I've deployed the Marketing Definitions and ran necessary SQL script to copy data from old ...
- 1,420
5
votes
1
answer
538
views
Sitecore multiple CD web databases publishing/indexing EventQueue database name
Say I have a single CM with 1x master db, 1x core db and 2x web dbs (2x publishing targets) for 2x CD servers in different regions. I can't call both web dbs "web" - one must be something ...
- 105
4
votes
2
answers
1k
views
How do I rebuild the Quick Search Index in Sitecore 8.2?
I've upgraded my solution from sitecore 8.1 Update 1 to Sitecore 8.2 initial release. After finishing the upgrade, and configuration changes, I opened the launchpad to rebuild Quick Search Index, I ...
- 372