All Posts

All Posts (560)

• 

  Published on

  2019-03-20 9:31 a.m.

  Authors

  koskila

  Tags

  AzureAzureFunctionsAzurePortal

  How to remove Azure Functions without deleting the Functions App?

  Have you ever run into a situation, where you just wanted to remove the currently standing function definitions from your app service without actually nuking the whole Functions app? I have! App Service configuration is usually easy to manage programmatically or by scripting, so even if you need to redo the deployment, it should be fairly straightforward.

  Read more →
• 

  Published on

  2019-03-19 11:13 a.m.

  Authors

  koskila

  Tags

  AspNetCoreEntityFrameworkCorePowerShell

  EntityFramework Core - Update-Database error “The EntityFramework package is not installed”

  Another weird, but simple issue I ran into when building a simple .NET Core application. The article should apply to pretty much any .NET Core version, but the version I was on was 2.2. I was just minding my own business, crafting bits of code into something remotely functional, when I ran into an issue. While trying to apply my changes to the database using .

  Read more →
• 

  Published on

  2019-03-11 10:38 a.m.

  Authors

  koskila

  Tags

  AzureAzureAD

  How to fix "AADSTS90008: The user or administrator has not consented to use the application"?

  A couple of days ago, I got a comment asking how to fix error AADSTS90008 when developing an application using Azure Active Directory The error in question was this: AADSTS90008: The user or administrator has not consented to use the application with ID ‘[guid]’. This happened because application is misconfigured: it must require access to Windows Azure Active Directory by specifying at least ‘Sign in and read user profile’ permission.

  Read more →
• 

  Published on

  2019-03-06 12:50 p.m.

  Authors

  koskila

  Tags

  EFMVCMVC5AspNet

  How to format DateTimes in ASP.NET Core?

  Have you ever struggled to make your ASP.NET MVC views format your properties of type DateTime correctly? I have. And I've been shot in the leg by weird hacks made by both myself (just 6 months earlier) and someone else. .NET Date/DateTime formatting is an endless bag of funsies in general . So I thought I'd finally document the different ways one can set up the formatting of DateTime fields in ASP.NET Core projects specifically. Or at least all the ways I've found so far!

  Read more →
