Close

Logic App error using workflow parameters

I received the following error when deploying a Logic App via Powershell/ARM: InvalidTemplate. Unable to process template language expressions in action ‘HTTP’ inputs at line ‘1’ and column ‘1420’: ‘The workflow parameter ‘ahakStorageConnectorName’ is not found.’. At the top of the Logic App Json file, I defined the parameters. The parameter values were contained in…

Deploy Logic App using Powershell and ARM

To deploy a logic app via Powershell, I used the following approach; Create a directory structure with two folders, i.e.: C:\Sources\PBaars\Deployment\Release1.5\AAA-DeployResources C:\Sources\PBaars\Deployment\Release1.5\ProcessPlanning Folder AAA-DeployResources contains reusable artefacts like a parameter file and a Powershell module with reusable code. In this case the reusable code uploads files for a Web App or API App to a…

SQL query in Powershell

For security reasons I only had access to the BizTalk Server, not to the SQL Server. I know I can also install SQL Server Management Studio on the BizTalk Server, but there’s another way by using Powershell. First  you will have to install the PowerShell module for SQL Server, that is: SQLPS.  You can download…

Call Powershell script from command file

Just another gotcha. I have a command file Kw1c_Build.cmd that calls a Powershell script Kw1c_Build.ps1. The command file has the following code: @Echo Off Echo Changing PowerShell Execution policy… powershell Get-ExecutionPolicy powershell Set-ExecutionPolicy Unrestricted powershell %~dpn0.ps1 pause What’s important to know, is that %~dpn0 returns the Drive, Path and Name of the currently executing script.…

Powershell Settingsfile

In a Powershell (.ps) script, you can use settings from a settings file. In this case we have a Powershell script Functions_Build.ps1 which uses a settings file Settings_BuildEnvironment.csv. You can use the following code in your PowerShell script: Set-ExecutionPolicy Unrestricted # Import general helpers using dot operator . .\Functions_General.ps1 # Load parameters $settings = Import-Csv…

Viewing tracked messages and other BizTalk admin scripts

Hierbij een interessante link m.b.t. het ophalen van tracked messages via code en een link die verwijst naar interessante SQL en Powershell queries http://connectedthoughts.wordpress.com/2008/04/02/3-ways-of-programatically-extracting-a-message-body-from-the-biztalk-tracking-database/. Deze link is handig voor het tonen van tracked messages. Deze worden gecomprimeerd opgeslagen in de DTA database. http://biztalkadmin.com/more-useful-biztalk-sql-queries/

Suspended instances via Powershell

Hieronder is een script voor het ophalen en opslaan van suspended instances. Het is handig om de beschikbare BizTalk WMI objects te kennen. Zie link: http://msdn.microsoft.com/en-us/library/aa560069.aspx # Aanroep list suspended instances: .bts-get-suspended-msgs -action list # Save messages suspended instances: .bts-get-suspended-msgs -action save ‘c:paulsuspendedmsg’ Ik heb geprobeerd om specifieke contextproperties op te halen, bijvoorbeeld InboundTransportLocation. Volgens…