Posts

Troubleshooting Promoted Property Filtering in BizTalk

Introduction In this blog, I will address an issue I encountered while working with a receive location and provide a solution to fix it. Issue: I set up a receive location and dropped a message into it. Within the message, I had promoted a property called "results" using a schema. My intention was to filter the message in the send port using the condition "POCContextPropertyWithoutOrch.Schemas.PropertySchema.results == 2". However, despite my efforts, I was unable to capture the message at the send port. Solution After investigating the issue, I realized that the problem lied in the choice of pipeline for the receive location. Instead of using an XML receive pipeline, I had mistakenly chosen a pass-through pipeline. This oversight resulted in the properties not being promoted onto the context, causing the filtering condition to fail. To rectify this, I made the following adjustment: I changed the receive pipeline from pass-through to XML receive pipeline. This simpl...

Error: Cannot send a content-body with this verb-type.

Image
Introduction I encountered an error while making a GET API call via the BizTalk request-response send port. In this blog, I will share the steps I followed to fix the issue. Error: The adapter failed to transmit message going to send port "POCContextPropertyWithoutOrch.SP" with URL "https://randomuser.me/api". It will be retransmitted after the retry interval specified for this Send Port. Details:"System.Net.ProtocolViolationException: Cannot send a content-body with this verb-type. Server stack trace:     at System.Net.HttpWebRequest.CheckProtocol(Boolean onRequestStream)    at System.Net.HttpWebRequest.BeginGetRequestStream(AsyncCallback callback, Object state)    at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStreamAsyncResult..ctor(HttpWebRequest httpWebRequest, HttpOutput httpOutput, AsyncCallback callback, Object state)    at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.BeginGetOutputStream(Asyn...

Harnessing the Power of Custom XSLT in BizTalk Maps

Image
 Introduction: While BizTalk Mapper provides a robust and intuitive interface for most mapping scenarios, there are instances where the complexity of the mapping demands a more flexible approach. In such cases, leveraging custom XSLT (Extensible Stylesheet Language Transformations) allows us to exert fine-grained control over the transformation process. In this blog post, we will explore the steps involved in utilizing custom XSLT within a BizTalk map, highlighting the importance of understanding that BizTalk Mapper links are superseded when custom XSLT is employed. Step-by-Step Guide: Right click on the mapper grid and click on properties. Refer the XSLT file in the Custom XSLT path

Important lines of code in BizTalk

 strError = ex.ToString();  Here's an explanation of the code: "ex" is an exception object that represents an error or an exceptional condition that occurred during the execution of the code. The "ToString()" method is called on the exception object "ex". This method is used to convert the exception object into a string representation. The resulting string representation of the exception is then assigned to the variable "strError". varBizTalkConnStr=System.Configuration.ConfigurationSettings.AppSettings.Get("LookupDB"); Here's an explanation of the code: " varBizTalkConStr " is a variable that will hold the retrieved configuration setting value. " System.Configuration.ConfigurationSettings " is a class that provides access to the configuration settings in the application's configuration file. " AppSettings " is a property of the ConfigurationSettings class that represents the collection of key-v...

BizTalk Q and A

Image
In Visual Studio 2019, where can the path for the Visual Studio config file or deven.exe config file be found? C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE How do you set the object type in catch exception block properties in an orchestration? Is it possible to copy and paste a variable within the orchestration view? In the orchestration view, you can easily copy and paste a variable by following these steps: Right-click on the variable you want to copy. Select the "Copy" option from the menu. Paste the variable in the desired location. Remember, after pasting, you will need to manually change the variable name. The new variable will automatically inherit the same data type as the original one. If necessary, you can also modify the data type of the new variable. What is the shortcut key used for automatically completing a statement in the orchestration expression shape? CNTRL  + Space How can you access pipelines, maps, and schemas from another...

How to map multiple source message variables to one target message in an orchestration

Image
 Scenario In some cases, you might want to map multiple source variables to one target schema. This is because the data might be spread across 2 schemas. To do this follow the below steps. 1. Create a map via an orchestration. This will help you choose 2 message variables as a source and one Destination schema. Refer Fig 1 and Fig 2.                                               Fig 1                                    Fig 2 2. This will create the map as shown in Fig 3. Here you can see that a map has been created with multiple source schemas and one target schema. Now you can perform your mapping based on the data you have in these 2 schemas. Fig 3 Hope this helps. Happy coding.

How do you fix this error: WFX to XSD schema generation module is not installed

Image
Introduction: Encountering the error message "WFX to XSD schema generation module is not installed" while generating schemas using the schema generator can be frustrating. Fortunately, there is a straightforward solution to resolve this issue. This blog post will guide you through the necessary steps to fix the error and get back to your BizTalk Server development smoothly. Solution: Step 1: Run Command Prompt as Administrator To begin resolving the error, open the Command Prompt with administrative privileges. Follow these steps: Press the Windows key on your keyboard. Type "Command Prompt" in the search bar. Right-click on "Command Prompt" and select "Run as administrator." Step 2: Execute the Installation Scripts In the Command Prompt window, execute the following commands one by one: cscript "C:\Program Files (x86)\Microsoft BizTalk Server\SDK\Utilities\Schema Generator\InstallWFX.vbs" cscript "C:\Program Files (x86)\Microsoft...