Hit another build error yesterday, this time on deployment of a DACPAC via WebDeploy: ##[error]Error Code: ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER More Information: The SQL provider cannot run with dacpac option because of a missing dependency. Please make sure that DacFx is installed. Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_DACFX_NEEDED_FOR_SQL_PROVIDER. Error count: 1. This one was pretty easy to troubleshoot and fix …
After seeing my code coverage was no longer being shown in SonarQube, I found the following error in my VSTest task log output when running on a private build agent. 2018-03-09T16:26:39.2215918Z Starting test execution, please wait…2018-03-09T16:26:39.7123032Z 2.33652018-03-09T16:26:39.7236043Z Data collector ‘Code Coverage’ message: Cannot find CodeCoverage.exe..2018-03-09T16:26:42.2546571Z NUnit Adapter 3.9.0.0: Test execution started I installed Agents for …
I recently created a new automated deployment for a SQL Server database using the SQLDeploy Nuget package. This was for a 7 year old SQL database which, as you could imagine, is fairly large/complex. I used the Schema Import SSDT feature to initially populate my Database Project in Visual Studio which worked great and pulled …
In trying to run some SQL scripts from within VS2017 today I noticed the SQL Results grid was super small! Ctrl scroll on the mouse or Ctrl + didn’t do anything in this particular window. It did help for the query window but nothing for the Results window. I was afraid this would either not …
VS2017 Quick Tip: Increase Font Sizes in the IDE Read More »
I setup a new build in VSTS this week and started receiving the following error during my CI build after adding a SQL Database project to my solution: (SPP-CreateDeployCommand target) -> MSDEPLOY : error Code: ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER [D:\a\1\s\myDatabase.csproj]MSDEPLOY : error count: 1. [D:\a\1\s\myDatabase.csproj] For deployment of my database I’m using the MSDeployAllTheThings.SqlDeploy Nuget package which creates …
ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER in VSTS Hosted Agent Read More »
Thanks to the generous help of MobesE46 on Github we now have better error handling in the MSDeployAllTheThings VSTS task. https://github.com/rschiefer/MSDeployAllTheThings/commit/73685976787236e45d6258bcbc85959299a75f84 Several users had reported the task was not failing when the MSDeploy.exe execution had errors. I have now tested and verified the task fails when MSDeploy.exe returns an error. I have updated the task …
I setup a new CI build with SonarQube analysis this week and noticed right off there were far more lines of code for the project than I was expecting. So I reviewed the code tree in SonarQube and noticed several very large third party JavaScript files were being included in the analysis like jQuery, bootstrap, …
SonarQube Quick Tip: Exclude Files from Analysis and Speedup Analysis Read More »
I’ve recently noticed the Test Explorer and runner in VS2017 is less stable and ends up stuck in a weird state where its trying to complete or cancel but it never does. This has been reported and I believe the team is working on it. It’s great that the Visual Studio team is so responsive …
VS2017 Test Explorer Hangs Workaround OR How to create an External Tool in Visual Studio Read More »
Today is sad day as it was my last as an employee with EBSCO Industries, Inc. EBSCO has been such a big part of my life so I thought it would be fun to reminisce about my time here in blog post form. I started with EBSCO over ten years ago as a junior .NET …
I noticed some CodedUI tests on some projects won’t work in Visual Studio 2017. It hasn’t been consistent so I’m not sure exactly when this occurs but this is the error I received: [1/3/2018 1:53:12 PM Warning] MSTestAdapter failed to discover tests in class ‘IntegrationTests.MyTests’ of assembly ‘D:\SourcePath\IntegrationTests\bin\Debug\MyTests.dll’. Reason Could not load file or assembly …