PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: Two errors are presented when adding/editing a substance from ACX or reviewing Audit table in Inventory 10
Topic Summary: Oracle error ORA-00600 by adding/editing an ACX substance or reviewing Audit table
Created On: 12/11/2013 6:35 PM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 12/11/2013 6:35 PM
User is offline View Users Profile Print this message


Aldo

Posts: 41
Joined: 7/11/2011

The following two issues are presented when adding/editing a substance or reviewing Audit table in Inventory 10. Both are related to an Oracle error ORA-00600 (database version 10.2.0.3). These functions were working before.

1. Click on ‘Create New Container’ or ‘Edit Container and select a new substance from the ACX database. The following error occurs

OraOLEDBerror '80040e14'

ORA-00600: internal error code, arguments: [kkqsadjo-1], [], [], [], [], [], [], [] ORA-06512: at "CHEMINVDB2.COMPOUNDS", line 362 ORA-06512: at line 1

/cheminv/api/createsubstanceOraSP.asp, line 47

2. Review Audit table and got this message:


OraOLEDB error ‘80040e14’

ORA-00600: internal error code, arguments: [kkqsadjo-1], [], [], [], [], [], [], []

/cheminv/gui/AuditReport_std_display.asp, line 240



Edited: 12/11/2013 at 6:55 PM by Aldo
 12/11/2013 6:38 PM
User is offline View Users Profile Print this message


Aldo

Posts: 41
Joined: 7/11/2011

From Oracle Metalink:

Try disabling Query Rewrite;

SQL> alter system flush shared_pool; --->>> needed to reparse the statement!!!
SQL> alter session set query_rewrite_enabled = false;
SQL>


You can use it at system level too, setting the following parameter in the pfile

query_rewrite_enabled = false

Below is the complete post from Metalink:

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 16-Jan-2012***

Symptoms

ORA-00600: internal error code, arguments: [kkqsadjo-1]

is signalled during query execution. The stack trace will be similar to:

kkqsadjo kkqsbsjg kkqsechk2 kkqsechk kkqspsum kkqsedrv kkqsfssl kkqsSetOpGRW kkqsRewriteCurrentQ kkqscqb kkqsptq kkqsptqur kkqsrdrv kkqdrv opiSem opiprs kksParseChildCursor rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0

Cause

This issue seems the same as that investigated in unpublished bug 5389508 ORA-600: INTERNAL ERROR CODE ARGUMENTS: [KKQSADJO-1], [], [],
-> RDBMS Ver: 10.2.0.1
-> Closed, Could Not Reproduce

The cause of the error was not identified.

Solution

There is no solution for this issue, but to workaround it try disabling Query Rewrite;

SQL> alter system flush shared_pool; --->>> needed to reparse the statement!!!
SQL> alter session set query_rewrite_enabled = false;
SQL>


You can use it at system level too, setting the following parameter in the pfile

query_rewrite_enabled = false


FuseTalk Basic Edition v4.0 - © 1999-2017 FuseTalk Inc. All rights reserved.