BizTalk has a schedule job that does incremental backups, usually every 15 minutes. But what if you want to do a full backup immediate? Run this command in SQL Server Management Studio (SSMS): USE BizTalkMgmtDb EXEC sp_ForceFullBackup Then manually start the SQL agent job “Backup BizTalk Server (BizTalkMgmtDb)” (or wait until the next scheduled 15 […]
Full error looks something like this: Send Port: “sp_Vendor_Vendor_FilesToSendToAS2” URI: “http://as2.vendorsite.com/” Reason: The Encryption Certificate has not been configured for AS2 party. AS2-From: YourAS2ID AS2-To: VendorAS2ID Solution: Open the send port, click the “Certificate” item on the left. Then click the “Browse” button under the certificate, and select the certificate that applies to your vendor. […]
test This script can be scheduled to create a nightly backup of all the bindings and MSIs for all the applications in BizTalk. It uses the Powershell Extensions for BizTalk to enumerate the application names, then calls BTSTask once for the bindings, and once for the MSI. It gives you the ability to customize your […]
The purpose of this example is to demonstrate two ways to process Oracle data with a SQL query. First is by using the DataReader (streaming) and the second is by using the DataAdapter (fills an object in memory). Then as a bonus, we convert that data to HTML and email it. For an example of […]
I’m writing a custom deploy solution for BizTalk. If the application doesn’t exist, I need to call “BTSTask AddApp” to add it. Sample: Add-PSSnapIn -Name BiztalkFactory.PowerShell.Extensions function checkApplicationExists ($appName) { cd "Biztalk:\Applications" $apps = Get-ChildItem $boolFoundMatch = $false foreach ($app in $apps) { Write-Host " Testing $($app.Name) " if ($app.Name -eq $appname) { […]
PowerShell extensions allow you to interact with BizTalk Artificacts. For example, you can like list applications, sendports, receive ports, host instances, and enable/disable them in PowerShell. First run the InstallUtil <pre>C:\Windows\system32>c:\Windows\Microsoft.NET\Framework64\v4.0.30319\InstallUtil.exe "c:\Program Files (x86)\Microsoft BizTalk Server 2013\SDK\Utilities\PowerShell\BizTalkFactory.PowerShell.Extensions.dll"</pre> Output: Microsoft (R) .NET Framework Installation utility Version 4.7.2558.0 Copyright (C) Microsoft Corporation. All rights reserved. Running a […]
The goal of this program is to: 1) Rename the file to include the PONum from inside the file 2) Pretty-Print (format) the XML inside the file 3) Preserve (keep) the original date/time of the file <pre> cls function Format-XMLDoc ([xml] $xml, $indent=3) { $StringWriter = New-Object System.IO.StringWriter $XmlWriter = New-Object System.XMl.XmlTextWriter $StringWriter $xmlWriter.Formatting = […]
Requirements: I have some files from an external system, and I want to promote some data from inside the file to the file name itself. Example, original filename: PO_287783.xmlDesired filename: PO_287783_TransID_9081631_Lines_3.xml I want to peek into the file an pull out the Transaction ID, and also get a count of how many line items are […]
Every case is unique, but here’s what happened to me. My goal was to receive a CSV file, and have it split into multiple output files in the Send Port. I did specify my CSV flat-file pipeline in my Receive Location’s Pipeline. I took over a project at a new client. And while re-writing the […]
I got this error from the following Scripting Functoid with inline C# script: <pre> public int PutHL03() { if (hl01 > 2) return "I"; else if (hl01 == 1) return "S"; return "0"; } </pre> You can see it is returning string, but I specified the return type as “int”. Just changed […]