Sitecore 9 XP0 installation Tips -Sitecore.XConnect.XdbCollectionUnavailableException

-

Create the Self-signed certificate for XConnect

$thumbprint = (New-SelfSignedCertificate `
-Subject "CN=xConnectsc9DemoCert" `
-Type SSLServerAuthentication `
-FriendlyName "xConnectsc9DemoCertificate").Thumbprint
#export certificate with password
$certificateFilePath = "C:\certificates\$thumbprint.pfx"
Export-PfxCertificate `
-cert cert:\LocalMachine\MY\$thumbprint `
-FilePath "$certificateFilePath" `
-Password (Read-Host -Prompt "Enter password that would protect the certificate" -AsSecureString)
#convert it to base64 string (blob)
$fileContentBytes = get-content $certificateFilePath -Encoding Byte
[System.Convert]::ToBase64String($fileContentBytes) | Out-File "C:\certificates\$thumbprint.txt"
Write-Host "Your secure certificate blob is located at C:\certificates\$thumbprint.txt"

Xconnect Certificate Issue:(Sitecore.XConnect.XdbCollectionUnavailableException)
  • Provide IIS Apppool\Sitename, NETWORK SERVICE, and IIS_IUSRS to have access to the certificate


  • Update the IIS Sitecore site to use NETWORK SERVICE Account 
  • Run the following script in SQL server bu using a new query window and update its query to use SQLCMD mode
  • Check IIS Xconnect site assigned SSL certificate, Also verify all the configuration files like(Sitecore Site's ConnectionString.config, Xconnect Site's ConnectionString.config and Appsettings.config) updated with the certificate thumbprint(It is usually by the name "XP0.Xconnect_Client")
  • Use PowerShell command to check all non-self-signed certificates in your root store                    Get-Childitem cert:\LocalMachine\root -Recurse | Where-Object {$_.Issuer -ne $_.Subject}
  • Use this PowerShell command moves the offending certificates above into the Intermediate Certification Authorities (i.e. CA) store:                                                                                            Get-Childitem cert:\LocalMachine\root -Recurse | Where-Object {$_.Issuer -ne $_.Subject} | Move-Item -Destination Cert:\LocalMachine\CA
  • Add the below setting to Xconnect Site's ConnectionString.config
  Thumbprint of the certificate(Site9.xconnect_client):        BA708848B2041305894B235050EBC7AC267510AE                                
<add name="xconnect.collection.certificate" connectionString="StoreName=My;StoreLocation=LocalMachine;FindType=FindByThumbprint;FindValue=BA708848B2041305894B235050EBC7AC267510AE;AllowInvalidClientCertificates=true" />
<add name="xdb.referencedata.client.certificate" connectionString="StoreName=My;StoreLocation=LocalMachine;FindType=FindByThumbprint;FindValue=BA708848B2041305894B235050EBC7AC267510AE;AllowInvalidClientCertificates=true" />



Comments

Post a Comment

Popular posts from this blog

Custom Item Url and resolving the item in Sitecore - Buckets

-
Image
I have a situation to update the Item URL to be SEO friendly as my items in content tree looks like below. In the above image in order to resolve the item, Sitecore will find the item from the below URL http://domainname/en/dine/nv/chicken but I need to form a URL that is more SEO friendly like http://domainname/en/chicken In Sitecore by Out of box, we can achieve this by using Aliases , we can create an Aliases under System à Aliases and in the Linked Item field select the target item. But this is very tedious as we need to go to every item in the content tree and create Aliases, instead of that we will be going to do it programmatically using custom pipelines. ·          Link Provider (Provides the custom URL for the item based on the templates) ·          Item Resolver (Resolves the item based on the custom URL generated by CustomLinkProvider , that we going to create later...
Read more

Fixing Sitecore Buckets folder path - Items created after 12 AM server time zone

-
Image
We are working on a 24/7 content publishing site, so it is important to have articles published on the correct date and time.  We are using Sitecore buckets to manage article items. In the Sitecore content tree, when the content author tries to look at the items created after 12 AM server time, the items are created under the previous day folder only,  but it is supposed to be created in the current day folder( ie. new bucket day folder to be created and the items to be added in this new day folder ). We have hosted the site in Azure VM in the UAE region. UAE is 4 hours ahead of GMT/UTC (UTC+04:00) so items created between 12 AM to 4 AM are always created under the previous day's folder, but when the item created after 4 AM is properly created under the current day folder in the content tree. Example: If the item was created on 2024 à 09 à 24 between 12 AM to 4 AM then still the item is made under the bucket folder of 2024 à 09 à 23 The created date and the updated ...
Read more

Sitecore Search - API Crawler with Edge Pagination

-
Image
Sitecore Search provides different ways to index the items from 3rd party systems with the help of Source Connectors. There are different types of Source Connectors available: API Crawler API Push Feed Crawler Web Crawler Web Crawler(Advanced) I have provided more details here about the different sources for crawling different types of documents to get indexed into Sitecore Search. In this article, I would like to share the details about API Crawler in more real-time querying data and adding to the index. We have a scenario where I need to index all the items along with their placeholder components based on a specific template that has a layout assigned to it. I decided to utilize the Experience EDGE GraphQL Query to get the data and index it to Sitecore Search. We can use this for non-layout items as well. This article covers the following: GraphQL - Layout Query with Components GraphQL - Item Query GraphQL - Item Query with Pagination GraphQL - Search Query with Pagination Graph...
Read more