none
Send port fails with argument exception RRS feed

  • Question

  • When I insert records in Azure SQL using WCF-Custom adapter with sql binding and I am getting below error.

    The adapter failed to transmit message going to send port "SendPort3" with URL "mssql://xx//xxx?InboundId=xxx". It will be retransmitted after the retry interval specified for this Send Port. Details:"System.ArgumentException: Value does not fall within the expected range.

    I tried this on local sql database and it works fine.  I am using BizTalk 2013 R2 with CU1 and Microsoft SQL Azure (RTM) - 12.0.2000.8.

    Please help.  Thank you. 

    Tuesday, September 1, 2015 6:33 PM

Answers

  • I figured this out.  I forgot that Windows Azure SQL Database does not support distributed transactions.  So setting ambienttransaction to false resolved my issue. 
    • Marked as answer by BoozTalk Wednesday, September 2, 2015 12:09 AM
    • Edited by BoozTalk Wednesday, September 2, 2015 12:09 AM
    Wednesday, September 2, 2015 12:09 AM

All replies

  • Hi,

    Are you using Orchestration, if yes then the Operation name on the Orchestration Port and the Name in the mapping element must match. But If the message is subscribed directly from a Receive Port, then the Action field would contain only the Action value.

    Please check event viewer for error details. And please refer below MSDN article,

    Configuring a Port Using the WCF-Custom Adapter

    Refer related thread


    Thanks, If my reply is helpful please mark as answer or vote as helpful.

    Tuesday, September 1, 2015 7:22 PM
  • Thank you Kamlesh.  This works fine if I point to my local SQL instead of Azure SQL.  The only change I made after testing with my local SQL was updating the URI and credentials for SQL Azure. 
    Tuesday, September 1, 2015 8:17 PM
  • I figured this out.  I forgot that Windows Azure SQL Database does not support distributed transactions.  So setting ambienttransaction to false resolved my issue. 
    • Marked as answer by BoozTalk Wednesday, September 2, 2015 12:09 AM
    • Edited by BoozTalk Wednesday, September 2, 2015 12:09 AM
    Wednesday, September 2, 2015 12:09 AM