Markus' Blog

My thoughts and findings about Azure, Microsoft 365, SharePoint and SQL Server


Microsoft.Exchange. PswsClient.PswsException when trying to AutoApply a retention label with KQL

Published at December 10, 2019 ·  1 min read

​If you try to AutoApply a retention label using the Office 365 Security & Compliance Center you might get an error message if you use KQL (Keyword Query Language): This is because a KQL query for AutoApply only allows you to use certain “Queryable” Managed Properties. Some of them are listed here: https://docs.microsoft.com/en-us/microsoft-365/compliance/keyword-queries-and-search-conditions#searchable-site-properties But the Managed Properties in the article listed above are not the only ones. Although you cannot use custom Manged Properties (that are queryable), you can use the predefined ones like RefinableString00 etc....

ESPC 2019 Prague - Slides

Published at December 3, 2019 ·  1 min read

The slides of my presentation at ESPC 2019 in Prague about “What’s new in Microsoft Search” can be found here. Thank’s everyone for coming to the session! Markus...

Why you should use a really old SQL Compatibility Level for your SP2016 databases

Published at December 3, 2018 ·  1 min read

You might know, that the support policy for SharePoint and SQL Server has always been N, N-1, N+1 That means that for SharePoint 2016 the supported versions of SQL Server are SQL 2016 (N), SQL 2014 (N-1) and SQL 2017 (N+1) – which means a database compatibility level of 12 or higher. But when reading this knowledgebase article and Stefan Gossner’s blog, it turns out, that selecting a database compatibility level of 11 (SQL Server 2012) is beneficial for the performance of the SharePoint farm....

SPRequestDuration is back in SharePoint Online – kind of…

Published at April 4, 2018 ·  1 min read

When troubleshooting SharePoint (Online) performance issues, the SPIISLatency and SPRequestDuration headers are a very important part of the puzzle. Unfortunately, Microsoft removed those headers from SPO - honi soit qui mal y pense. Despite a few reappearances for a short time – I missed those headers every time when dealing with MS Support in SharePoint Online Performance Cases (https://sharepointinterface.com/2017/07/07/the-five-minute-page-performance-troubleshooting-guide-for-sharepoint-online/) But now, it looks like the performance figures are back – but depending on the UI you chose, in different flavors:...

Document Libraries not listed in dropdown when creating a Flow for SharePoint

Published at March 23, 2018 ·  1 min read

Microsoft took a big step forward when integrating Flow into SharePoint-Lists by allowing us to execute a flow on an existing SharePoint ListItem or Document. However, if you try to create a flow on a document by executing the following steps, the dropdown only shows Lists and no Libraries: So this dropdown is missing all the existing libraries and shows only Lists. Does this mean, that we can create a Flow on an existing ListItem only?...

Indexing .rtf files in SharePoint 2016

Published at July 20, 2017 ·  1 min read

Although Windows Server 2012 R2/2016 comes with an IFilter for .rtf-Files, SharePoint does not crawl/index .rtf files out of the box. The following article lists .rtf as a crawled filename, but it also states, that .rtf is not in the Managed File Types page by default: https://technet.microsoft.com/en-us/library/jj219530.aspx What happens when you add .rtf to the Managed File Type in the SharePoint Enterprise Search Service Application and Restart OSearch16? The file gets crawled, but with an error saying the file is “in a wrong format”....

SharePoint Virtual Summit – a summary

Published at May 16, 2017 ·  1 min read

Here’s a short summary of today’s SharePoint Virtual Summit: Extend Lists and Libraries with SPFx Modern Pages did not allow any customizations with JavaScript (eg. things we could do with jslink). With the new SharePoint Framework it will be possible SPFx – included in FP2 (fall) The SharePoint Framework will we included in Feature Pack 2 for SharePoint 2016, which is scheduled for fall 2017. Webhooks across sites and lists Until now, Webhooks in SharePoint Online are only available in Document libraries, now they will be extended to sites and lists....

Yes, there will be a new major version of SharePoint

Published at September 27, 2016 ·  1 min read

Today at Microsoft Ignite in Atlanta there were some interesting announcements during Bill Baer’s and Troy Starr’s session: There will be a new major version of SharePoint on-premises, MS is already working on it No more Service Packs: Updates are only delivered through Public Updates (PU, formerly called Uber-Cumulative-Updates), there will be no Service Pack for SharePoint 2016 Feature Packs will bring new functionality, the first one is scheduled for November, the second one for Q2 2017....

PSConfig error: The upgraded database schema doesn't match the TargetSchema

Published at June 16, 2016 ·  1 min read

When applying a Cumulative Update to your SharePoint 2016 Farm, you might run into troubles when executing PSConfig/PSConfigUI after installing the Binaries. The error that is logged in the Windows Event Log looks as follows: The Execute method of job definition Microsoft.SharePoint.Administration.SPUpgradeJobDefinition (ID ..) threw an exception. More information is included below. The upgraded database schema doesn’t match the TargetSchema. (Correlation=..) You can avoid this issue if you either dismount all the Content Databases before executing PSConfig/PSConfigUI (which is a good idea in larger environments anyway) and upgrade them later in a second step or upgrade all the Content Databases before executing PSConfig/PSConfigUI with something like Get-SPContentDatabase | Upgrade-SPContentDatabase....