Aug 28
BizTalk Server WCF-SQL adapter error: Subquery returned more than 1 value. This is not permitted ...
Welcome back to another blog post on the saga of BizTalk Serve errors and warnings, causes and solutions This morning started off excitingly as I had to go
Apr 24
There was a failure executing the send pipeline: Microsoft.BizTalk.DefaultPipelines.XMLTransmit, ...
I wrote this issue many years ago in this blog post, and I'm revisiting it to add more information about it because today I got the same error while trying to
Apr 23
BizTalk Server WCF-SQL: Invalid object name while using temporary tables
It is pretty common to use temporary tables to perform some internal logic inside your SQL queries or scripts I have seen several
Apr 18
BizTalk Server WCF-SQL: The certificate chain was issued by an authority that is not trusted.
Today, while trying to generate a new WCF-SQL Schema from Visual Studio, we got the following error: Connecting to the LOB system has failed A
Apr 9
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Following yesterday's blog post, on the same note, when we tried to generate a WCF-SQL stored procedure schema for a new BizTalk Server solution, we got the
Apr 8
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Today while importing/generating a WCF-SQL schema for a new BizTalk Server solution, we got the following error inside Visual Studio: Error while
Mar 17
BizTalk WCF-SQL Error: System.NotSupportedException: The SqlDbType “” is not supported
Recently while I was testing an integration solution on a client that uses WCF-SQL to insert data on a SQL Server database I got the following
Oct 9
BizTalk WCF-SQL Error: Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed f...
And yes, this is just another "Login failed for user" SQL Server WCF-Adapter related error In the past I wrote about a similar topic BizTalk WCF-SQL
Jul 19
BizTalk WCF-SQL Error: System.Data.SqlClient.SqlException (0x80131904): Procedure or function ...
Today while trying to test a solution where it was supposed to invoke a SQL Server Stored Procedure with optional parameters thru the BizTalk Server WCF-SQL
Jul 5
BizTalk WCF-SQL Error: Microsoft.ServiceModel.Channels.Common.ConnectionException: Cannot open da...
To finalize, maybe, these series of Errors and Warnings… Causes and Solutions let’s describe and address a fairly simple one that from time to time
