Install DLM Automation extentions on TFS2018

Ivan2

Hi,
Is the current build extensions of DLM Automation supported in TFS2018?
I tried to install the extensions using market place, but get an error something went wrong.

I also downloaded the extensions from redgate, but when I try to install the extension I get the error below:

/04/2018 8:17:41 AM - Microsoft VSIX Installer

4/04/2018 8:17:41 AM - -------------------------------------------

4/04/2018 8:17:41 AM - vsixinstaller.exe version:

4/04/2018 8:17:41 AM - 15.6.152+ge95e4dd1ce

4/04/2018 8:17:41 AM - -------------------------------------------

4/04/2018 8:17:41 AM - Command line parameters:

4/04/2018 8:17:41 AM - C:\Program Files (x86)\Microsoft Visual Studio\Installer\resources\app\ServiceHub\Services\Microsoft.VisualStudio.Setup.Service\VSIXInstaller.exe,C:\Downloads\redgatesoftware.redgateDlmAutomationBuild-2.0.18.vsix

4/04/2018 8:17:41 AM - -------------------------------------------

4/04/2018 8:17:41 AM - Microsoft VSIX Installer

4/04/2018 8:17:41 AM - -------------------------------------------

4/04/2018 8:17:42 AM - Initializing Install...

4/04/2018 8:17:42 AM - Extension Details...

4/04/2018 8:17:42 AM - Identifier         : redgateDlmAutomationBuild

4/04/2018 8:17:42 AM - Name               : DLM Automation 2: Build

4/04/2018 8:17:42 AM - Author             : redgatesoftware

4/04/2018 8:17:42 AM - Version            : 2.0.18

4/04/2018 8:17:42 AM - Description        : Build and test databases with Redgate's DLM Automation

4/04/2018 8:17:42 AM - Locale             : en-US

4/04/2018 8:17:42 AM - MoreInfoURL        : 

4/04/2018 8:17:42 AM - InstalledByMSI     : False

4/04/2018 8:17:42 AM - SupportedFrameworkVersionRange : [0.0,2147483647.2147483647]

4/04/2018 8:17:42 AM - 

4/04/2018 8:17:42 AM - SignatureState     : Unsigned

4/04/2018 8:17:42 AM - Supported Products : 

4/04/2018 8:17:42 AM - Microsoft.VisualStudio.Services

4/04/2018 8:17:42 AM - Version : 

4/04/2018 8:17:42 AM - 

4/04/2018 8:17:42 AM - References         : 

4/04/2018 8:17:42 AM - Signature Details...

4/04/2018 8:17:42 AM - Extension is not signed.

4/04/2018 8:17:42 AM - 

4/04/2018 8:17:42 AM - Searching for applicable products...

4/04/2018 8:17:42 AM - Found installed product - Global Location

4/04/2018 8:17:42 AM - Found installed product - Visual Studio Professional 2017

4/04/2018 8:17:42 AM - VSIXInstaller.NoApplicableSKUsException: This extension is not installable on any currently installed products.

   at VSIXInstaller.App.GetInstallableData(String vsixPath, Boolean isRepairSupported, IEnumerable`1& skuData)

   at VSIXInstaller.App.Initialize(Boolean isRepairSupported)

   at VSIXInstaller.App.Initialize()

   at System.Threading.Tasks.Task`1.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()

Sergio R

Hi,

We have now updated our extension on the marketplace and this issue is resolved.
You can now update TFS using the current version from the marketplace.

Mike U

I'm pleased to say that the latest versions of the VSTS Build and Release addons on the marketplace will now work in TFS again. 

The root of the problem was that VSTS has a different size limit for extensions than TFS (26MB for VSTS vs 20MB for TFS). We've updated our extensions to obtain the DLM Automation module from the PowerShell Gallery rather than having the module embedded, which allows us to make them much smaller and avoid the TFS size limit. 

This does mean that if your build/release agents are running on machines that don't have PowerShell 5, or don't have access to the internet, you'll need to make sure that the latest version of DLM Automation is installed on the agent, using the SQL Toolbelt installer.

Hope that helps.

Scott_W

I am having the same issue when installing from the marketplace. Looking at the TFS event logs - found that the error was related to the extension size exceeding what is allowed in TFS.

I have emailed RedGate support with more info to see if they have a workaround. Was unable to find a way in TFS to increase the allowed extension size.

Sergio R

Hi,

This is indeed an issue with the size of the VSTS/TFS build plugin.

This works fine in VSTS but it is not possible to install in TFS.

If you have an older version and are trying to update, please stick with the older version for now.

If you are installing from fresh get in touch with product support, and we will provide you an older version at https://productsupport.red-gate.com/hc/en-us.

We are looking into this at the moment and expect to have a fix in the next few days.

Thank you,