BTDF Domain accounts must include the domain name. Local accounts must not include a domain or computer name.

BTDF (BizTalk Deployment Facility) gave this error during a deploy in Visual Studio to the local machine: Error: Domain accounts must include the domain name. Local accounts must not include a domain or computer name. Other people mention that you are using computer or domain account when the other is needed. In my case, my […]

BizTalk Sql Query to Lookup Party/Profile based on an identifier

You might open a file like this: ISA*00*          *00*          *ZZ*123000013      *ZZ*ABC3001        *160719*1600*U*00401*201160030*0*P*;~ and then want to know what is company with ID=123000013? I don’t know of any any way in the BizTalk Admin console to do a reverse lookup like this. <pre> select        P.PartnerId as 'ParterID',        P.Name as 'PartyName',        BP.Name as 'ProfileName',      BP.ProfileID,      BI.Qualifier, […]

Batch file script to download (clone) a specific branch from Git

We are using GitLab, an open source way to store source code on your own servers. I wanted to get all my branches into a clean directory, then recompile them to make sure everything had been checked-in properly. THe first step is to download all the branches into a directory. NOTE: Apparently the –single-branch option […]

Updated InsertGenerator to Handle Schema name when generating SQL insert statements

This is an updated version of “InsertGenerator” from CodePlex. This tools works great when you want to create a few insert statements from a table, and save them in a file; or to transfer a few rows from one system to another. It’s great for lookup/code tables I referred to this “how to build sql […]

Misleading BizTalk Error: Loading property information list by namespace failed or property not found in the list. Verify that the schema is deployed properly.

Error that I had to solve today <pre> The Messaging Engine failed while executing the inbound map for the message coming from source URL:"\\EDI1-FTP\Integrations\EDI1\ABCD\inbound\990\*.*" with the Message Type "http://MyComapny.Schemas.EDI.X12_00401.EDI990/v1.0#X12_00401_990". Details:"Loading property information list by namespace failed or property not found in the list. Verify that the schema is deployed properly. " </pre> My Solution I […]

Failure executing the receive pipeline: Reason: Finding the document specification by message type

Error Got the following error when posting to a BizTalk receive location from SOAP-UI, but could have happened with any type of receive location: <pre> HTTP/1.1 500 Internal Server Error Content-Type: application/xml; charset=utf-8 Server: Microsoft-IIS/8.5 X-Powered-By: ASP.NET Date: Thu, 05 Jul 2018 14:07:37 GMT Content-Length: 2384 <Fault xmlns="http://schemas.microsoft.com/ws/2005/05/envelope/none"><Code><Value>Receiver</Value><Subcode> <Value xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher"> a:InternalServiceFault</Value></Subcode></Code><Reason><Text xml:lang="en-US"> There was a […]