bts_FindSubscriptions The conversion of the nvarchar value '623080000000000' overflowed an int column. RRS feed

  • Question

  • I have a TP sending me EDI with ISA05 = 623080000000000.  When I try to consume a message from this TP, I get the error listed above.  This only seems to occur in BizTalk Server 2020.  Why is the stored procedure trying to convert a Identifier to an integer?  More importantly, how can I fix this?



    Thursday, May 21, 2020 1:10 PM


  • This is a problem that is specific to SQL Server 2019 CU4.  It is resolved in CU5, and is related to the way SQL Server 2019 treated sql_variant data types in CU4.


    • Marked as answer by John Thay Sunday, July 19, 2020 4:16 AM
    Sunday, July 19, 2020 4:15 AM

All replies