Symptoms
When a WCF-SQL send port that uses a ColumnEncryptionSettings=Enabled value calls a stored procedure that queries a table that has a "varchar(max)" type encrypted column, the WCF-SQL adapter does not read the encrypted column. Additionally, the following error message is generated:
A message sent to adapter "WCF-SQL" on send port "******" with URI "mssql://************" is suspended.
Error details: System.InvalidOperationException: Retrieving encrypted column 'Data' with CommandBehavior=SequentialAccess is not supported.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Resolution
This problem is fixed in the following cumulative updates for BizTalk Server:
-
Cumulative Update 2 for BizTalk Server 2020
-
Cumulative Update 8 for BizTalk Server 2016
References
For information about the service packs and cumulative update list for BizTalk Server, see the following article in the Microsoft Knowledge Base:
2555976 Service pack and cumulative update list for BizTalk Server
For more information about BizTalk Server hotfixes, see the following article in the Microsoft Knowledge Base:
2003907 Information about BizTalk hotfixes and Cumulative Update support