Visual Studio – Build – Warning – “The referenced component ‘Microsoft.Web.Infrastructure’ could not be found.”

Background

Downloaded a new Application.  One that I will have to build myself.

Launched Visual Studio and issued Build Command via menu.

Error

Ran into build errors.

The first one reads:

The referenced component ‘Microsoft.Web.Infrastructure’ could not be found.

Remediation

Have a lot of work to do this Saturday morning.

And, so let us address.

Package Manager Console

Running Visual Studio 2017 Community Edition, and the steps to access the Package Manager Console are:

  1. Navigate to the top menu
  2.  Menu Item
    • Tools
    • NuGet Package Manger
    • Package Manager Console

 

Install-Package

Code


Install-Package Microsoft.Web.Infrastructure

 

 

Output

Image

Textual
Attempting to gather dependency information for package 'Microsoft.Web.Infrastructure.1.0.0' with respect to project '[ProjectA]', targeting '.NETFramework,Version=v4.5.1'
Gathering dependency information took 120.25 ms
Attempting to resolve dependencies for package 'Microsoft.Web.Infrastructure.1.0.0' with DependencyBehavior 'Lowest'
Resolving dependency information took 0 ms
Resolving actions to install package 'Microsoft.Web.Infrastructure.1.0.0'
Resolved actions to install package 'Microsoft.Web.Infrastructure.1.0.0'
Retrieving package 'Microsoft.Web.Infrastructure 1.0.0' from 'nuget.org'.
Adding package 'Microsoft.Web.Infrastructure.1.0.0' to folder '<app>\\packages'
Added package 'Microsoft.Web.Infrastructure.1.0.0' to folder '<app>\\packages'
Added package 'Microsoft.Web.Infrastructure.1.0.0' to 'packages.config'
Successfully installed 'Microsoft.Web.Infrastructure 1.0.0' to <ProjectA>
Executing nuget actions took 5.42 sec
Time Elapsed: 00:00:07.5704133
PM> 

Credit

Crediting Joshua Davis per “FileNotFoundException: Could not load file or assembly ‘Microsoft.Web.Infrastructure“.  Here is the Link.

Joshua Davis’s about page is worthy of good, congratulatory read.  Here is the link to that page.

 

References

  1. NuGet.Org
    • Microsoft.Web.Infrastructure 1.0.0
      • This package contains the Microsoft.Web.Infrastructure assembly that lets you dynamically register HTTP modules at run time.
        Link
  2. fsprojects/Paket
    • Problem referencing Microsoft.Web.Infrastructure #1393
      Link

Visual Studio – Error – “Unable to find manifest signing certificate in the certificate store”

Background

Downloaded Source Code of an Application that I will be using, but unable to successfully compile it.

Error

Error Message

Error
Unable to find manifest signing certificate in the certificate store
Unable to find code signing certificate in the current user’s Windows certificate store.

Error Image

TroubleShooting

pfx file Missing

Solution Explorer

DiagManager

Image

Explanation
File Diagnosis
DiagManager_TemporaryKey.pfx DiagManager_TemporaryKey.pfx file is missing

 

Remediation

Project \ Signing

Uncheck “Sign the ClickOnce manifests

Summary

ClickOnce requires code signing.

As Microsoft is availing the Source code, they have opted not to include their PFX file.

References

  1. StackOverflow.com
    • Why am I getting “Unable to find manifest signing certificate in the certificate store” in my Excel Addin?
      Link

Visual Studio Community 2017 – Upgrading

Background

The lead developer on one of our projects experienced problems deploying a report yesterday evening.

It is time to see if we can duplicate and thus research the error.

 

SQL Server Data Tools

SQL Server Data Tools – v2015

Downloaded SQL Server Data Tools (SSDT) v2015 from here.

Was able to successfully install and deploy the report.

 

SQL Server Data Tools – v2017

Download

From same link, downloaded SSDT v2017.

Install

Prerequisite

Visual Studio 2017

Blocking Issue
Textual

The current installation requires Visual Studio 2017 version number 15.3.0 or higher.  Please upgrade your Visual Studio instance before continuing the setup.

Image

 

Validate v2017

Launched our installed v2017 and validated the Version # is 15.2 (26430.15 )

Image

Textual

Microsoft Visual Studio Community 2017
Version 15.2 (26430.15) Release
VisualStudio.15.Release/15.2.0+26430.15
Microsoft .NET Framework
Version 4.7.02053

Review Visual Studio 2017 Packages

Let us quickly review Visual Studio ( VS) 2017 Release History

Image

Explanation
  1. v15.2
    • We have v15.2, released on May 10th, 2017
  2. v15.3
    • We need at least 15.3, released on August 14th, 2017
  3. v15.4.3
    • The latest as of today, 2017-Nov-9th, is v15.4.3
