28 votes
Accepted

XConnect IndexWorker error "Tokens are incompatible, they have different set of shards."

Credit to Rob Earlam for helping me find the solution to this. Essentially, information about the shard databases is stored in the xdb index. If either the server or database name of your shards ...
Richard Szalay's user avatar
22 votes
Accepted

Install-SitecoreConfiguration xconnect-solr.json - Error Invoke-ManageSolrCoreTask : Missing required parameter: name

Maybe you are facing a problem with the SitecoreInstallationFramework version? Sitecore 9.0.X requires 1.2.1: Install-Module -Name SitecoreInstallFramework -RequiredVersion 1.2.1 Sitecore.9.1.0 ...
Tobi's user avatar
  • 354
20 votes

xConnect The HTTP response was not successful: Unauthorized

I've encountered the SAME EXACT PROBLEM on my local machine. Had to scratch my head for 2 days, had to also ask help from a colleague to also help; troubleshoot it together - 2 brains are better than ...
Marvin Glenn Lacuna's user avatar
18 votes
Accepted

access to the registry key 'Global' is denied

Add the IIS app pool user to the "Performance Monitor Users" & "Performance Log Users" groups, e.g: CMD> net localgroup "Performance Monitor Users" "IIS APPPOOL\sitecore" /add CMD> net ...
Joost's user avatar
  • 1,897
18 votes
Accepted

Clean Analytics in Sitecore 9

To clean the sql xdb database in Sitecore 9 you need to run bellow script in SQL on every shard that you have . USE [yourdatabaseprefix.Collection.ShardX] GO DELETE FROM [xdb_collection]....
Vlad Iobagiu's user avatar
  • 18.1k
17 votes
Accepted

Mongo vs SQL Server with Sitecore 9 Update 2

1) Infrastructure MongoDB will introduce new element into infrastructure of your solution. This increases cost of servers, cost of maintenance and at the end complicates the overall solution ...
Peter Procházka's user avatar
16 votes
Accepted

xconnect 9.0.2 can not connect to SQL server

The shard manager also keeps connection configuration in the [__ShardManagement].[ShardsGlobal] table of the ShardMapManager database. There is a ServerName, Port and DatabasName in there, so make ...
Jonne Kats's user avatar
15 votes
Accepted

xConnect The HTTP response was not successful: Unauthorized

UPDATE: Added mark's solution to help those looking for answers. I can think of a few possible reasons you are getting an unauthorized issue: Your thumbprint or certificate is not properly installed ...
Jason St-Cyr's user avatar
  • 6,696
14 votes
Accepted

Sitecore xConnect generating a JSON file for my custom model

After playing around a little i found out that you have to add some references to your Console application. These can all be found in the bin folder of your xConnect or Sitecore project: Newtonsoft....
mark DE Jong's user avatar
  • 1,001
14 votes

access to the registry key 'Global' is denied

