How to get Orchestration InstanceID (GUID) in BizTalk

The following is the generally document way fo doing this: System.Convert.ToString(Microsoft.XLANGs.Core.Service.RootService.InstanceId); However, sometimes, for no apparent reason, it won’t compile, or at least shows a “red dot” on the upper right corner of the expression shape, even though it is technically correct. Sometimes if you open it, and close it, or move it and move […]

BizTalk – Party – Sequence contains no elements

I deleted a BizTalk SendPort from the EDI agreement, but when trying to delete the same SendPort from the EDI Party, got the cryptic error: “Sequence contains no elements”. I had been doing a proof of concept with Role Links, and turned out that I still had the roles enlisted. I found that out when […]

Add files and commit to GIT from Powershell

The following Powershell function will add all files not yet added, then do a commit with the message provided in the call to the function, then do the push. The prerequisite is that the “GIT” command line is installed and available. I was earlier looking for an API, but I think this is the apparently […]

BizTalk WCF-SQL Invalid cast from ‘System.String’ to ‘System.Collections.Generic.IEnumerable`1

Full Error System.InvalidCastException: Failed to convert parameter value from a String to a IEnumerable`1. —> System.InvalidCastException: Invalid cast from ‘System.String’ to ‘System.Collections.Generic.IEnumerable`1 [[System.Data.Common.DbDataRecord, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]’. at System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) — End of […]

SQL to Retrieve BizTalk BatchingFilters for EDI Parties

The field “FilterBytes” contains the subscription filters for batching. We are converting from 2010 to 2013, and I need the a report of the “source of truth” as to which of our customers goes to which party, so we build the same parties correctly in 2013. <pre> select top 1000   p1.Name as PartnerNameA,   p2.Name as […]

Powershell sample program to write selected filenames (based on pattern) to a file (and/or console)

I needed a list of files from a huge directory of file for certain companies, and the company name was the prefix of the filename. The company names are added to an array of strings.  This script recursively gets all filenames in a given directory, tests them to see if the start with any of […]

BTDF xmlpreprocess /s:: Argument expects a parameter

BTDF deploy on local machine in Visual Studio by using “Tools”, “Deployment Framework for BizTalk”, “Deploy BizTalk Solution” failed with the following error in XmlPreprocess.exe /s:: Argument expects a parameter What caused the error for me was that I in the SettingsFileGenerator.xml spreadsheet, I had renamed all the “Settings File Names” for each environment.  I […]

How to create Biztalk “Document SpecName”

Document namespace is a combination of name and assembly of the schema, separate by a comma (and a space). Step-1. To find this you need to go to BizTalk Admin console then navigate to the application where you have deployed your schema DLL. Click on the Schemas (in the tree structure on the left) to […]