• 

  Published on

  2019-02-27 10:38 a.m.

  Authors

  koskila

  Tags

  ChromeSPEditorGoogleChromeSharePointSharePointSearchQueryTool

  SharePoint Search Console - Now available inside Chrome SP Editor!

  This post is about two of my favorite tools: Chrome SP Editor, and SharePoint Search Query tool. Or maybe better yet, an amalgamation of the two! Description I've mentioned the Chrome SP Editor before, and for a good reason. It's a great tool for any IT Pro or Dev working with SharePoint on a daily basis. It's maintained by a very talented developer, one of the people behind Valo Intranet, Tomi Tavela . If you're using the tool, [let him know on Twitter!]( https://twitter.com/intent/tweet?

  Read more →
• 

  Published on

  2019-02-21 2:22 p.m.

  Authors

  koskila

  Tags

  AspNetCoreNuGetVisualStudio

  Resolving the Version conflicts for a downgraded .NET Core 2.1/2.2 web app project

  I ran into compatibility issues with .NET Core 2.2 on my Azure Functions projects, so I downgraded my whole solution (an Azure Functions project, a helpers library, and a web application project) to 2.1, and got rid of that particular nuisance. This introduced a few new issues, though - namely, I started getting this error whenever trying to restore nuget packages or build the project: NU1107 Version conflict detected for Microsoft.AspNetCore.Razor.Language. Install/reference Microsoft.

  Read more →
• 

  Published on

  2019-02-20 11:21 a.m.

  Authors

  koskila

  Tags

  MsSqlServerSqlQuery

  Easily querying all the database and log file sizes on SQL Server

  Quite often you get the need to simply quickly query all the database sizes on MS SQL Server. Most typically, for me, this need arises when a development machine gets low on disk space, and I need to check if some database's log size has been growing, or if something else is wrong. In my daily work, I rarely encounter this requirement anymore. Azure has almost entirely obliterated the need for such diagnostics, since it's so easy to spin up or scale up new development resources when need be.

  Read more →
• 

  Published on

  2019-02-13 10:18 p.m.

  Authors

  koskila

  Tags

  AspNetCoreEntityFrameworkCore

  Fixing "An assembly specified in the application dependencies manifest [projectname].deps.json was not found"

  This post describes one no-brainer fix to the error "An assembly specified in the application dependencies manifest [projectname].deps.json was not found." I ran into this while running Update-Database for my ASP.NET Core web project , that's using EntityFrameworkCore 2.1.1 . I hadn't seen this one before, but the error was quite interesting: Error: An assembly specified in the application dependencies manifest (Koskila.[projectname].AzureFunctions.deps.

  Read more →
• 

  Published on

  2019-02-06 1:10 p.m.

  Authors

  koskila

  Tags

  ModernSharePointSharePointTelemetrySharePointOnline

  What is "fp.js" - and why is it snooping on your SharePoint usage?

  Microsoft is gathering all kinds of telemetric data out of the usage of SharePoint. I ran into an interesting JavaScript file, fp.js , on SharePoint Online doing just that and gathering data. It loads on pretty much every single page request, so it's something you'll bump into any time you open your developer tools! Your customer's IT might even inquire about it - perhaps wanting to disable it for performance or information security gains. But what is fp.js and what does it do?

  Read more →
• 

  Published on

  2019-02-04 11:59 a.m.

  Authors

  koskila

  Tags

  AspNetCoreGoogleoauthOAuthAspNet

  Google Plus is shutting down - fix your .NET OAuth flow!

  Google is shutting down their Facebook killer, Google+. While I'm sure there are at least 10 end-users that are sad to see the ill-fated not-that-social-medium go, the implications for Software Developers actually could be far more far-reaching. A lot of implementations of Google's OAuth seem to rely on Google Plus's APIs to get gather information about the user. When Google Plus goes down, so will the APIs .

  Read more →
• 

  Published on

  2019-01-29 12:45 p.m.

  Authors

  koskila

  Tags

  PowerShellSharePointSharePointOnline

  Solving yet another "Microsoft.SharePoint.Client.ServerException: Unknown Error"

  There are a thousand possible things that can throw a "Microsoft.SharePoint.Client.ServerException", but fewer things, that are ambiguous enough to be called "Unknown error". This post describes one fairly usual fix for this issue! But let's get back to the beginning for a second - you get what and when now? When running any code, that provisions new sites (much like https://www.koskila.

  Read more →
• 

  Published on

  2019-01-28 10:44 a.m.

  Authors

  koskila

  Tags

  ChromeSPEditorHacktoberfest

  #Hacktoberfest 2018 - a fun way to encourage Open Source contributions!

  This post is about the Hacktoberfest event in 2018. I contributed to Microsoft's repositories and a couple of other ones - and it was a lot of fun! Wow - I'm quite behind on this post, but thought it's worthwhile to give credit where credit is due. Even if that credit comes woefully slowly! In 2018, Microsoft took part in DigitalOcean's Hacktoberfest -challenge.

  Read more →
• 

  Published on

  2019-01-24 11:54 a.m.

  Authors

  koskila

  Tags

  AzureAzureRMPowerShell

  Oh no! PowerShell cached my Azure credentials and I messed up wrong customer's environment!

  Whoops. This could happen to anyone since the Azure PowerShell (approximately) version 6.3.0 will cache your credentials between sessions without warning you. It's really easy to run your commands with cached accounts and end up executing your scripts against the wrong environment. In less serious cases, this means that you'll end up running commandlets twice against the test environment, while you think you're running them first against the test, and then production.

  Read more →
• 

  Published on

  2019-01-17 11:48 a.m.

  Authors

  koskila

  Tags

  PowerShellSharePointSharePointWebServicesSoap

  Fixing "-2147024891, System.UnauthorizedAccessException" when accessing SharePoint SOAP Web Services

  This article explains how to fix error 2147024891 (or sometimes -2147024891), "System.UnauthorizedAccessException" when accessing functionality in SharePoint that's built on top of SOAP Web Services. In a sense, we're delving into some legacy stuff - Microsoft has still kept SOAP-based SharePoint Web Services included in the product, since a lot of functionality has been built on top of them.

  Read more →
• 

  Published on

  2019-01-15 9:26 a.m.

  Authors

  koskila

  Tags

  PHPWordPress

  "500 Internal Server Error" after updating a WordPress site to PHP 7.3

  Now for something totally different - for a change, I got to fix an issue with my own blog, so I had the chance to delve into PHP and WordPress configurations... :) PHP is an ever-evolving language - even if it might not always feel that way. The old workhorse has been powering most of the internet for a couple of decades, and weirdly enough, doesn't really show signs of going anywhere.

  Read more →
• 

  Published on

  2019-01-09 8:52 a.m.

  Authors

  koskila

  Tags

  AzureAzureFunctionsDevEnvironment

  Azure Functions failing on "OPTIONS" call? Quick fix!

  I recently ran into an issue when developing Azure Functions locally. My SPFx webpart was configured to request information from my locally running Azure Function but suddenly started ending up in error. Browser only showed 404 for the first request (OPTIONS) the SPFx webpart was sending - although I knew the function was up and running! So what to do?

  Read more →
• 

  Published on

  2018-12-28 10:58 a.m.

  Authors

  koskila

  Tags

  BloggingWordPressYearReviewOpinion

  Thanks for an amazing 2018!

  The year 2018 is drawing to an end, and it's a good time for some reflection on what an interesting year it's been! Personally, quite a few things have happened in the last 12 months - I moved to Canada, started a new/old job, became a father, spoke at awesome events, and met a lot of cool people - just tons of awesome stuff. But personal things aside, 2018 has been an interesting and rewarding time to be writing this blog ! 2018 was the year when the site kind of took off.

  Read more →
• 

  Published on

  2018-12-18 11:02 a.m.

  Authors

  koskila

  Tags

  LicensingMicrosoftOneDriveOpinionM365

  The Scary Anatomy of a Microsoft License Fraud

  Note : While this was originally posted around the Christmas of 2018, and some company or seller names might not be relevant as scammers come and go, the principles in this blog post seem to be valid from the early 2000s to probably until 2038 (when the Internet ends due to the Epochalypse). For those of you, who don't want to read any extra fluff, let me just offer you this extra-short version of my article in FAQ form: Is Office 365 lifetime subscription a scam? Yes.

  Read more →
• 

  Published on

  2018-12-11 11:40 a.m.

  Authors

  koskila

  Tags

  PnPPowerShellPowerShellSharePointSharePointAdminSharePointAppCatalogSharePointOnline

  How to fix Add-PnPApp failing with an Access Denied error

  This was a peculiar case! An issue I hadn't run into before, and luckily a disturbingly simple fix. But first, let's set up the scene: We were running a long-ish PowerShell script using a Global Administrator account. One part of the script was supposed to add and deploy a couple of SharePoint apps. But while running Add-PnPApp , we ran into errors: Add-PnPApp -Path $path -Scope $app.Scope -ErrorAc… , Error: {"error":{"code":"-2147024891, System.

  Read more →
• 

  Published on

  2018-12-05 2:42 a.m.

  Authors

  koskila

  Tags

  ClassicSharePointPermissionsSharePointSharePointOnline

  Subsite creation in SharePoint fails with error 0x80070005 for any user (even global/farm admins!)

  This issue seems to pop up bafflingly often, so I thought that it was finally time to document it for future generations. Granted, it mainly considers Classic SharePoint (which is very tightly built around Publishing features) - but Classic is going to be part of our lives for quite a while still, especially for those of us still primarily on SharePoint Server!

  Read more →
• 

  Published on

  2018-11-29 9:59 a.m.

  Authors

  koskila

  Tags

  PnPPowerShellPowerShellSharePoint

  New-PnPSite fails with "SiteStatus" : 3?

  While running " New-PnPSite " (or actually any other site creation method in PowerShell or programmatically), the site creation fails, and instead you get back an error like the one below: New-PnPSite : {"d":{"Create":{"__metadata":{"type":"SP.Publishing.CommunicationSiteCreationResponse"}, "SiteStatus":3, "SiteUrl":""}}} Ouch! Where does this come from?

  Read more →
• 

  Published on

  2018-11-27 11:40 a.m.

  Authors

  koskila

  Tags

  SharePointSharePoint2016SharePoint2013SharePointOnlineSharePointSearch

  Issues with User Profile Property visibility in Search-powered functionalities

  This article applies to a lot of different issues you might be having with your SharePoint-powered site or even custom functionality like mobile apps using SharePoint's search index.

  Read more →
• 

  Published on

  2018-11-21 11:12 a.m.

  Authors

  koskila

  Tags

  MicrosoftSharePointSharePointSearch

  Bug: "PictureThumbnailURL" always null in SharePoint Online Search results

  This post describes the status of an ongoing issue in SharePoint Online, where the Managed Property "PictureThumbnailURL" will return null no matter what you do. This Managed Property is used for a few different use cases - most notably, Delve blog post's hero or header photo's URL is mapped to this property, as it's meant to be used as a thumbnail picture in a number of rollups.

  Read more →
• 

  Published on

  2018-11-14 9:11 a.m.

  Authors

  koskila

  Tags

  PowerShellExchangeOnlineOfficeGroups

  How to fix an Office Group with no Owners

  This post explains how to add new Owners to your Office Groups using PowerShell. If your group has ended up without any owners, PowerShell might even be the only option, since the graphical user interfaces for Office Groups management are not that good. Background The hype around Office Groups kind of died down a little bit a while back, since their role wasn't that clear - they didn't really do much, and were confusing for end users.

  Read more →
• 

  Published on

  2018-11-07 10:12 a.m.

  Authors

  koskila

  Tags

  SharePointSharePointOnline

  Help! My "Content and Structure" page in SharePoint Online is gone!

  First of all: you're right and your eyes are serving you well. It has indeed disappeared. Starting in October, it'll be hidden from end users. Microsoft is retiring the "Site Content and Structure" tool in SharePoint Online. Which kind of makes sense, since it's quite an old feature - albeit, a very useful one.

  Read more →