Devart Oracle 8.3.146 and Batch Updates Exception

[GrMikeD]

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]

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]

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]

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]

Hi, I already did it yesterday

[Shalex]

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

[Shalex]

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]

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.