Lots of System.FormatException/OverflowException/InvalidCastExceptions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
s4duser
Posts: 2
Joined: Fri 24 Jul 2020 08:32

Lots of System.FormatException/OverflowException/InvalidCastExceptions

Post by s4duser » Tue 15 Sep 2020 16:55

Hi, there seems to be a problem when update data tables.

Reading and Adding new rows to tables is fine. But when we attempt to update an existing row.

The update performs correctly, but then is immediately followed by one or more of these errors:
Exception thrown: 'System.OverflowException' in mscorlib.dll
Exception thrown: 'System.FormatException' in mscorlib.dll
Exception thrown: 'System.InvalidCastException' in mscorlib.dll

This seems to have only started happening on Thursday. That seems to have coincided with a Windows 10 update.

I rolled back the windows update, but the problem still exists. I'm running Windows 10 version 2004: (10.0.19041 Build 19041)
It does not prevent the program from building/running, but when multiple updates happen it severely slows down development. For example, closing our setup menu item takes nearly 20 seconds in visual studio, but less than a second when running the same .exe outside of visual studio.

It does not appear to be limited to a single project either. Other project using dotConnect PostgreSQL have the same issue on this machine.

We are running:
Devart.Data.PostgreSql.PgSqlConnection, Devart.Data.PostgreSql, Version=7.3.201.0
and .Net Framework 4.7.2

Thanks

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Lots of System.FormatException/OverflowException/InvalidCastExceptions

Post by Shalex » Tue 22 Sep 2020 17:29

Your provider version 7.3.201 10-Jul-14 is outdated. Please upgrade to the newest version 7.18.1730 17-Sep-20.

If this doesn't help, send us a small test project and specify the steps we should follow for reproducing the issue.

Post Reply