I have come across this "failed to execute sql error" Microsoft should do something to provide more info in the error message. In your case it looks like some problem with the DTC which is running on the biztalk machine, are u using a transaction shape in your orchestration? Depending on the serialization(transaction serialization not object serialization) mode this error can occur even when select is used.
Search this Site:
Recent Posts
- Logic App Consumption deployment: The secret of KeyVault parameter cannot be retrieved. Http status code: ‘Forbidden’. Error message: ‘Access denied to first party service
- BizTalk Server Visual Studio project: attempted re-targeting of the project has been canceled.
- BizTalk Oracle Adapter error: The assembly required for type mapping not found.
- PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
- Friday (funny) Fact: There is no size limit for the Logic App parameter name