I had to do the following steps to fix this issue. Open "Computer management" > "Local Users and Groups" > "Groups" > "Performance Monitor Users" > Now 'Add' the application pool user account (...
Harsh Baid's user avatar
  • 1,984
13 votes
Accepted

Copy of the certificate that the Azure Marketplace wizard generates?

No, you cannot download the certificate after the deployment. On the Summary page of the wizard you can read in red: Important Notice: This certificate will not be available for download at any ...
Tamas Varga Sitecore's user avatar
13 votes

Install-SitecoreConfiguration xconnect-solr.json - Error Invoke-ManageSolrCoreTask : Missing required parameter: name

Modify xconnect-solr.json and sitecore-solr.json Find the CreateCores task in each file Change the Name attribute in Params > Action to lowercase name Original Script { "Action": "Create", "...
Mohit Dharmadhikari's user avatar
12 votes
Accepted

xConnect WebApps on Azure PaaS not working

This issue happens because it is impossible to add self created certificate to the trusted list of Authorities in Azure as it is global thing. But for developers environment, we should be able to ...
Vlad Iobagiu's user avatar
  • 18.1k
12 votes
Accepted

Failed to start service Sitecore XConnect Search Indexer when installing Sitecore 9

The source of the issue is actually due to the License as hinted by the entry in the EventLogs. The Sitecore license being used is fine for our 8.0 implementation and even worked without issue ...
Jonathan Robbins's user avatar
11 votes
Accepted

Patching xConnect, AutomationEngine, IndexWorker configuration

You should be able to patch xml configuration files in the following way: Create patch config file with the name: sc.(patch name).xml Add the actual settings to patch: e.g. patch ...
grg's user avatar
  • 1,811
11 votes

Can I call the oData service directly in xConnect?

It turns out this is entirely possible. To access xConnect's oData api you have to create a Client Certificate Request. To test this out you can use Fiddler to use your client certificate: Go to IIS ...
Ian Graham's user avatar
  • 1,023
11 votes
Accepted

Getting exception "Sync token is no longer valid for [Contacts] / [Interactions] table" with xConnect Search Indexer

The indexer can no longer figure out all the changes saved to xConnect while it was down. This is why rebuilding the index is the only option at this point. ——— Full context: if you are using SQL ...
eglasius's user avatar
  • 446
11 votes
Accepted

Use XConnect without certificates (for development)?

Just remove or disable these two files: \App_Data\Config\sitecore\CoreServices\sc.XConnect.Security.EnforceSSL.xml \App_Data\Config\sitecore\CoreServices\sc.XConnect.Security....
Roman Klimenko's user avatar
11 votes
Accepted

xConnect 100% CPU for hours

TLDR; When you site throws an error, for some reason Sitecore stuffs the error into xConnect as an interaction. Sometimes these errors are so large, it takes so much CPU to deserialize them, that it ...
Chris Auer's user avatar
  • 13.1k
10 votes

Can I call the oData service directly in xConnect?

I think it is possible. You need to pass correct certificate on the following line: >CertificateWebRequestHandlerModifierOptions.Parse("StoreName=My;StoreLocation=LocalMachine;FindType=...
Vlad Iobagiu's user avatar
  • 18.1k
10 votes
Accepted

The type or namespace name 'Configuration' does not exist in the namespace 'Sitecore.XConnect.Client'

After adding Sitecore.XConnect.Client.Configuration dll from nuget package has resolved my issue which helps in creating Xconnect client object in sitecore context. Sitecore.XConnect.Client....
Sudheer Suggu's user avatar
10 votes
Accepted

Xdb.Collection.Shard0 Login failed for user

The Xdb.Collection.ShardMapManager database defines the shards settings for each shard map in the __ShardManagement.ShardsGlobal table. You will need to update the ServerName field in each record ...
Alessandro Faniuolo's user avatar
9 votes
Accepted

Issues with XConnect certificate does not contain Private Key

Differently from XP1, the XP0 topology has a JSON file specifically for create the certificate - xconnect-createcert.json After creating the certificate using xconnect-createcert.json, I have tried ...
Vinicius Deschamps's user avatar
9 votes

Getting exception "Sync token is no longer valid for [Contacts] / [Interactions] table" with xConnect Search Indexer

I ran into this a while ago but could not figure out how to fix it without a full reinstall. However, recently @ezlateva and @jflarente figured out that you can fix this issue with an index rebuild of ...
Jason St-Cyr's user avatar
  • 6,696
9 votes

Display custom facets in Sitecore Experience Profile version 9 or later

I do this using Experience Profile Express Tab code. It allows you to add a custom tab to the contact in experience profile. Then you just load your facet into it. You can put anything in the model. ...
Chris Auer's user avatar
  • 13.1k
8 votes
Accepted

Switch xDB Search indexes from SOLR to Azure Search

Ensure that IndexWorker service is updated in the same way as xConnect site was: Stop IndexWorker windows service. Disable all SOLR configs in IndexWorker and enable all AzureSearch configs under ...
grg's user avatar
  • 1,811
8 votes

How to configure multiple processing servers

You should introduce load balancer that will serve as "point of contact" for CM server. It's URL will be used as ServiceUrl on CM server. Your two processing servers will be behind it and load ...
Peter Procházka's user avatar
8 votes

XConnect IndexWorker error "Tokens are incompatible, they have different set of shards."

In case this error persists, even after you rebuild the XDB index, you might as well want to check the items under /sitecore/system/List Manager/ListOperations node. These items are created by the ...
João Neto's user avatar
  • 2,051
8 votes
Accepted

NotSupportedException - Search operation not supported with xConnect collection-only configuration

I ended up finding the solution - there was never an issue with the XConnect instance, but with the configuration on the CD Sitecore instance. The issue is that by default, Content Delivery servers ...
Paradoxvoid's user avatar
8 votes
Accepted

Configure Azure search for Sitecore xConnect

Enabling Azure Search To use xConnect and IndexWorker with Azure Search you need to do a couple of things: Create Azure Search service in your Azure subscription. Copy the service key which will be ...
grg's user avatar
  • 1,811

Only top scored, non community-wiki answers of a minimum length are eligible