Page 1 of 1

Oracle - 00600 - issue on PrimaryKey

Posted: Fri 29 May 2020 14:03
by FabriceNSI
Hello developer Team,

I have an issue with a simple core query on the primary key:

ora-00600: internal error code, arguments: [qkeexhs], [121], [] ...

I tried two differents methods to achieve this goal with same error:

Method 1:

return await context.Set<TEntity>().FindAsync(id);

Method 2:

return await context.Set<Application>()
.Include(...)
.ThenInclude(...)
.SingleOrDefaultAsync(app=>app.id = id)

It's a code first application, the migration/seed data and other operations like (ToListAsync, AddSync ...) have been executed correctly. The issue seem to be only on FindAsync and SingleOrDefaultAsync operations.

The environment is:

Visual studio 2017, EntityframeworkCore.tools (2.1.1), devart.data.oracle.efcore (9.6.646) with direct connection.

Thank you, for your help.

Re: Oracle - 00600 - issue on PrimaryKey

Posted: Fri 05 Jun 2020 21:01
by Shalex
The error is caused by Oracle Server itself. Refer to http://www.dba-oracle.com/t_ora_00600_i ... string.htm. We recommend you to contact the Oracle Support Team.

You can deploy your application to another Oracle Server instance with a new database to make sure that the application works.

Re: Oracle - 00600 - issue on PrimaryKey

Posted: Mon 13 Jul 2020 09:49
by FabriceNSI
Hi,

if someone has the same problem:

The issue was solved without any intervention from the oracle side.
Only an update to net core 2.2 instead of 2.1 and devart version 9.7.734 instead of 9.6.634.

Ty,

Re: Oracle - 00600 - issue on PrimaryKey

Posted: Mon 13 Jul 2020 15:12
by Shalex
Thank you for your feedback.