Devart Oracle 8.3.146 and Batch Updates Exception

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
GrMikeD
Posts: 22
Joined: Tue 10 Nov 2009 20:24

Devart Oracle 8.3.146 and Batch Updates Exception

Post by GrMikeD » Wed 07 May 2014 16:24

My .NET 4.0 ASP.NET Web API 1 application uses EF 6 with Devart Oracle 8.3.146 against Oracle 11g and every SaveChanges() fails with following exception stack:

Code: Select all

System.Data.Entity.Infrastructure.CommitFailedException: An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server. See the inner exception and http://go.microsoft.com/fwlink/?LinkId=313468 for more information. ---> System.InvalidOperationException: Unexpected query batch command.
   at Devart.Common.Entity.dx.d(ck A_0)
   at Devart.Common.Entity.dx.k()
   at Devart.Common.Entity.cv.b()
   at Devart.Common.Entity.bz.a(Object A_0, TransactionStateChangeEventArgs A_1)
   at Devart.Data.Oracle.OracleTransaction.Commit()
Config of Devart Provider:

Code: Select all

config.QueryOptions.NoEscapeLike = true;
config.QueryOptions.CaseInsensitiveComparison = true;
config.QueryOptions.CaseInsensitiveLike = true;
config.DmlOptions.BatchUpdates.Enabled = true;
config.DmlOptions.BatchUpdates.AsynchronousBatch = true;
config.DmlOptions.InsertNullBehaviour = Devart.Data.Oracle.Entity.Configuration.InsertNullBehaviour.Omit;
config.Workarounds.ColumnTypeCasingConventionCompatibility = false;
Some more details:

1) I do not use any explicit Transaction. Just grab entity from the db, change a field and save
2) I use native Oracle Client Tools for connecting to Oracle (no Direct Mode or Instanct Client)
3) It seems to work with provider version 8.3.115! Yet, not with any later
4) It also works with any driver if I disable Batch Updates
5) I have intercepted commands to verify that Oracle 11g syntax is used, not 12g
6) Devart DbMonitor does not display any details on the transaction

Any ideas???

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

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Post by Shalex » Fri 09 May 2014 13:46

1. Does your application work in the Direct Mode?
2. Please send us a small test project with the corresponding DDL/DML script for reproducing the issue in our environment.

GrMikeD
Posts: 22
Joined: Tue 10 Nov 2009 20:24

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Post by GrMikeD » Fri 09 May 2014 16:13

Shalex wrote:1. Does your application work in the Direct Mode?
2. Please send us a small test project with the corresponding DDL/DML script for reproducing the issue in our environment.
Hi, my application does not work in direct mode, uses Oracle Client Tools.

It will be not trivial to create a demo project. I notice that some entities can be saved with batch enabled, other cannot. Thus, it should have to do with some entity specific detail...

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

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Post by Shalex » Tue 13 May 2014 09:23

Please localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing the issue in our environment.

GrMikeD
Posts: 22
Joined: Tue 10 Nov 2009 20:24

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Post by GrMikeD » Tue 13 May 2014 09:35

Hi, I already did it yesterday

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

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Post by Shalex » Fri 16 May 2014 14:16

Thank you for the test project. We have reproduced the issue and are investigating it.

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

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Post by Shalex » Wed 28 May 2014 14:29

The bug with throwing the "Unexpected query batch command" exception when using the Batch Updates functionality is fixed. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

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

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Post by Shalex » Thu 29 May 2014 14:26

New version of dotConnect for Oracle 8.4 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=29687.

Post Reply