Skip to content

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

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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