DotNet ‘XmlDocumentFragment’ is missing

If you still use dotnet for legacy reasons for example in Business Central. You could encounter this issue in VS Code when building your app:

DotNet ‘XmlDocumentFragment’ is missing

This class is part of the System.Xml namespace and represents a lightweight object for tree insert operation. See all the info on Microsoft Docs: https://docs.microsoft.com/en-us/dotnet/api/system.xml.xmldocument.createdocumentfragment?view=netframework-4.8

In order to fix this in AL you need to do the following steps:

• Setup and configure Assembly Probing Paths in VS Code Workspace Settings
• Create a dotnet.al file in your AL Project. This file should now hold the following Json structure and contents:

dotnet
{
    assembly("System.Xml")
    {
        Version = '4.0.0.0';
        Culture = 'neutral';
        PublicKeyToken = 'b77a5c561934e089';

        type("System.Xml.XmlDocumentFragment"; "XmlDocumentFragment")
        {
        }
    }
}

DotNet ‘HttpUtility’ is missing (AL0185)

If you still use dotnet for legacy reasons for example in Business Central. You could encounter this issue in VS Code when building your app:

DotNet ‘HttpUtility’ is missing

This class is part of the System.Web namespace and is used to encoding or decode URL’s. In order to fix this in AL you need to do the following steps:

• Setup and configure Assembly Probing Paths in VS Code Workspace Settings
• Create a dotnet.al file in your AL Project. This file should now hold the following Json structure and contents:

dotnet
 {
     assembly("System.Web")
     {
         Version = '4.0.0.0';
         Culture = 'neutral';
         PublicKeyToken = 'b03f5f7f11d50a3a';
         type("System.Web.HttpUtility"; "HttpUtility")
         { } 
     } 
 }

It took me some time to sort this out and by sharing this post this will save you some time if you encounter an issue similar.

KB2919355 Installation failed during SQL Server 2016 Installation

A while ago I was setting up a new Nav envrionment and got this error during the installation of SQL Server 2016 (Developer Edition) installation on Windows 2012 R2:

KB2919355 Installation failed (Validation Failed)

Rule “KB2919355 Installation” failed.

---

Rule “KB2919355 Installation” failed.
KB2919355 Check Failed. If you have installed KB2919355, please make sure you have restarted your machine. For more information, you can visit https://support.microsoft.com/kb/2919355/

In order to fix this just install these updates and SQL 2016 Developer Edition will install without problems.

• First: Windows8.1-KB2919442-x64 Download from https://www.microsoft.com/en-us/download/details.aspx?id=42153 Microsoft 2228
• Final: Windows8.1-KB2919355-x64 Download from https://www.microsoft.com/en-us/download/details.aspx?id=42334 (this one is quite an extensive download and takes about 10 minutes to install completely)

I thought it was worth sharing this ‘tip’ in order to save valuable time for you and myself ofcourse in the main future if you encounter this issue (again). So blogging about this will also help to document this issue and the quick solution ofcourse!