System.ArgumentNullException: Value cannot be null.

Srikanth Ram 1

The adapter failed to transmit message going to send port "SendPort25" with URL "mssql://xxxxxxxxx". It will be retransmitted after the retry interval specified for this Send Port. Details:"System.ArgumentNullException: Value cannot be null.
Parameter name: key
at System.Collections.Generic.Dictionary2.Insert(TKey key, TValue value, Boolean add) at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient2.CreateChannelFactoryTChannel
at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient2.InitializeValues(IBaseMessage message) at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient2..ctor(IBaseMessage message, WcfTransmitter2 transmitter) at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfTransmitter2.GetClientFromCache(String spid, IBaseMessage message)
at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfAsyncBatch2.BatchWorker(List1 messages)".
BizTalk

Srikanth Ram 1 Reputation point

2021-07-15T05:03:52.68+00:00

How to execute stored procedure that returns response in BizTalk orchestration....
is there anyone , please help me out... I have tried all the ways to fix above issue but no luck.
what I am doing here is inserting order details into Orders table with help of stored proc.
for this I have created proc schema through Wizard ( with Consume Adapter Service ) while submitting file ,i'm getting above error
Kamlesh Kumar 3,861 Reputation points

2021-08-20T10:39:47.07+00:00

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

I would suggest checking the below Ms doc link to understand the basic about how to perform this,

Insert, update, delete, or select operations using BizTalk Server with the SQL adapter

Regards,
Kamlesh Kumar

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.