Octopus Tentacle Error - DLM-Automation not installed - Yet it is

Answers

• PeterG Redgate › Posts: 61 Silver 3

  July 5, 2018 8:46AM

  Hi Anthony,
  
  Sorry about that. We are currently working on a fix to the step templates that will address this issue. In the mean time you can modify the step template by going to Library > Step Templates and selecting our template for edit. Then replace the following line
  

  $dlmAutomationModule = Get-Module -ListAvailable -Name DLMAutomation

  with

  $dlmAutomationModule = Get-Module -ListAvailable -Name SQLChangeAutomation

  Peter Gerrard
  
  Software Engineer
  Redgate Software

  0 · Share on Twitter
• Ant Posts: 17 Bronze 1

  July 5, 2018 8:49AM

  Yep I eventualy found this, I also need to change the 
  

  Import-Module DLMAutomation

  to SQLChangeAutomation
  

  0 · Share on Twitter
• Ant Posts: 17 Bronze 1

  July 5, 2018 8:52AM

  Is there any way to change the template without ceating a copy?

  0 · Share on Twitter
• PeterG Redgate › Posts: 61 Silver 3

  July 5, 2018 9:18AM

  As it stands no. I was remembering this from an older version of Octopus.
  
  Aplogies.

  Peter Gerrard
  
  Software Engineer
  Redgate Software

  0 · Share on Twitter
• Ant Posts: 17 Bronze 1

  July 5, 2018 9:24AM

  I found a way to do it. 
  Update [dbo].[ActionTemplate]
  SET json = REPLACE (REPLACE([JSON],'Import-Module DLMAutomation','Import-Module SQLChangeManagement'),'Get-Module -ListAvailable -Name DLMAutomation','Get-Module -ListAvailable -Name SQLChangeManagement')
  where [Id] = 'ActionTemplates-1'
  

  0 · Share on Twitter
• PeterG Redgate › Posts: 61 Silver 3

  July 5, 2018 9:49AM

  That's great to hear. Hope it all works for you now.

  Peter Gerrard
  
  Software Engineer
  Redgate Software

  0 · Share on Twitter
• Ant Posts: 17 Bronze 1

  July 5, 2018 10:39AM

  Actual changes required are :
  Update [dbo].[DeploymentProcess]
  SET json = REPLACE (REPLACE(REPLACE([JSON],'Cannot find DLM Automation','Cannot find SQL Change Management'),'Import-Module DLMAutomation','Import-Module SqlChangeAutomation'),'Get-Module -ListAvailable -Name DLMAutomation','Get-Module -ListAvailable -Name SqlChangeAutomation')
  where [Id] = 'deploymentprocess-Projects-1'

  Update [dbo].[ActionTemplate]
  SET json = REPLACE (REPLACE(REPLACE([JSON],'Cannot find DLM Automation','Cannot find SQL Change Automation'),'Import-Module DLMAutomation','Import-Module SQLChangeAutomation'),'Get-Module -ListAvailable -Name DLMAutomation','Get-Module -ListAvailable -Name SQLChangeAutomation')
  where [Id] = 'ActionTemplates-1'
  

  0 · Share on Twitter