Download Visual Studio 2017 – Bootstrapper

We will to “Install Visual Studio 2017 on low bandwidth or unreliable network environments” ( here  )and reach for the Bootstrapper community edition.

The direct link to Community edition is here.

 

Create an offline installer

Let us create an offline installer


set "_target=C:\VS2017offline"
set "_desktop=Microsoft.VisualStudio.Workload.ManagedDesktop"
set "_netWeb=Microsoft.VisualStudio.Workload.NetWeb"
set "_github=Component.GitHub.VisualStudio"

vs_community.exe --layout %_target% --add %_desktop% --add %_netWeb%  --add %_github% --includeOptional --lang en-US

 

Build offline installer

Run the batch file created earlier to build the offline installer.

Image – Invoke batch file

Image – download…

Image – Successful
Patch Visual Studio 2017

Let us patch our installed v2017

Run the setup.exe availed through the offline installer.

Image – 1

Update available

Visual Studio 2017 is already installed.

Click update to update to version 15.4.3

 

Image – 2

Image – 3

 

Image – 4

 

Image – 5

 

Validate Visual Studio 2017 Version

Launch Visual and validated that v2017 is installed.

 

Install

Steps

Let us go back and try to install SQL Server Data Tools – Release 15.4.0 Preview

Install Tools to this Visual Studio 2017 instance

 

References

  1. Microsoft
    • Docs / SQL / SSDT ( SQL Server Data Tools )
      • Download SQL Server Data Tools ( SSDT )
        Link
    • Docs / Visual Studio / Documentation / Installation
      • Install Visual Studio 2017 on low bandwidth or unreliable network environments
        Link
      • Create an offline installation of Visual Studio 2017
        Link
    • VisualStudio.com
      • Visual Studio 2017 version 15.4 Release Notes
        Link

SQL Server Mini Dump Files – Day 01

Background

Received an alert indicating that one of our database jobs is lagging.

TroubleShooting

Adam Machanic

sp_whoisActive

Ran Adam Machanic’s sp_whoIsActive ..

And, noticed that a couple of Restore Transaction Log sessions have been running for 6 to 7 hours.

SQL Server – Error Log Folder

Reviewed the errorlog folder and noticed a couple of mdmp files.

 

Secure mdmp files

Secured the mdmp files and copied them locally to my machine.

Visual Studio

Visual Studio Community Edition 2017

About

Have a copy of the free community edition of SQL Server 2017.

Launched it.

Access mdmp files

Using menu item File \ File Open accessed the “Open File” window.

For file types chose “Dump files ( dmp, mdmp )

Dump – SQLDump0065.mdmp

Image

Explanation
  1. Process Information :- E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
    • MSSQL12.MSSQLSERVER
      • Version :- MS SQL Server v2014
  2. Process Architecture :- x64
  3. Exception Code :- 0xC0000005
  4. Exception Information :- The thread tried to read or write to a virtual address for which it does not have the appropriate access.

 

Dump – SQLDump0066.mdmp

Image

Explanation
  1. Process Information :- E:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
    • MSSQL12.MSSQLSERVER
      • Version :- MS SQL Server v2014
  2. Process Architecture :- x64
  3. Exception Code :- 0x000042AC
  4. Exception Information :- {blank}

 

Summary

Quick Points here:

  1. Alerts & Notifications
    • Have alerts and notifications on jobs
    • Have them set up to email a distribution list or yourself
    • Need and have a smart phone
  2. TroubleShoot
    • Prepare and have diagnostic checklist & steps
    • Review Error Logs
    • Dump Files?
      • If dump files are being generated, analyze them

 

Reference

  1. Microsoft
    • Windows Development Center
      • DirectX Graphics and Gaming > Classic DirectX Graphics > Technical Articles
        • Crash Dump Analysis
          Link
    • SQL Server Customer Advisory Team
      • Thomas Kejser
        • Looking deeper into SQL Server using Minidumps
          Link

UML & Visual Studio

Background

My brother has a couple of Applications that he wanted to generate UML Models for.

And, so went online and downloaded both the Community ( Actual ) and Enterprise Edition ( Trial ).

 

Download

The latest version v2017, is available here.

Installed

Installed both versions.

And, was surprised that access to UML is no longer available under the Architecture menu.

Missed Functionality

UML to be ejected from Microsoft Visual Studio
Link

Not Supported post Visual Studio 2015 …

Stay with Visual Studio 2015

 

References

  1. Infoworld
    • Paul Krill
      • UML to be ejected from Microsoft Visual Studio
        Link
  2. Microsoft Developer Community
    • UML use case diagram in vs2017 RC Enterprise Edition
      Link
  3. Microsoft Developer Network
    • Create UML Class Diagrams from Code
      Link