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, […]
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 […]
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 […]
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 […]
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 […]
My disk folder structure is like this: D:\Application\DEV D:\Application\DEV\Cust1 D:\Application\DEV\Cust1\Archive D:\Application\DEV\Cust1\Archive\210 D:\Application\DEV\Cust1\Archive\204 D:\Application\DEV\Cust1\Inbound D:\Application\DEV\Cust1\Inbound\204 D:\Application\DEV\Cust1\Inbound\210 D:\Application\DEV\Cust1\Outbound D:\Application\DEV\Cust1\Outbound\204 D:\Application\DEV\Cust1\Outbound\210 Similar for \Cust2 Similar for \Cust3 etc I was looking for a sample 210 EDI Invoice to use in testing; and I wanted the most recent ones. It turns out you can put a wildcard in the […]
Any time you use the BizTalk WCF Service Publishing Wizard, it creates an IIS website with various content, including a “Temp” directory. The Temp directory has two entries: 1) BindingInfo.xml – can be used to create a Receive Port and Receive Location tied to your published web service 2) WcfServiceDescription.xml – this is the one […]
To create a request-only (or one-way) webservice in BizTalk using the WCF-Service-Publishing-Wizard can be a little confusing at first. After the first couple of screens, the wizard shows the screen below You cannot delete the Response message. What you have to do is delete Operation1, then right click on the Service, select “Add Web method.”, […]
I’ve been doing a lot of “forensic” research on converting old systems lately. Sometimes I need to look at hundreds of ports at once, and opening each one separately to check the map is way to slow! There are several joins required. The actual mapname is in the more generic bts_item table. You can get […]
This program uses a mix of Object Explore Model (ExplorerOM) and BizTalk Provider for Powershell to delete Send/ReceivePorts that match certain naming conventions. We were refactoring an application and re-adding ports under a different application, so needed a script to delete the old pots. If you run this script, I do of course suggest you […]