none
Biztalk Server Error: System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded. RRS feed

  • Question

  • I have created composite to insert update data to Data base:

    With Store procedure:

    Create Store A( parameter a, parameter b ....)

    As

     if(Exist(select A from tableA)) then

    Update tableA

    else 

    Insert tableA

    Create Store B( parameter a, parameter b ....)

    As

     if(Exist(select A from tableB)) then

    Update tableB

    else 

    Insert tableB

    In application have use Parallel for insert /update to 2 table: tableA, tableB. (Resource data select from table C).

    In Biztalk Application I am setting : MaxpoolingSize: 1000

    when run application biztalk call store procedure  with 150.000 records

    then biztalk server thow exception below after 30 minute running:

    The adapter failed to transmit message going to send port "P020M001_InsertMasterTableToDeliveryTable_SndRcvPort" with URL "mssql://.//MDMDB?". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.ConnectionException: A severe error occurred on the current command.  The results, if any, should be discarded. ---> System.Data.SqlClient.SqlException: A severe error occurred on the current command.  The results, if any, should be discarded.

    Result: tableA insert 32.000 Records, tableB 

    Please suggest me a solution to solve

    why biztalk throw exception A severe error occurred on the current command.  The results, if any, should be discarded.

    Thanks & best Regards

    Friday, July 22, 2016 3:35 AM

Answers

  • Hi,

    At High level it looks it is error due to query connection timeout and no issue from BizTalk Server end, couple of pointers to this issue,

    1) Check MSDTC setting and it should allow long running distributed transactions.

    2) Check on SQL server for Remote Connections and the timeout for remote connections

    https://technet.microsoft.com/en-us/library/ms177457(v=sql.105).aspx

    try once with setting its value to 0 (is equal to disabled)


    Hope this Helps!!!

    Please Mark as Answered if you satisfy with Reply.

    • Proposed as answer by vikas.a.mehta Friday, July 22, 2016 5:27 AM
    • Marked as answer by Angie Xu Thursday, July 28, 2016 1:56 AM
    Friday, July 22, 2016 5:26 AM

All replies