Devart Forums

Hi Team,
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()
at

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.