When we are uploading excel with more than 50,000 records, facing issue like "Insufficient data left in message". I have verified the data with insert statement with previous statement and didn't see any difference. Could you please check and need support on this.
Devart.Data.PostgreSql.PgSqlException (0x80004005): insufficient data left in message at Devart.Data.PostgreSql.t.a(Boolean A_0, Boolean A_1, Char A_2, Boolean A_3) at Devart.Data.PostgreSql.g.b(aa A_0) at Devart.Data.PostgreSql.aa.ai() at Devart.Data.PostgreSql.PgSqlCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) at Devart.Common.DbCommandBase.ExecuteNonQuery()
The error "insufficient data left in message" can occur in cases when a value in incorrect format is passed to a table field on the server. For example, if you pass a value 'abcd' (string) for a field of the uuid data type. Or your string data has a null character "\0" in it.
For a more accurate diagnosis, we need a sample of your data and DDL for the database table.