Page 1 of 1

Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Wed 07 May 2014 16:24
by 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???

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Fri 09 May 2014 13:46
by 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.

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Fri 09 May 2014 16:13
by GrMikeD
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...

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Tue 13 May 2014 09:23
by 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.

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Tue 13 May 2014 09:35
by GrMikeD
Hi, I already did it yesterday

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Fri 16 May 2014 14:16
by Shalex
Thank you for the test project. We have reproduced the issue and are investigating it.

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Wed 28 May 2014 14:29
by 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.

Re: Devart Oracle 8.3.146 and Batch Updates Exception

Posted: Thu 29 May 2014 14:26
by 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.