I’ve done this many times before, but today, I had numerous issues. 1. I didn’t give the C# subroutine a strong name, and thus it wasn’t in the GAC. This result in “Load Failure” or “Could not load file or assembly…” 2. GacUtil getting code 1 or code 3. I think the code 1 was […]
EventLog error on a typed-polling BizTalk WCF-SQL Receive Location There was a failure executing the receive pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “XML disassembler” Receive Port: “ReceivePort.dlsqldev1.tmwdev.Integration_Dev.GetSettlementTWMtoIseries” URI: “mssql://sqlserver//dbname?InboundId=XYZData” Reason: Finding the document specification by message type “http://schemas.microsoft.com/Sql/2008/05/TypedPolling/XYZData#TypedPolling” failed. Verify the schema deployed properly. Anybody around BizTalk a while knows what this error means […]
Suppose you have taken over someone else’s BizTalk orchestration, and it’s huge. You make some changes, and you get a compile error like this: error X2110: use of unconstructed message 'ExceptionMsg' Sometimes you can click on the error, and it will take you to the proper location. If that doesn’t work, here the “secret trick”. […]
Sometimes, links on the Microsoft and MSDN sites disappear or move, so I made a copy of the architecture diagram from BizTalk. It hasn’t been updated since then; while new features have been added, the architecture really hasn’t changed. BizTalk Server 2009 Runtime Architecture Poster NOTE: Download the above file (right-click Save-AS), then open with […]
Had to fix some code today left by a prior BizTalk developer. Error: Shape name: CreateTableTypeLogMessage ShapeId: 734241d3-f9aa-41da-8696-511010d815f7 Exception thrown from: segment 2, progress 102 Inner exception: There is no value associated with the property ‘EDI.ISA_Segment’ in the message. Explanation: When you drop an EDI file, all these fields will exist, and the code would […]
Scenario/Issue You drop an EDI file into a disk directory associated with a BizTalk Receive Location. Using Tracking or Routing, you see that the XML created begins with this: <pre> <ns0:X12_00401_204 xmlns:ns0="http://mycompany.com/X12/204/App2"> <ST> <ST01>204</ST01> <ST02>0001</ST02> </ST> </pre> but you are expecting the namespace to look like this: <pre> <ns0:X12_00401_204 xmlns:ns0="http://mycompany.com/X12/204/App"> </pre> Question Why is the […]
In a BizTalk map, you can add scripting functoids without connecting them to anything. They can contain functions, as shown below. Note 1: You must add a constant for each variable, so if you have 3 parameters, then add three constants values on the “Functoid Inputs” tab. Note 2: They will have a warning icon […]
Over time, I have found or developed several T-SQL (Transact-SQL) commands that you can run to help cross reference (XREF) various BizTalk entities. Most of these run against the BizTalkMgtmDB database. Here is a list of them, so they are easy to find: BizTalk SQL Queries 1. Simple list of Receive Ports and Receive Locations […]
Issue As shown below – you type in “biztalk” and search, and no matches are found, even though installed BizTalk 2020 after Visual Studio 2019. Solution Open Visual Studio 2019 with “no code” option, i.e. you don’t have to create a project to get VS2019 to open. From the menus at the top, click […]
Trying to delete a Send Port, you get this error: SendPort ‘sp_ABC’ is being referenced by one or more TPM Parties. Please remove the Send Port reference(s) from the parties and retry deleting the Send Port (Microsoft.BizTalk.ExplorerOM) By the way, TPM stands for “Trading Partner Management”. Explanation When you use EDISend Pipeline, BizTalk needs to […]