Legal Notice
The opinions expressed herein are my own personal opinions and do not represent my employer’s view in anyway.Top Posts
- C# HttpClient POST or PUT Json with content type application/json
- C# get results from Task.WhenAll
- C# Get expiry timestamp from JWT token
- Run tasks in parallel using .NET Core, C# and async coding
- Handling "415 Unsupported Media Type" in .NET Core API
- Using C# HttpClient from Sync and Async code
- ASP.Net Core API - "'s' is an invalid start of a value. Path: $ | LineNumber: 0 | BytePositionInLine: 0."
Archive
Meta
Category Archives: Sitecore 7
Sitecore System.Data.DataException: Error executing SQL command: INSERT INTO [Properties] ( [Key], [Value] ) VALUES ( @name, @value ) —> System.Data.SqlClient.SqlException: String or binary data would be truncated
I just deployed, and now I cannot log in. Is it an error in the code? Or is it an error in data. Don’t worry, your login ticket just got messed up in the Properties table of the CORE database. … Continue reading
Posted in General .NET, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged login, Properties, SC_TICKET, Sitecore, System.Data.DataException
Leave a comment
Sitecore create custom Content Editor Warnings using Conditions and Rules
The Content Editor Warnings are these yellow boxes that hover over your content in the Content Editor in Sitecore: In the old days we would make them by hooking into the getContentEditorWarnings pipeline. Nowadays we use the Sitecore Rules engine. … Continue reading
Posted in c#, General .NET, Sitecore 5, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged Conditions, ContentEditorWarnings, RuleContext, rules, Sitecore, Warning, Yellow Box
Leave a comment
Sitecore poor Index Update performance linked to missing Index in the Links database
Suddenly my index updates took forever to finish. I mean, one index update would take 2 minutes. And I have a lot of index updates. A lot. UPDATE: 2022-01-19: Sitecore have suggested the same changes to the links database in … Continue reading
Posted in General .NET, Sitecore, Sitecore 5, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged index, Linkdatabase, links, Sitecore
2 Comments
Sitecore high CPU usage – is the SQL Session State Provider the villain?
My massive Sitecore 9.1 installation started having CPU spikes, even when the servers did not seem to receive more requests. When CPU spiked, I could see that the requests queue would build up, until it crashed with the following error: … Continue reading
Posted in Sitecore 7, Sitecore 8, Sitecore 9
Tagged Performance, Session state, Sitecore, SQL
Leave a comment
Sitecore publishItem pipeline – handling missing delete when publishing
When publishing items in Sitecore, the publishItem pipeline is called for each item that must be published, or unpublished. Except for children of items that have been deleted. Let’s take this example: If I publish the top item, the publishItem … Continue reading
Posted in c#, General .NET, Sitecore 7, Sitecore 8, Sitecore 9
Tagged Publish, publishItem, PublishItemProcessor, Sitecore
Leave a comment
Sitecore read from Custom Database
It is very easy to read from a custom database in your Sitecore code. STEP 1: ADD THE CONNECTIONSTRING TO CONNECTIONSTRINGS.CONFIG This is an example of a .config file that transforms the connection strings for existing Sitecore databases (like the … Continue reading
Posted in c#, General .NET, Sitecore, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged Configuration, Dapper, Sitecore, SQL
Leave a comment
Sitecore KeepLockAfterSave – Configuring Security Policies Per-Role Based
Now here is a nifty Sitecore trick. You have probably learned about the AutomaticLockOnSave feature that allows Sitecore to lock an item when it is saved. The feature is enabled or disabled using configuration setting (and can be negated with … Continue reading
Posted in Sitecore, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged KeepLockAfterSave, Locks, security, Sitecore
1 Comment
Sitecore ComputedIndexField extends your SOLR index
The Sitecore SOLR index is your quick access to Sitecore content. And you can extend this access by adding computed index fields. This is a way of enriching your searches with content that is not part of your Sitecore templates, … Continue reading
Posted in General .NET, Sitecore, Sitecore 5, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged Computed Index Field, Sitecore, SOLR
Leave a comment
Sitecore AccessResultCache cache is cleared by Sitecore.Caching.Generics.Cache`1+DefaultScavengeStrategy[[Sitecore.Caching.AccessResultCacheKey
Are you getting a lot of these messages in your Sitecore log: 6052 2021:03:25 05:23:12 WARN AccessResultCache cache is cleared by Sitecore.Caching.Generics.Cache`1+DefaultScavengeStrategy[[Sitecore.Caching.AccessResultCacheKey, Sitecore.Kernel, Version=11.1.0.0, Culture=neutral, PublicKeyToken=null]] strategy. Cache running size was xxx MB. This message can easily appear once every … Continue reading
Posted in Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged AccessResultCache, Performance, Sitecore
1 Comment
Sitecore LinkField TargetItem is NULL – what’s wrong?
An ancient topic, that pops up once or twice every year. The TargetItem of Sitecore.Data.Links.LinkField returns NULL and you are CERTAIN that the item is published. What to do? CASE 1: THERE IS SECURITY SET ON THE TARGETITEM Items where … Continue reading
Posted in .net, c#, General .NET, Sitecore, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9
Tagged LinkField, LinkManager, SecurityDisabler, Sitecore, TargetItem
Leave a comment