Oracle - 00600 - issue on PrimaryKey

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
FabriceNSI
Posts: 2
Joined: Fri 29 May 2020 13:25

Oracle - 00600 - issue on PrimaryKey

Post by FabriceNSI » Fri 29 May 2020 14:03

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle - 00600 - issue on PrimaryKey

Post by Shalex » Fri 05 Jun 2020 21:01

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.

FabriceNSI
Posts: 2
Joined: Fri 29 May 2020 13:25

Re: Oracle - 00600 - issue on PrimaryKey

Post by FabriceNSI » Mon 13 Jul 2020 09:49

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,

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle - 00600 - issue on PrimaryKey

Post by Shalex » Mon 13 Jul 2020 15:12

Thank you for your feedback.

Post Reply