Integration Basics

 Error: Microsoft.XLANGs.Core.XTransformationFailureException: Error encountered while executing the transform XYZ Map. Error:Transformation failed. The application does not exist. . ---> System.Xml.Xsl.XslTransformException: An error occurred during a call to extension function 'ReadString'. See InnerException for a complete description of the error. ---> System.Runtime.InteropServices.COMException: The application does not exist. Issue: The SSO values were not added to the SSO DB. Adding the SSO values via BTDF fixed the issue.

Error: I made a simple change to the map. I just hardcoded a couple of fields and deployed the solution to BizTalk. Then, I restarted the host instances. However, the map changes were not visible. Root cause: When I deployed it using BizTalk, it was not referencing/Gacing the DLL for some reason. I had to manually GAC the DLL, and after a host instance restart, the issue was fixed.

 Error: I was getting weird errors while trying to build an orchestration project. When I checked the code everything was alright. I spent a lot of time troubleshooting. Root cause: I had added this line of code in the catch block.  instanceId = System . Convert . ToString ( Microsoft . XLANGs . Core . Service . RootService . InstanceId ); In some cases, I had to add a space after the semicolon. In other cases,  I had to remove the space after the semicolon and I had to build the project and that worked. This issue was not easy to troubleshoot.

Error: Microsoft.XLANGs.RuntimeTypes.XPathUpdateException: A failure occurred while evaluating the property Order.Common.Schemas.PropertySchema.FileName against the message part data. The message part data does not contain at least one of the nodes specified by the XPath expression (listed below) that corresponds to the property. The cause for this error may be that the message part data has not been initialized or that the message part data does not conform to the message part schema. Ensure that the message part data is initialized correctly. XPath expression: /*[local-name()='SalesOrderCanonical' and namespace-uri()='http://Order.Common.Schemas.SalesOrderCanonical']/*[local-name()='SalesOrder' and namespace-uri()='']/*[local-name()='Header' and namespace-uri()='']/*[local-name()='FileName' and namespace-uri()='']    at Microsoft.XLANGs.Core.XSDPart.SetPayloadProperty(PropertyDefinition pd, Object val)    at EDI.GordonFo...

 Error: Adapter: BizTalk WCF web HTTP adapter Process flow: Sending a json message via post methd I was getting a 400 response from Oracle API with an error stating that unable to parse the payload. Root cause: There was an issue with the payload sent to the API. Line items were sent as an object instead of an array of objects Incorrect payload: Correct payload: Fix Set Max occurs to unbounded for Lineitems root node

 Error: Could not enlist send port. The text associated with this error code could not be found Root Cause: The issue occurred after a BTDF deployment Solution/ Work around Delete the send ports and import the bindings manually and you should be able to start the ports.

Error: The XPath expression '/*[local-name()='OrderCanonical' and namespace-uri()='http://Order.Common.Schemas.SalesOrderCanonical']/*[local-name()='SalesOrder' and namespace-uri()='']/*[local-name()='Header' and namespace-uri()='']/*[local-name()='DCNumber' and namespace-uri()='']' selected a node which is not valid for property or distinguished field retrieval, or it selected no node at all. Only text-only elements or attributes may be selected. Solution: To resolve this issue  follow the steps outlined below: Check Input Message: First, ensure that the input message contains the field you are trying to retrieve, in this case, the 'DCNumber' field. If the 'DCNumber' field is not present in the input message, the XPath expression will fail. Verify the structure and content of the input message to confirm the presence of the 'DCNumber' field. Map a Dummy Value: If the 'DCNumber' fiel...

Scenario When attempting to convert XML to JSON format using the map in the BizTalk send port, I encountered an issue. The output I received was not in the expected format. Please note that the XML format would be then converted to the corresponding JSON format by means of a JSON encoder. Expected format     < Order >         < CustomerPO > 1234 </ CustomerPO >         < DeliveryDate > 0610202312:00 </ DeliveryDate >         < OrderSource > Sales Order </ OrderSource >         < LineItems >             < LineItem >                 < ItemNumber > 1111 </ ItemNumber >                 < OrderQuantity > 2 </ OrderQuantity >                 < UnitOfMeasure > CASE </ Unit...

 Error: I encountered the following error while testing a BizTalk map in Visual Studio: Error Exception Caught: Cannot load source/destination schema: POCSinglePointAPI.Schemas.SinglePointRequest.  Either the file/type does not exist, or if a project dependency exists, the dependent project is not built. C:\Users\c-vJayanarayanan\source\repos\POCSinglePointAPI\POCSinglePointAPI.Maps\CanonicalSalesOrder_TO_SinglePointRequest.btm 1 Solution: Right click on the map project and build the solution After successfully building the solution, the test map should function properly.

 Error I encountered the following error while attempting to deploy a BizTalk project using Visual Studio: Login failed for user "abc" Solution I faced this issue after downloading the project from Azure DevOps. Under the deployment tab of the project, an incorrect server name was specified, leading to the error. To resolve this problem, I followed these steps: I corrected the server name to the appropriate value. I attempted another deployment after making the necessary change. The deployment was successful without any further issues. By ensuring the correct server name was used, I was able to resolve the login failure error and proceed with the deployment smoothly. Please make sure that you change the server name in all the dependent projects as well.

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...

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...