Skip to content

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

@insanity13

Description

@insanity13

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions