Devart Forums

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)

Velu

.netCore 3.1

To solve this issue temporarily. Add Entity framework interceptor like this

Code: Select all

 public class NVarcharInterceptor : DbCommandInterceptor
    {
        public override InterceptionResult<DbDataReader> ReaderExecuting(System.Data.Common.DbCommand dbCommand,
            Microsoft.EntityFrameworkCore.Diagnostics.CommandEventData eventData,
            Microsoft.EntityFrameworkCore.Diagnostics.InterceptionResult<DbDataReader> result)
        {
            if (dbCommand.CommandText.Contains("N''"))
            {
                dbCommand.CommandText = dbCommand.CommandText.Replace("N''", "''");
            }

           return base.ReaderExecuting(dbCommand, eventData, result);
        }
    }

add this interceptor in

Code: Select all

DbContextOptionsBuilder<DbContext> builder

 builder.AddInterceptors(new NVarcharInterceptor())

This will solve the character set mismatch issue in EFCORE 3.1

Velu

Hi,

We are using .netcore 3.1
and
Devart internal build https://download.devart.com/nuget_oracle_9_10_921.zip .

We have already shared the sample project with you. [39708]

After executing this query in LINQ we got Character set mismatch error.

Linq query
(from lst in _ControlfileRepository.GetAll()
select new ControlFileCORE()
{
COL_NAME = lst.COL_NAME == "" ? "" : lst.COL_NAME,
VALUE = lst.VALUE == "" ? "" : lst.VALUE,
Id = lst.Id
}).ToList();

Oracle Query generated by this LINQ query is:

SELECT CASE
WHEN c.COL_NAME IS NULL THEN N''
ELSE c.COL_NAME
END COL_NAME, CASE
WHEN c.VALUE IS NULL THEN N''
ELSE c.VALUE
END VALUE, c.Id
FROM CONTROLFILE c

How can we handle this?

[In the previous version of .net this is working fine]

Please help us to solve this issue.

Velu

Hi,

We are using .Netcore 3.1

Devart: 9.9.892 Internal build

We have facing this issue while getting value from the database.

COLUMN NAME AND DATATYPE:
discriminator nvarchar2(1000)

Query generated by DEVART IS :
SELECT a.Id, a.CreationTime, a.CreatorUserId, a.Discriminator, a.Name, a.TenantId, a.Value, a.EditionId
FROM AbpFeatures a
WHERE (a.Discriminator = TO_NCLOB('EditionFeatureSetting')) AND ((a.EditionId = '1') AND (a.Name = 'Default'))
FETCH FIRST 1 ROWS ONLY

at this point, we have the issue.

Please help us to solve this.
Thanks

Velu

HI,

We implemented Devart 9.6.540 drivers for entity framework 2.1.1 and we got the following error.

Devart.Data.Oracle.OracleException (0x80004005): ORA-00923: FROM keyword not found where expected

We found that keyword user is present in Oracle query.

Sample project sent to : [email protected]

Thanks.

Velu

Hi,

We are using aspnetcore 2.1 modal first with entity framework.

When we run the add-migration "initial" command we got following error.
The ' ' does not support value conversions. Support for value conversions typically requires changes in the database provider.

