OracleException: ORA-00933: SQL command not properly ended

[Velu]

Hi,

We are using DOTNET6 with entity framework code first.
Devart v - 9.15.1410

In our project - Code first database and data seeding is working properly.

but, while starting the project we have got this error.

Please help us to resolve this.

Failed query at database end -

Code: Select all

SAVEPOINT "__EFSAVEPOINT";

Exception

Code: Select all

Devart.Data.Oracle.OracleException (0x80004005): ORA-00933: SQL command not properly ended
   at Devart.Data.Oracle.dr.a(ay A_0, Int32 A_1)
   at Devart.Data.Oracle.dr.e5(Int32 A_0, bx A_1)
   at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
   at Devart.Common.Entity.cs.ExecuteNonQuery()
   at Devart.Data.Oracle.Entity.ao.ExecuteNonQuery()
   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.CreateSavepointAsync(String name, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.CreateSavepointAsync(String name, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
Devart.Data.Oracle.OracleException (0x80004005): ORA-00933: SQL command not properly ended
   at Devart.Data.Oracle.dr.a(ay A_0, Int32 A_1)
   at Devart.Data.Oracle.dr.e5(Int32 A_0, bx A_1)
   at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
   at Devart.Common.Entity.cs.ExecuteNonQuery()
   at Devart.Data.Oracle.Entity.ao.ExecuteNonQuery()
   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)

[Shalex]

The bug with auto savepoints enabled in EF Core 6 transactions is fixed. We will notify you when a new public build of dotConnect for Oracle is available for download.

The internal build with the fix can be downloaded from http://download.devart.com/nuget_oracle_9_15_1419.zip.

[Shalex]

dotConnect for Oracle 9.16 is released: viewtopic.php?f=1&t=53190.