ServiceBrokerListener icon indicating copy to clipboard operation
ServiceBrokerListener copied to clipboard

Notification Loop Exception: System.OutOfMemoryException: Array dimensions exceeded supported range

Open insanity13 opened this issue 3 years ago • 0 comments

When we do a bulk update of all table rows (107 838 records), an error occurs:

Notification Loop Exception: System.OutOfMemoryException: Array dimensions exceeded supported range.
  at System.Data.SqlClient.TdsParser.TryReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj, Int32& totalCharsRead)
  at System.Data.SqlClient.TdsParser.TryReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
  at System.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName)
  at System.Data.SqlClient.SqlDataReader.TryReadColumnData()
  at System.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly)
  at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
  at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
  at Sallsa.Agent.Core.SQL.SqlDependencyEx.ReceiveEvent() 
  at Sallsa.Agent.Core.SQL.SqlDependencyEx.NotificationLoop(Object input) 

image

insanity13 avatar Oct 05 '22 06:10 insanity13