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

Hi,
This issue was solved by updating/setting "Unicode" value to "TRUE" before executing "ExecuteNonQuery()"
Thanks for reply.

Hi All,
As a part of DB migration we are moving from Oracle to PostgreSQL v11. During insertion we are unable to save the column data which all are having special characters like "€" or any other special character.
Our server encoding methodology is "UTF 8" and client encoding set to "UTF 8". Still facing the issue.
Can anyone suggest how to resolve the issue?