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 ...
- 2,202
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 ...
- 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 ...
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 ...
- 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]....
- 18.2k
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 ...
- 9,386
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 ...
- 781
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 ...
- 6,751
15
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 (...
- 1,994
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....
- 1,001
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 ...
- 5,653
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", "...
- 1,676
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 ...
- 18.2k
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 ...
- 576
12
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 ...
- 456
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 ...
- 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 ...
- 1,023
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....
- 321
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 ...
- 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=...
- 18.2k
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....
- 834
10
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 ...
- 6,751
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 ...
- 2,574
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 ...
- 2,979
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. ...
- 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 ...
- 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 ...
- 9,386
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 ...
- 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 ...
- 141
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 ...
- 1,811
Only top scored, non community-wiki answers of a minimum length are eligible