System.NotImplementedException: The ' ' does not support value conversions. Support for value conversions typically requires changes in the database provider.
at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping.Clone(ValueConverter converter)
at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMappingSource.<FindMappingWithConversion>b__7_0(ValueTuple`3 k)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMappingSource.FindMappingWithConversion(RelationalTypeMappingInfo& mappingInfo, IReadOnlyList`1 principals)
at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMappingSource.FindMapping(MemberInfo member)
at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.PropertyDiscoveryConvention.IsCandidatePrimitiveProperty(PropertyInfo propertyInfo)
at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.PropertyDiscoveryConvention.Apply(InternalEntityTypeBuilder entityTypeBuilder)
at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ImmediateConventionScope.OnEntityTypeAdded(InternalEntityTypeBuilder entityTypeBuilder)
at Microsoft.EntityFrameworkCore.Metadata.Internal.Model.AddEntityType(EntityType entityType)
at Microsoft.EntityFrameworkCore.Metadata.Internal.InternalModelBuilder.Entity(TypeIdentity& type, ConfigurationSource configurationSource, Boolean throwOnQuery)
at Microsoft.EntityFrameworkCore.Metadata.Internal.InternalModelBuilder.Entity(Type type, ConfigurationSource configurationSource, Boolean throwOnQuery)
at Microsoft.EntityFrameworkCore.ModelBuilder.Entity(Type type)
at Microsoft.EntityFrameworkCore.Infrastructure.ModelCustomizer.FindSets(ModelBuilder modelBuilder, DbContext context)
at Microsoft.EntityFrameworkCore.Infrastructure.RelationalModelCustomizer.FindSets(ModelBuilder modelBuilder, DbContext context)
at Microsoft.EntityFrameworkCore.Infrastructure.RelationalModelCustomizer.Customize(ModelBuilder modelBuilder, DbContext context)
at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.CreateModel(DbContext context, IConventionSetBuilder conventionSetBuilder, IModelValidator validator)
at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
at System.Lazy`1.CreateValue()
at .GetModel(DbContext , IConventionSetBuilder , IModelValidator )
at Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel()
at Microsoft.EntityFrameworkCore.Internal.DbContextServices.get_Model()
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProviderEngineScope scope)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, ServiceProviderEngineScope scope)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProviderEngineScope scope)
at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider()
at Microsoft.EntityFrameworkCore.Internal.InternalAccessorExtensions.GetService[TService](IInfrastructure`1 accessor)
at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.CreateContext(Func`1 factory)
at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.CreateContext(String contextType)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.AddMigration(String name, String outputDir, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.AddMigrationImpl(String name, String outputDir, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
The ' ' does not support value conversions. Support for value conversions typically requires changes in the database provider.

Please help us to solve this issue.

in 4.5.20 drivers with entity 2.0 has been worked properly.

Thanks.

Velu

Hi,

As per our observation, We are getting Index was outside the bounds of the array error in 11G and in 12C we are getting [ORA-00918: column ambiguously defined] for same code.

This error occurred when we apply pagination code like .Skip and .Take. (using LINQ)

Request you to solve this ASAP.

Thanks

Velu

Ticket ID: 239422 is open for more than 2 weeks. Can you please help us to solve this issue.

Velu

We are waiting for the mail. Please help us in this.

Velu

Thanks. We are eagerly waiting for the mail.

Velu

Any luck in identifying the problem. We are waiting for your reply. Please help us in this.

Velu

Please help us in this problem. We are waiting for your reply.

Velu

Any luck in this problem. Please help us in this.

Velu

Hi,

Please check thicket, We are waiting for your reply.

Its very urgent,

Request you to solve this problem...

Thanks

Velu

HI,

Please help us to resolve this issue,
We are waiting for your response.

Thanks

Devart Forums

Search found 23 matches

OracleException: ORA-00933: SQL command not properly ended

Re: ORA : Character set mismatch

ORA : Character set mismatch

ORA-00932: inconsistent datatypes: expected - got NCLOB

OracleException ORA-00923: FROM keyword not found where expected

The ' ' does not support value conversions.

Index was outside the bounds of the array (CORE 2.0/ORACLE)

Re: .netcore 2.0 'ORA-00920: invalid relational operator'

Re: .netcore 2.0 'ORA-00920: invalid relational operator'

Re: .netcore 2.0 'ORA-00920: invalid relational operator'

Re: .netcore 2.0 'ORA-00920: invalid relational operator'

Re: .netcore 2.0 'ORA-00920: invalid relational operator'

Re: .netcore 2.0 'ORA-00920: invalid relational operator'

Re: .netcore 2.0 'ORA-00920: invalid relational operator'

Re: .netcore 2.0 'ORA-00920: invalid relational operator'