BizTalk World

  • BizTalk Custom Adapter Issue: Adapter error : Value cannot be null. parameter name : stream

    When we are new to create custom adapter in BizTalk. Then this issue is really irritated a lot. And it’s not easy to find out what is the real issue. Adapter error : Value cannot be null. parameter name : stream Solution: It is quite simple to get rid from this issue. When we define… Read more

  • EXCEL file reading from C# code

    There is require installing of DocumentFormat.OpenXml from nuget in visual studio or download DocumentFormat.OpenXml.dll and use in the project. Below is the code for reading Excel file and stored data in dataset. Namespaces: using DocumentFormat.OpenXml;using DocumentFormat.OpenXml.Packaging;using DocumentFormat.OpenXml.Spreadsheet;using System;using System.IO;using System.Collections.Generic;using System.Data;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Configuration;using System.Text.RegularExpressions; Method for Reading EXCEL file public static DataSet ReadExcelFile(string… Read more

  • JSON Error: Input string was not in a correct format

    Error Details: There was a failure executing the send pipeline <Pipeline Name> Source: “JSON encoder” Send Port: <Send Port Name> URI: <URI> Reason: Input string was not in a correct format. Reason: Most of the time when we generate schemas with XML or JSON or csv files with specified wizard (JSON Schema wizard, Flat File… Read more

  • Mapping with Envelop schema error

    Error details: The Messaging Engine failed while executing the outbound map for the message going to the destination URL <URL> with the Message Type <Message Type>. Document type <Document Type Name> does not match any of the given schemas. Reason:  This is happening when there is used Envelop schema as destination schema in mapping. And… Read more

  • BizTalk with Rest Service Form-Data

    when there is requirement to consume REST web service in Form-Data. BizTalk need to send request to REST Service in Form-Data format. And BizTalk always send data in JSON raw format by default. If we change the content type on send port still doesn’t work. So before sending file to REST Service, we need to… Read more

  • Tracking Messages in BizTalk

    Microsoft BizTalk server provides a great feature of message tracking. We can track each message processed in BizTalk either success or failure. For failure message we always check in suspended instance in BizTalk Admin console group hub. Or provide some exception management e.g. ESB management console to handle fault message and stored the message. For… Read more