3 min read
BizTalk Server WCF-SQL adapter error: Subquery returned more than 1 value. This is not permitted ...
Sandro Pereira
Aug 28, 2024
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
2 min read
There was a failure executing the send pipeline: Microsoft.BizTalk.DefaultPipelines.XMLTransmit, ...
Sandro Pereira
Apr 24, 2024
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
4 min read
BizTalk Server WCF-SQL: Invalid object name while using temporary tables
Sandro Pereira
Apr 23, 2024
It is pretty common to use temporary tables to perform some internal logic inside your SQL queries or scripts I have seen several
2 min read
BizTalk Server WCF-SQL: The certificate chain was issued by an authority that is not trusted.
Sandro Pereira
Apr 18, 2024
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
2 min read
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Sandro Pereira
Apr 9, 2024
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
2 min read
BizTalk WCF-SQL Adapter Error: Retrieval of Operation Metadata has failed while building WSDL at ...
Sandro Pereira
Apr 8, 2024
Today while importing/generating a WCF-SQL schema for a new BizTalk Server solution, we got the following error inside Visual Studio: Error while
2 min read
BizTalk WCF-SQL Error: System.NotSupportedException: The SqlDbType “” is not supported
Sandro Pereira
Mar 17, 2021
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
5 min read
BizTalk WCF-SQL Error: Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed f...
Sandro Pereira
Oct 9, 2018
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
4 min read
BizTalk WCF-SQL Error: System.Data.SqlClient.SqlException (0x80131904): Procedure or function ...
Sandro Pereira
Jul 19, 2018
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
