In BizTalk 2013/VS 2012 development, I got the following error: #Error: Errors exist for one or more children Cause: Typically this problem is usually associated with problems in Orchestration Designer “refactoring” or “graphical interpretation” and in a certain way it isn’t a “valid error”, ie, it doesn’t describe the real problem. What seems to happen…
Exception: A message sent to adapter “WCF-SQL” on send port <Send Port Name > with URI “mssql:<Database Server > is suspended. Error details: Microsoft.ServiceModel.Channels.Common.UnsupportedOperationException: The action “<BtsActionMapping xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” > <Operation Name=”operation_1″ Action=”TypedProcedure/dbo/<stored Procedure Name>” / > </BtsActionMapping >” was not understood. Solution: This issue is mainly occur when we setup SOAP Action Header on…
Now this issue has been fixed by Mirosoft with latest version of Visual Studio 2019 & also Microsoft releases Cumulative update 3 for BizTalk 2020. Faulting application name: devenv.exe, version: 16.8.30709.132, time stamp: 0x5fa9c41fFaulting module name: KERNELBASE.dll, version: 10.0.14393.3986, time stamp: 0x5f77edfaException code: 0xe0434352Fault offset: 0x000dc562Faulting process id: 0x27a0Faulting application start time: 0x01d780453a839eecFaulting application path:…
Issue: When we are creating the Custom adapter in BizTalk, it is one of common issue happen while open send port to configure the custom adapter. Failed to instantiate adapter CLSID:{guid} Assembly file:<assembly file name> Type name: <typename> as below: Solution: When we are creating dll for Receive/Send port configuration – AdapterManagement We need to…
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…
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…