Skip to content

Category: Sitecore

Database table location for aliases in Sitecore

Aliases in Sitecore can be found under the “SharedFields” table in the master and web databases.

FYI… I don’t recommend updating records via SQL as goes with any Sitecore data. You have to remember that there can be multiple versions of content. Use the content editor when you can.

Here is a sample query. This might not work for all cases.

select * from SharedFields sf
inner join Items i on i.id = sf.ItemId
where i.ParentID in (select ID from Items where Name = 'Aliases')
and sf.FieldId in (select ID from Items where Name = 'Linked item')

Leave a Comment

Visual Studio 2019 and Sitecore (Troubleshooting) error MSB4036: The “GetReferenceNearestTargetFrameworkTask” task was not found

I have a Sitecore solution built for 2017 but just recently got a fresh computer with only Visual Studio 2019 on it. So I’ve been running through some problems.

This was the error I was getting while running gulp to build the solution. I had installed the VS 2017 build tools earlier. Looks like you need to install the NuGet items as well.

C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\15.0\Bin\amd64\Microsoft.Common.CurrentVersion.targets(1657,5): error MSB4036: The “GetReferenceNearestTargetFrameworkTask” task was not found. Check the following: 1.) The name of the task in the project file is the same as the name of the task class. 2.) The task class is “public” and implements the Microsoft.Build.Framework.ITask interface. 3.) The task is correctly declared with in the project file, or in the *.tasks files located in the “C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\15.0\Bin\amd64” directory

Leave a Comment

Sitecore Fix – XConnect/Xdb – The certificate was not found

Exception: System.InvalidOperationException
Message: The certificate was not found.
Source: Sitecore.Xdb.Common.Web

Was getting this error continuly on a setup we had. Somehow the certificate thumbprint was not the same as the XConnect web application thumbprint.

The fix was to verify that the certificate thumbprint matched what the XConnect application was expecting.

To fix the problem

My Setup: Sitecore 9+, Windows 10 Pro

  • Find your XConnect Client certificate
    • Open MMC, click Add/Remove Snap-In
    • Choose Certificates from available snap-ins and click Add
    • In the next window select “Computer Account”, click next
      • If you don’t see “Computer Account”, you might have to open MMC with Administrator privileges
    • Select Local Computer
    • Click Finish, then OK
    • Navigate to Certificates (Local Computer) -> Personal -> Certificates
    • Double click your XConnect Client certificate
    • Click on the “Details” tab in the certificate window
    • Scroll down in the Field list to Thumbprint
  • Verify that XConnect Client certificate Thumbprint with your XConnect AppSettings.config file located under App_Config in your XConnect website location
    • Verify with this field validateCertificateThumbprint. They should match. If it does not, try and update it with the thumbprint from the XConnect Client Certificate.
    • If updating, restart you XConnect web app after you’ve made the changes
Leave a Comment

Sitecore Fix – XConnect/Xdb Unauthorized Error

Exception: Sitecore.XConnect.XdbCollectionUnavailableException
Message: The HTTP response was not successful: Unauthorized
Source: Sitecore.Xdb.Common.Web

Was getting the error above during our SSO process. The solution for me was changing the SSL settings in IIS for the xconnect website from Ignore to Accept.

1 Comment