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