Insufficient data left in message

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
golisomeshwar
Posts: 3
Joined: Tue 12 Apr 2022 11:13

Insufficient data left in message

Post by golisomeshwar » Mon 02 May 2022 13:11

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

DmitryGm
Devart Team
Posts: 152
Joined: Fri 11 Dec 2020 10:27

Re: Insufficient data left in message

Post by DmitryGm » Wed 04 May 2022 13:54

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.

Post Reply