Devart Forums

Version 5.50.214.0
I am opening connection to the server with no issues, also when execute the same query with other (test application that i have created) provider no problem. as soon as i am using the dotConnect i am getting the below error.

any ideas ?

Devart.Common.o: Read less bytes than expected.
at Devart.Common.e.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.p.e(Byte[] A_0, Int32 A_1, Int32 A_2)
--- End of inner exception stack trace ---
at Devart.Data.PostgreSql.PgSqlDataReader.e(Int32 A_0)
at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.PostgreSql.Entity.j.a(CommandBehavior A_0)
at Devart.Common.Entity.b8.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at RunMccLogic.CentralLogic.GetApplicationKeys(ExternalSource src, String applicationName) in D:\Projects\MCC\hg_engine\RunMccLogic\CentralLogic.cs:line 643
at RunMcc.Application.Services.Central.Service.GetApplicationKeys(ExternalSource src, String applicationName) in D:\Projects\MCC\hg_engine\RunMcc.Application.Services.Central\CentralService.cs:line 184

Please give us the following information:
1. Does the issue persist with the latest (6.7.287) build of dotConnect for PostgreSQL?
2. Are you using pgPool? If yes, specify its exact version.
3. Tell us the version of your PostgreSQL server.
4. Can you reproduce the problem with a simple ADO.NET code ( http://www.devart.com/dotconnect/postgr ... eader.html )? If not, send us a small test project with the corresponding DDL/DML script for reproducing.
5. Are you executing code on the same workstation where PostgreSQL server (and pgPool) is installed?

Hi All

Here are the results for your test and questions :

1.The error is constant for any type of query using dotConnect with pgPool.

when you create a standard visual studio (using server explorer) connection and try to brows the table you get the exception.
when you use other providers Npg... you don't get the error.

2. The issue is also issue persist with the latest (6.7.287) build of dotConnect for PostgreSQL !!!!

3. Versions : pgpool-II-3.2.4, postgresql-9.2.

4. Problem reproduce with a simple ADO.NET code whit now problem, sorry i can not give you live connection to our database site, but attached screen the ado error.

5.The code is being executed on the application server not on the database server.

6.Pgpool provides us with multi muster replication, adding and removing nodes dynamically not just pooling, can your product do that ?

regards

Hi guys,
Can you please update...

Sorry for the delay. We are processing your request.